My Oracle Support Banner

E1: GRID: Enhancement request - How To Use AND & OR In Single Query? (Doc ID 2414069.1)

Last updated on JULY 17, 2018

Applies to:

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

Symptoms

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:

 

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!

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