Report Does Not Return Data When the Input Query Parameter Is Set As Blank/Empty/Null

(Doc ID 2407999.1)

Last updated on JUNE 08, 2018

Applies to:

Primavera Unifier - Version 9.7 and later
Primavera Unifier Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

On Unifier : Any Version

ACTUAL BEHAVIOR
---------------
Custom Report does not return data when the input query parameter is set as blank/empty/null.


EXPECTED BEHAVIOR
-----------------------
The report should return data even when the input query parameter is set as blank/empty/null.

STEPS
-----------------------
The issue can be reproduced at will with the following steps, in this example the report has more than one (1) input query parameter:

  1. Login Unifier
  2. Navigate to the applicable work space and open the custom report
  3. Select one value as the input parameter
  4. Keep blank as the second input parameter
  5. Click Report to show the result
  6. No results are returned


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot see the report out when second parameter is blank/empty/null

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms