ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 4066

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

The browse window 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:[email protected],
    @Select:t.prname:[email protected]
    From prtask t
    Where @[email protected]
    And t.prprojectid = @where:param:user_def:integer:[email protected]

  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

Cause

This issue is caused by CLRT-55121

Environment

This issue applies to CLARITY 12.1, 13.0, 13.1, and 13.2

Resolution

This issue has been fixed in CLARITY 13.3.

Workaround:

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

 

 

Additional Information

See also: Lookups master KB for Clarity