Stringified Value Format

From QPR ProcessAnalyzer Wiki
Revision as of 10:32, 29 October 2020 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

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