The BROWSE-ONLY query in NSQL is not working correctly

Document ID:  TEC1773662
Last Modified Date:  06/12/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA PPM

Releases

  • CA PPM:Release:14.2
  • CA PPM:Release:14.3
  • CA PPM:Release:14.4
  • CA PPM:Release:15.1
  • CA PPM:Release:15.2

Components

  • CA PPM SAAS USERS, GROUPS, OBS ADMINISTRATION INTERNAL ONLY:ODADM
  • CA PPM SAAS STUDIO INTERNAL ONLY:ODSTU
  • CA PPM USERS, GROUPS, OBS ADMINISTRATION - INTERNAL ONLY:PPMADM
  • CA PPM STUDIOINTERNAL ONLY:PPMSTU
Issue:
Steps to Reproduce:
 
1. Create a lookup that uses both an attribute parameter and a browse only
like below

SELECT
@SELECT:inv.name:p_name@
,@SELECT:inv.name || ' - ' ||
NVL2(inv.is_active,'ACTIVE','INACTIVE'):displayname@
,@SELECT:p.obj_request_type:project_type@
,@SELECT:inv.is_active:is_active@
FROM
INV_INVESTMENTS INV
INNER JOIN ODF_CA_PROJECT P on inv.id=p.id
WHERE
1=1
AND
p.obj_request_type= @WHERE:PARAM:USER_DEF:STRING:ptype_param@
@BROWSE-ONLY:
AND inv.is_active=1
:BROWSE-ONLY@

2. Create a new project attribute based upon the lookup
3. add the new attribute to a page
4. On Project A for the new field select Project X (which is active) and save
5. Project X shows up properly in the in the field
6. Now go to Project X and make the project inactive & save
7. Return to Project A and refresh the page and notice the field is now
blank. It should not be because it should not care about the browse only

Expected Result: field shouldn't be blank

Actual result: field is blank

Cause:

This is caused by CLRT-69512.

 

Resolution:

After a careful review on the defect by Sustaining Engineering, it has been decided to close it as Will Not Fix

Additional Information:

InstanceAttributeService is the place where values for the attributes will be fetched and getSelectValues() method serves for attributes whose data type is lookups.
Take a case of a Dynamic lookup that has 6 values and the NSQL query has BROWSE_ONLY with is_active as 1.
So one can select only active values when selecting values for the attribute.

What is happening is, in getSelectValues() method, LookupController ? getDynamicLookupValues() method is called with force parameter as false. A false as the force parameter returns only active values, and only displaying active saved values rather than all the saved values(ACTIVE|INACTIVE)

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >