Add a query

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

You can create queries either during initial creation of a data view or afterward.

To add a query to an existing data view

1. In the navigation rail, select Data modeling. Then select Data Views.

2. Select a data view. In the side sheet, select Edit Data View .

3. Select Manage queries.

4. Select Create query.

To add a query

5. (Optional) In the Query Id field, enter an ID over the default value.

6. In the Query Value field, enter a query include eligible streams in the data view. Use the query tooltip for information on how to query for streams.

   A maximum of 100,000 streams can be included in the data view. After the entered query returns streams, select a stream to details about it in the side sheet.

7. (Optional) To add additional queries to the data view, select Create query and repeat the steps listed above.

   When a data view includes multiple queries, each query is executed independently to generate the list streams. Stream duplicates may be returned by different queries.

8. After you are satisfied with your queries and and the results returned, select Apply.

Ineligible data items

Ineligible data items lists streams returned by your configured queries that cannot be included because they do 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 an 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)