Creating a project via REST errors out if the lookup based attribute contains the @WHERE:PARAM:[email protected] parameter

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

SCENARIO:
1. The project contains an attribute based on a dynamic lookup.
2. The lookup query contains the @WHERE:PARAM:[email protected] parameter.
Example of query:

SELECT @SELECT:CAT.ID:[email protected],
@SELECT:CAT.Z_SERVICE:[email protected]
FROM ODF_CA_Z_CATALOGUE CAT
JOIN SRM_RESOURCES RES ON RES.USER_ID = @WHERE:PARAM:[email protected]
WHERE @[email protected]
AND RES.UNIQUE_NAME = 'xc_admin'

3. Try to create a project via REST populating the lookup attribute

Expected Results: The project to be created successfully.
Actual results: The project creation errors > CMN-0009: Attribute 'Catalogue' has invalid Lookup Value '5003289'

Environment

Clarity PPM 15.7, 15.7.1

Resolution

This works OK in 15.8
On prior releases:

Workaround: Provide the user ID instead of passing the parameter:

SELECT @SELECT:CAT.ID:[email protected],
@SELECT:CAT.Z_SERVICE:[email protected]
FROM ODF_CA_Z_CATALOGUE CAT
JOIN SRM_RESOURCES RES ON RES.USER_ID = 5003289
WHERE @[email protected]
AND RES.UNIQUE_NAME = 'xc_admin'