Unable to get expected records on report while filtering the Hardware records by life cycle stage and life cycle stage status fields - Known Error

Unable to get expected records on report while filtering the Hardware records by life cycle stage and life cycle stage status fields Description When using the Life Cycle Stage and/or Life Cycle Stage Status fields in filter condition in reports it does not work as expected in New UI.

Steps to Reproduce

1. Begin to create a new report, with "New UI" enabled 2. Select a configuration table for the data source (such as cmdb_ci) 3. For conditions, select "Lifecycle Stage" "Is" "Operational" 4. Run and/or save the report 5. Note that the breadcrumbs now reflect "Lifecycle Stage is empty" and the report returns an unexpected output.

6. If we switch to Classic UI ( set property glide.ui.report.old_report_builder to true to see the option), we see sysID instead of Operational value in the filter.

7. Update the value to Operational, save the report, and then run it to see the expected result.

8. Now if you switch to New UI, you will still see expected results and breadcrumb will show Operational but filter will show blank value.

Workaround Use the Classic UI ( set property glide.ui.report.old_report_builder to true) to build the report OR Use "contains" or "does not contain" instead of "is" or "is not" Related Problem: PRB1575537