Add a query

Each data view includes one or more query. These queries determine what data items (streams or assets) are included in the data view.

To add a query

1. (Optional) From Query Id, overwrite the default value of Query1 with a unique identifier.

2. From Query Source, select a namespace or community to query operational data from. The source can either be a namespace from your own tenant or a community.

   You can filter the namespaces and communities that are listed using the slide toggles and the filter field.

   Getting This namespace does not allow data to be processed outside of the region where it resides while adding a query? See Data view troubleshooting.

3. From Query Type, select the type of object that you want to search for in the query source: Streams or Assets.

4. From Query Value, enter a query to find the objects that you want to include in the data view. Then select Search.

   For more information on how to enter a query, see Search queries.

   When the query populates with objects, you can view more about each object by selecting it from the table. The object details display in the pane on the right.

   Each query is executed independently to generate the list of data items. It is possible to have duplicate data items resulting from different queries. This can be desirable or undesirable depending on the use case.

   There is a maximum of 100,000 data items that can be included in a data view. Note that each stream included will generate a data item, and as such a single asset may contribute multiple data items if it contains multiple stream references. Data items are ordered alphabetically by data item id within the data items collection.

5. (Optional) To add additional queries to the data view, select Add Query and repeat the steps listed above.

6. Once you are satisfied with your queries and query results, select Save.

Ineligible data items

The collection of ineligible data items represents resources that match the queries but cannot be included in the data view. A data item is ineligible if it does not contain at least one eligible non-key data item field.

A data item field is ineligible if its index is not appropriate for the data view, or if the field has a data type that may not be included in data views.

The following are examples of ineligible index:

• The index is compound (multiple properties)

• The index property data type differs from the data view data type

The following are examples of ineligible field types:

• Objects (nested type)

• Array (collection type)

• TimeSpan (time spans and nullable time spans are currently unsupported)

Next steps

Continue to Select data field sets.