Process notifications: Parameterized lookup attributes

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

We have built a process that sends an action item. The action item description contains a custom parameterized lookup attribute. 

The action item notification though shows  ablank value for the variable, even if it is populated at object level.

 

STEPS REPRODUCE:

 

1. Create a custom project subobject

2. Create a lookup attribute that pulls the tasks of the project: Task lookup

3. Lookup query used:

SELECT 

@SELECT:tsk.prid:id@

, @SELECT:tsk.prname:name@

, @SELECT:tsk.prwbssequence:seq@

FROM PRTASK tsk

WHERE @FILTER@

AND tsk.prprojectid = @WHERE:PARAM:USER_DEF:INTEGER:p_project_id@

4. At the attribute set the parent_object_id mapping

5. Create a process on the above subobject

6. Set an action item creation at a given step

7. Action item description contains the following variables:

   Object Code${thissubobject.code} 

   Object Name${thissubobject.name}

   Task lookup ${thissubobject.tarea}

8. Validate the process

9. Create a subobject instance

10. The process start and send the notification

11. Look at the notification content.

 

Expected Results: Object Name, Object Code, and Task Lookup to show their current values

Actual results: Object Name and object Code variables are populated. Task Lookup is blank

Cause

Lookup query needs to be modified

Resolution

Modify the lookup query from:

 

SELECT 

@SELECT:tsk.prid:id@

, @SELECT:tsk.prname:name@

, @SELECT:tsk.prwbssequence:seq@

FROM PRTASK tsk

WHERE @FILTER@

AND tsk.prprojectid = @WHERE:PARAM:USER_DEF:INTEGER:p_project_id@

 

To: 

 

SELECT 

@SELECT:tsk.prid:id@

, @SELECT:tsk.prname:name@

, @SELECT:tsk.prwbssequence:seq@

FROM PRTASK tsk

WHERE @FILTER@

AND (tsk.prprojectid = @WHERE:PARAM:USER_DEF:INTEGER:p_project_id@ OR

@WHERE:PARAM:USER_DEF:INTEGER:p_project_id@ is NULL)