Stringified Value Format: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 32: Line 32:
||
||
|-
|-
||small integer
||small integer (at maximum 2 147 483 647)
||4<number value>
||4<number value>
||
||
Line 41: Line 41:
||5<number value>
||5<number value>
||
||
* 3000000000 -> 53000000000
* -12345678900 -> 5-12345678900
|-
|-
||boolean
||boolean

Revision as of 10:32, 29 October 2020

QPR ProcessAnalyzer uses the stringified value format in filters when they are defined using the JSON format. The stringified format encodes data of different types into a string format. This conversion is needed because a pure JSON only supports strings, numbers and booleans.

The stringification is done for each data type according to following rules:

Data type Format Example
string 0<string value>
  • Patricia White -> 0Patricia White
  • 321 -> 0321
  • (empty string) -> 0
decimal number 1<decimal value>
  • 74.435 -> 174.435
  • 0.1 -> 10.1
  • 0.0 -> 10.0
  • -1.456 -> 0-1.456
date 2yyyy-MM-ddTHH:mm:ss.fff
  • 1st of July 2018 -> 22018-07-01T00:00:00.000
  • 12th of October 2021 at 08:34 -> 22021-10-12T08:34:00.000
null value 3
small integer (at maximum 2 147 483 647) 4<number value>
  • 1234 -> 41234
  • -300 -> 4-300
large integer 5<number value>
  • 3000000000 -> 53000000000
  • -12345678900 -> 5-12345678900
boolean 6True or 6False
timespan 7d.HH:mm:ss.fff
  • 2 days -> 72.00:00:00.000
  • 6 hours -> 70.06:00:00.000
  • 1.3 seconds -> 70.00:00:01.300