Stringified Value Format: Difference between revisions
		
		
		
		
		
		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> | 
  | 
| decimal number | 1 | ||
| date | 2 | 2yyyy-MM-ddTHH:mm:ss.fff | 
  | 
| 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 | 
  |