GROUPS: JSON range search with dates YYYYMMDD

Home / Manuals /

For range time search, customers should use the format where the year comes first, followed by the month, and then the day, (eventually hours, minutes, seconds) because we use a text range search.

YYYY<any symbols or empty>MM<any symbols or empty>DD<any symbols or empty>HH<any symbols or empty>mm<any symbols or empty>SS

YY<any symbols or empty>MM<any symbols or empty>DD<any symbols or empty>HH<any symbols or empty>mm<any symbols or empty>SS

Note: yyyy, dd, ss could be any case, but MM – month, mm – minutes

Example1:

{
“searchPattern”: [
{
“property”: “Fabrication/End”,
“range”: {
“min”: “today.format(\”YYYYMMDDHHmmSS\”)”,
“max”: “(today+14days).format(\”YYYYMMDDHHmmSS\”)”
},
“exact”: true
}
]
}

Example2:

{

“searchPattern”: [

{

“property”: “Fabrication/End”,

“range”: {

“min”: “today.format(\”YYYYMMDDz\”)”,

“max”: “(today+14days).format(\”YYYYMMDDz\”)”

“exact”: true

}

]

}

No data was found

GROUPS: JSON range search with dates YYYYMMDD

For range time search, customers should use the format where the year comes first, followed by the month, and then the day, (eventually hours, minutes, seconds) because we use a text range search.

Example1:

Example2:

Explore

Manuals

Contact & Follow

Policy

Subscribe to our newsletter