My Oracle Support Banner

SDK Query Returns Incorrect Results for Change Analyst (Doc ID 2940066.1)

Last updated on MAY 31, 2023

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

SDK Query returns incorrect results while searching for Changes with a User as Change Analyst, provided the User doesn't have the Change Analyst Role assigned.

EXPECTED BEHAVIOR

SDK Query should show correct results irrespective of the roles assigned to the User.

STEPS

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

  1. Login to Agile Web Client
  2. Create New Change Order and set user to Change Analyst, set status to Pending
  3. Change Lists attribute value on User's profile to blank
  4. Run the SDK Code with line

    SELECT * FROM [Changes] WHERE [Cover Page.Change Analyst] in '<LastName>,<FirstName> (<Userid>)' and [Cover Page.Status] not in ('$STATUSTYPE.COMPLETE' , '$STATUSTYPE.RELEASED' , '$STATUSTYPE.CANCEL')" ;

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!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.