My Oracle Support Banner

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 AUGUST 04, 2022

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.58 to 8.59 [Release 8.4]
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

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