Picklist labels are not available in object filter in advanced reporting queries / reports
Online Report Designer
Reproducing the Issue
- Open the report in Edit mode in report designer.
Open a query in Advanced Reporting directly.
- Select any object and go to Filter section of that object
- The picklist field will only show the numeric codes(raw data) and not labels.
This is expected behavior as this filter has only raw data available for comparison and it does not offer calculated column or other tables.
- Use only the internal code and Label fields in a separate query.
- Export the results.
- Use this as a reference to filter on the relevant values.
Internal Code , KBA , LOD-SF-ANA-ODS , Advanced Reporting , Problem