A Parameterized lookup shows no values in the drop down list in the Modern User Experience (UX). The lookup works correctly in Classic Clarity. This may be reported for lookups using a dynamic query with a constraint.
Note: If you remove WHERE:PARAM:USER_DEF:STRING:PARAM_PROJECT from the lookup's query, the issue doesn't happen.
STEPS TO REPRODUCE:
Create a custom object as a sub object to the project object
- Create a custom dynamic lookup (object: Task) with below query:
Create a custom attribute on the custom object:
- Make sure the custom object is API Enabled
Go to the Modern UX
Add the new custom object as a module to a project Blueprint
Create a new project and populate the project’s Blueprint as that updated in Step 5
Create at least one milestone task on the project
Go to the custom object's Module on the project
Add the custom attribute created in step 3 to the column list
Click + to create a new row and enter the required attribute details
Search for values on the custom attribute or click on the drop down to try to select a value
- Select Data type of lookup
- Associate the attribute to the lookup created above
- Enter an API Attribute ID
- Under Lookup Parameter Mappings select odf_parent_ID from the drop down for param_project
Expected result: The attribute shows all milestones for the project as available to select from
Actual results: The drop down list is blank and no values can be selected
In the app-ca.logs, the following error shows:
ERROR 2021-03-29 14:41:05,767 [http-nio-80-exec-35] ppm.rest (clarity:admin:…:PPM_REST_API) LookupFilterParser :: The lookup [Custom_AttributeName] filter [((searchText startsWith '%') and (param_param_project = 5000001))] attribute[param_param_project] has invalid value .