README.md

Query Examples

Before you can build indexes and index queries it is essential to understand the structure of index tables. Read this document before proceeding!

Indexing and Querying by Example

Basic Indexing

The following examples illustrate index specification and query JSON bodies which can be used to index and query model property data.

• Get case insensitive Structural Material steel with a height > 0.5 ft

• Count the number of viewable objects in the index

• Get viewable rows where Revit category, family and type are not null

• Get viewable rows

• Determine the stats for Flange cut length

• Get rows where the Assembly Description is like '%Brick%'

Diff Indexing

The following examples illustrate index specification and query JSON bodies which can be used to create and query diff indexes.

• Get viewable rows

• Get rows where the Assembly Description is like '%Brick%'

• Get viewable elements where the element bounding box has changed

• Get rows where Elevation from Level has changed

• Get changed objects where the object's geometry has changed

---

Contributing

If you want to add more examples, please follow the steps below:

1. Fork this repo on github
2. Add your sample(s) to the basic or diff sub-folders. You can use the exampleTemplate.md to quickly format your example. Please base your examples on the sample models provided so that they can be verified by a maintainer.
3. DO NOT edit this README file by hand, use the readmeBuild.ps1 script located in this folder to re-build README.md
4. Create a PR!

back