Navigation :
Search Facts Query
JSON Structure
"queries": [
{
"@type": "SearchFactsQuery",
"pivotId": "",
"storeName": "",
"condition": {
"ProductQtyMultiplier": {
"$lt" : 1000,
"$gte" : 10
},
"$or" : [
{ "Id" : { "$lte" : 500 } },
{ "Id" : { "$gt" : 100 } },
{ "Desk" : { "$like" : "skB" } }
],
"ProductId" : {
"$in" : [17, 36, 42, 55]
},
"Status" : "DONE",
"$not" : { "IsSimulated" : "LIVE" }
},
"attributes": [
"attr1",
"attr2"
],
"firstResult": 0,
"maxResults": 1000
}
]
In the above example the resulting condition is:
- (ProductQtyMultiplier < 1000.0 AND ProductQtyMultiplier >= 10.0)
- AND ( Id <= 500 OR Id > 100 OR Desk LIKE “skB)
- AND ( ProductId in [17,36,42,55] )
- AND ( Status = “DONE” )
- AND ( NOT ( IsSimulated = “LIVE” ) )
Property Details
Property |
Values |
Default Value |
pivotId |
Name of Cube |
|
storeName |
String - Name of store |
|