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