My Oracle Support Banner

E1: GRID: Enhancement Request - Ability To Use AND & OR In Single Query (Doc ID 2414069.1)

Last updated on MARCH 08, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 and later
Information in this document applies to any platform.


Is it possible to setup a AND & OR in the single query?
For example:
In order to identify all active recurring billing lines in Property Management (P1502), the user would have to show anything where: (the start date is less than today and the end date is
greater than today) OR (the start date is less than today and the end date is blank).

Setup in Advance query as shown below:





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.