My Oracle Support Banner

SDK Program Using IQuery to Find Objects with Inactive List Value Is Not Returning Result (Doc ID 2526656.1)

Last updated on OCTOBER 21, 2021

Applies to:

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


Actual Behavior

Agile SDK program using IQuery to find a object which has List field with inactive list value returns 0 even though the object can be found by same query through Web Client.
'Include Inactive List Values' on my profile is set to 'Yes' for the user who is running Agile SDK program

Expected Behavior

Agile SDK program using IQuery to find a object which has List field with inactive list value to return the correct result



- The issue is present even on the environment where Agile PLM or above which fix below issue:
Note:2690207.1 SDK IQuery Returns No Results For Inactive Change Analyst

- The issue happens when querying for any list field with inactive value.


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

  1. Log into Web Client, and go to My Setting. Click Preferences tab, and confirm "Include Inactive List Values" is set to:"Yes"
  2. Create Change, and set Change Analyst field as: User1
  3. Run Advanced Search with below criteria:
    Change  | Object Search
    Change Analyst  |  In  |  User1
  4. Confirm Search Results returns results
  5. Log into Java Client as admin user, search for user: User1, and change Status of User1 to Inactive, and Save
  6. Re-log into Web Client, and run the same Advanced Search in step 3 again. Confirm it still returns the same result
  7. Run SDK program with below code. Make sure the username set for the user to create SDK session is the same user who confirmed the search works in Web Client:
  8. Query returns 0 results




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

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