Stringified Value Format: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 23: Line 23:
||2yyyy-MM-ddTHH:mm:ss.fff
||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
||null value

Revision as of 22:47, 28 October 2020

QPR ProcessAnalyzer uses the stringified value format in several places when filters are defined using the JSON format. The stringified format encodes data of different types into a string format (which is supported by JSON format).

The stringification is done according to following rules:

Data type Prefix Format Example
string 0 0<string value>
  • Patricia White -> 0Patricia White
decimal number 1
date 2 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 3 (means null value)
Small integer 4
Large integer 5
boolean 6 6True or 6False
timespan 7 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