Stringified Value Format: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 1: | Line 1: | ||
QPR ProcessAnalyzer uses the '''stringified value format''' in | QPR ProcessAnalyzer uses the '''stringified value format''' in [[Filtering_in_QPR_ProcessAnalyzer_Queries|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 according to following rules: | The stringification is done for each data type according to following rules: | ||
{| class="wikitable" | {| class="wikitable" | ||
!'''Data type''' | !'''Data type''' | ||
! '''Format''' | ! '''Format''' | ||
! '''Example''' | ! '''Example''' | ||
|- | |- | ||
||string | ||string | ||
||0<string value> | ||0<string value> | ||
|| | || | ||
* Patricia White -> 0Patricia White | * Patricia White -> 0Patricia White | ||
* 321 -> 0321 | |||
* (empty string) -> 0 | |||
|- | |- | ||
||decimal number | ||decimal number | ||
||1 | ||1<decimal value> | ||
|| | || | ||
* 74.435 -> 174.435 | |||
* 0.1 -> 10.1 | |||
* 0.0 -> 10.0 | |||
* -1.456 -> 0-1.456 | |||
|- | |- | ||
||date | ||date | ||
||2yyyy-MM-ddTHH:mm:ss.fff | ||2yyyy-MM-ddTHH:mm:ss.fff | ||
|| | || | ||
Line 28: | Line 30: | ||
||null value | ||null value | ||
||3 | ||3 | ||
|| | || | ||
|- | |- | ||
|| | ||small integer | ||
||4 | ||4<number value> | ||
|| | || | ||
* 1234 -> 41234 | |||
* -300 -> 4-300 | |||
|- | |- | ||
|| | ||large integer | ||
||5 | ||5<number value> | ||
|| | || | ||
|- | |- | ||
||boolean | ||boolean | ||
||6True or 6False | ||6True or 6False | ||
|| | || | ||
|- | |- | ||
||timespan | ||timespan | ||
||7d.HH:mm:ss.fff | ||7d.HH:mm:ss.fff | ||
|| | || | ||
Line 54: | Line 53: | ||
* 1.3 seconds -> 70.00:00:01.300 | * 1.3 seconds -> 70.00:00:01.300 | ||
|} | |} | ||
[[Category: QPR ProcessAnalyzer]] |
Revision as of 10:17, 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> |
|
decimal number | 1<decimal value> |
|
date | 2yyyy-MM-ddTHH:mm:ss.fff |
|
null value | 3 | |
small integer | 4<number value> |
|
large integer | 5<number value> | |
boolean | 6True or 6False | |
timespan | 7d.HH:mm:ss.fff |
|