Stringified Value Format

QPR ProcessAnalyzer uses the stringified value format in filters and expression queries for values appearing in JSON format. The stringified format encodes different types of data into strings that captures both the type and value of the data. The first character in the stringified format represents the type of the data.

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 (float)	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 (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 (duration)	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 -43 minutes -> 7-0.00:43:00.000
array	[ ... ] (same as JSON array where each item uses the stringified format)	empty array -> [] array with string "a" -> ["0a"] array with integers 1 and 2 -> ["41", "42"]