My Oracle Support Banner

A Unifier Web Services Filter Condition Does Not Exclude Records That Do Not Fit the Criteria (Doc ID 2495884.1)

Last updated on MAY 06, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

When trying to use the Web Service XML call for getSpaceList and filter the results using filterCondition, records that do not match the filter condition are included in the result. Example:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:gen="http://general.service.webservices.skire.com">
     <soapenv:Header/>
     <soapenv:Body>
          <gen:getSpaceList>
               <!--Optional:-->
               <gen:shortname>SNEXAMPLE</gen:shortname>
               <!--Optional:-->
               <gen:authcode>AuthEXAMPLE</gen:authcode>
               <!--Optional:-->
               <gen:projectNumber>Abc123</gen:projectNumber>
               <!--Optional:-->
               <gen:spacetype>SpaceName</gen:spacetype>
               <!--Optional:-->
               <gen:fieldnames>?</gen:fieldnames>
               <!--Optional:-->
               <gen:filterCondition>lseSpaceNumTB250=100</gen:filterCondition>
          </gen:getSpaceList>
     </soapenv:Body>
</soapenv:Envelope>


When sending the command above, the resulting list of Spaces lists records that do not match the filter condition of "Data Element lseSpaceNumTB250 is equal to 100".

EXPECTED BEHAVIOR

The GetSpaceList XML command should filter the resulting space list to match the filter condition.

 

The issue can be reproduced at will with the following steps:

  1. Open the SOAP UI.
  2. Send the GetSpaceList XML command noted above.
  3. Observe the reported behavior.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.