Issue

Record count decreases when the Allow Query option is enabled in a List view that uses a data page sourced from a Report Definition containing complex properties such as association fields and embedded properties.

A List view is configured using a data page that retrieves data from a Report Definition. The Report Definition includes complex properties such as association fields and embedded properties. When the Allow Query option is enabled, fewer records display. Investigation confirmed that the List View query mechanism supports querying only on scalar (simple) properties. As a result, records that depend on complex properties, such as association fields and embedded properties, may not be included in the query results, causing the displayed record count to be lower than the total available records.

Symptoms and Impact

After enabling the Allow Query option, the number of records that display has decreased from 108 to 78. When the option is disabled, all 108 records display. This may seem as though records are missing or being filtered unexpectedly.

Steps to reproduce

1. Create a Report Definition containing association fields, embedded properties, or other complex properties.
2. Create a data page that sources data from the Report Definition.
3. Configure a List view using the data page.
4. Enable the Allow Query option.
5. Compare the record count before and after enabling the option.
6. Observe that fewer records display when complex properties are present.

Root Cause

When the Allow Query option is enabled, List views support querying only on scalar (simple) properties. Complex properties, such as association fields and embedded properties, are not queryable in this context. Therefore, records that depend on these properties may be excluded from the query results, leading to a reduced record count.

Solution

For use cases requiring filtering on complex properties, such as association fields and embedded properties, use Insights instead of List views. Insights fully support querying on these field types and provide the required filtering capabilities while displaying all applicable records accurately. This behavior is verified as working as designed.