Export Contains Blank Values

Products

• Clarity PPM On Premise

Issue/Introduction

When exporting to Excel, one field is not displaying data in the export. It is a dynamic lookup field with values dependant upon another attribute that is based upon a static lookup.

Environment

Release : 15.6

Component : CA PPM APPLICATION

Resolution

modified the lookup to contain the following items in bold, for each select statement in the query. This seems to have resolved two problems: 

1) Cannot filter by dependent attribute unless using the primary attribute first

2) The export now works quickly and includes all values, not just TBD

and ( @WHERE:PARAM:USER_DEF:STRING:wf_company_goal@ = 'wf_tbd' or @WHERE:PARAM:USER_DEF:STRING:wf_company_goal@ is null)

@BROWSE-ONLY: 

and lookup_code in ('wf_tbd')

:BROWSE-ONLY@

Additional Information

Another example, modify second query below as displayed in bold;

and clv.lookup_type = 'Z_AAA_DDL'
@BROWSE-ONLY:and parent_lookup_code 
= @where:param:user_def:string:z_cluster@
and is_active = 1
:BROWSE-ONLY@
and @filter@

 

and clv.lookup_type = 'Z_AAA_DDL'
and (@where:param:user_def:string:z_cluster@ = parent_lookup_code or @WHERE:PARAM:USER_DEF:STRING:z_cluster@ is null)
and @FILTER@
@BROWSE-ONLY:
and is_active = 1
:BROWSE-ONLY@