When running a report using live data on learning, the filter selector is missing values for several fields as per the screenshot below.
Online Report Designer
Reproducing the Issue
- Create a ORD report of LMS domain
- Go to Manage Filters or Runtime filters
- Select a Filter field
- Click on Report Values
- Try to search for a specific value
- See that there are no values on the box "Or, select from available value(s) below:" as per screenshot above.
The LMS team do not offer the filter value lookup for fields because this would have a performance impact on learning. Some fields have a database index over them or there is a picklist and they can be offered to the user to select. For others it would have to do a full scan the database which would be a performance hit.
This is an expected behavior. It is possible to write the field on the search box that the filter will work succesfully.
2470892 - ORD filter for LMS is not showing all values
Filter - Analytics - Learning - ORD - Runtime Filter , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, ORD) , LOD-SF-LMS-REP , Reporting Data , LOD-SF-ANA-ORD , Online Report Designer , Product Enhancement