E1: GRID: Enhancement request - How To Use AND & OR In Single Query?
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:
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 hundreds of Community platforms