E-AD/E-QRY: The 2-Tier Query Tool Does Not Display the Correct Boolean Value on the Logical Column, in the Criteria Tab, After it is Changed
(Doc ID 2742508.1)
Last updated on JANUARY 10, 2021
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.58 and later
Information in this document applies to any platform.
The 2-Tier Query Tool, opened from Application Designer, is not Displaying the correct boolean value on the Logical Column, in the Criteria tab, after it is Changed.
The issue can be reproduced with the following steps:
1. Open Application Designer.
2. Select Go > Query.
3. Open a query.
E.g.: File > Open > ACA_FULL_PART_TIME
4. Click on the Criteria tab:
5. Double click on one of the values in the Logical column and modify it (e.g.: if it was 'AND', modify it to 'OR').
6. Save the query.
7. Click on the SQL tab at the top, and, then, back on the Criteria tab.
Note that the value reverted back to 'AND'.
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