MUX Filter in Grid on custom dynamic lookup is empty

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Custom Object: Modern UX, One dynamic query lookup is not showing any options in the filter dropdown but others are. This is just a dynamic lookup attribute, not parameterized. The values are displaying correctly in the columns just missing in filter drop down

Resolution

1. The issue is with the custom lookup dynamic query, it is not a proper NSQL lookup syntax
   Current query:
   select field1, field2,LAST_UPDATED_DATE from odf_ca_test where 1=1 AND @FILTER@
2. Please modify the query to have the correct syntax as follows:
   select @SELECT:p.field1:Field1@,
   @SELECT:p.field2:Field2@,
   @SELECT:p.LAST_UPDATED_DATE:LastUpdatedDate@
   from odf_ca_test p
   WHERE 1=1
   AND @FILTER@
3. You may have to update it via XOG (try on lower environment first) or create a new lookup and copy the saved data over to it.