A Browse Parameterized lookup does not return results when the parent lookup attribute is locked by a process.

Document ID : KB000004066
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

A Browse Parametereized lookup does not return results when the parent lookup attribute is locked by a process

Steps to Reproduce:

  1. Create a new lookup called "myParam" with an id of "myParam". The lookup should use a dynamic query.
  2. Type in the query text:

Select @select:t.prid:taskid@,
@Select:t.prname:taskname@
From prtask t
Where @filter@
And t.prprojectid = @where:param:user_def:integer:projid@

    3. Save and Continue

    4. Specify "taskname" as the display attribute on the Lookup Properties:Parent Window page

    5. Save and exit

    6. Create a new master object called "myObj" with an id of "myObj" and Save

    7. Create a new attribute called "myproj" with an id of "myproj"

    8. Choose Data Type Lookup and Save

    9. Choose Lookup "Project browse"

    10. Create a new attribute called "mytask", with an id of "mytask"

    11. Choose Data Type Lookup

    12. Choose Lookup of "myParam" and Save

    13. Under Lookup Parameter Mappings specify "myproj" for the Lookup Parameter "projid"

    14. Add both attributes (myproj and mytask) to the edit view of myobj.

    15. Click on Fields in the views and make "myproj" a Pull-down display type and "mytask" a Browse display type.

    16. Create a process on "myObj"

Object that will lock the "myproj" attribute

    17. Make sure that you have several projects with tasks in them

    18. Create a new instance of the "myobj" object filling all details EXCEPT the "mytask" attribute

    19. Initiate the process that will click the "myproj" attribute

    20. Click on the browse for the "mytask" attribute

Expected Results: The related tasks to the project will populate the browse window
Actual Results: Browse windows shows nothing

Environment:
This issue applies to CA PPM 12.1, 13.0, 13.1, and 13.2
Cause:

This issue is caused by CLRT-55121

Resolution:

This issue has been fixed in CA PPM 13.3.

Workaround:

Use pull-down as display type for the parameterized lookup.