Sorting Parameterized lookups defined WITHOUT a NULL clause does not work in Classic and Modern

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

 In BOTH Classic & Modern UX - parameterized lookups WITHOUT a NULL Clause is not sorting the data as expected.  

STEPS TO REPRODUCE:

1. Log in as an administrator and go into Classic Studio
2. Go to Administration -> Lookups
3. Create a copy of the Lookup Query from 'Idea and Project Category Parameterized Lookup' and modify it by removing the NULL Clause
4. Create a new Lookup with a similar name such as 'Idea and Project Param without IS NULL Clause'
5. Go to Administration -> Objects - > Project
6. Create a new attribute:
   Attribute name = Project Category NO NULL
   Select the new parameterized lookup
   Set the API Attribute ID value so it will show up on Modern UX
7. In CLASSIC UX - Add all 3 fields to the Project List View and the Filter Section
   Project Type (constraint field)
   Project Category (parameterized field with NULL Clause)
   Project Category NO NULL (parameterized field WITHOUT NULL Clause)
8. Look at the 'Lookup Mappings' for these fields and understand which parameterized values should appear based on the selected constraint value
9. In the Project List, be sure you have rows of data with saved values for all 3 fields.
10. Click the Header Name for the parameterized lookup fields 
    As expected, the stock 'Project Category' field sorts the data as expected - by the name of the saved value
    Unexpected: the new field WITHOUT NULL Clause does NOT sort as expected
11. In the MODERN UX - repeat steps 7-10

Expected Results: In BOTH Classic & Modern UX -The parameterized lookup WITHOUT NULL Clause should sort rows by the name of the saved value.  

Actual Results: In BOTH Classic & Modern UX - The parameterized lookup WITHOUT NULL Clause is not sorting the data as expected.  

Environment

Release: Any Clarity release

Component: Studio

Cause

This was reviewed as DE51792 and determined to be working as designed.

Resolution

Operations like filtering and sorting are not instance-level operations. So, they do not have the context of a particular project. This is why the parameter doesn't get passed in the above-mentioned queries.

Additional Information

See also: Lookups master KB for Clarity