> ## Documentation Index
> Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search Facts Query

> Reference for the `SearchFactsQuery` query type in a DEE order, used to extract facts from a `storeName` using condition filters such as `$lt`, `$or`, `$in`, and `$not`.

## JSON structure

```json theme={"languages":{"custom":["/engine/python-sdk/0.9/languages/pycon.tmLanguage.json"]}}
"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 |               |