Empty rows in Staffing Grid with dynamic Parameterized lookup on PostgreSQL

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Dynamic Parameterized Lookup added to MUX Grid in PostgreSQL will throw error operator does not exist: bigint = character and not return Grid records

 

STEPS TO REPRODUCE:

1. In Clarity Classic go to Administration – Lookups
2. Create a new Dynamic Lookup Z_TEST_LKP with query:

Defines a STRING parameter and comparing it to a VARCHAR column in the database

SELECT DISTINCT @SELECT:u.id:id@,

       @SELECT:u.user_name:name@

FROM CMN_SEC_USERS u

WHERE (@WHERE:PARAM:USER_DEF:STRING:p_test_param@ = u.user_name

       OR @WHERE:PARAM:USER_DEF:STRING:p_test_param@ IS NULL)

AND @FILTER@

1. Go to Project Object - Attributes.
2. Create a new Lookup attribute z_test
3. Select the Z_TEST_LKP lookup you just created.
4. In the Lookup Parameter Mappings section for this attribute, map the p_test_param parameter to a numeric field on the Project object – example, ObjectID
5. Go to MUX – Staffing Module – Staff Grid
6. Ensure you see results in the view there
7. Add the column z_test to the Staff Grid

 

Expected Results: The Staff Grid results rows to be the same amount as previously

Actual Results: With this attribute added, the grid will only return 0 rows (It’s Empty/ Blank)

In app-ca.log we can see the below exception:

ERROR 2026-06-10 18:21:55,573 [http-nio-8080-exec-138] persistence.PersistenceController (clarity:admin:5414748__298EBA20-8D69-4406-B9C1-256E64B3A79F:PPM_REST_API) (MUX-b8fb6206-3af9-4211-ae5b-2acdc4828378) Error happened with error code:42883

ERROR 2026-06-10 18:21:55,574 [http-nio-8080-exec-138] union.persistence (clarity:admin:5414748__298EBA20-8D69-4406-B9C1-256E64B3A79F:PPM_REST_API) (MUX-b8fb6206-3af9-4211-ae5b-2acdc4828378) Exception on odf-pmd.oba_staff.select-list-rest-api-conditional.map statement null

org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying

 

Environment

Clarity 16.4.2 with PostgreSQL

Cause

DE203766

Resolution

Fixed in:

• Clarity 16.4.3
• Clarity 16.4.2 Patch 1 (16.4.2.1)

 

Workaround: Remove the parameterized attribute from the MUX – Grid columns in that View