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.
Is it possible to setup a AND & OR in the single query?
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!