Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

How to get a union of two data sets?

edited Jul 4, 2017 5:01AM in Design Tools & Output Technologies - JDE1 (MOSC) 3 commentsAnswered

I have a business view that have two date fields (SRPDJ and CDJ). Users will enter into data selection whatever they want and I want to use whatever they entered and get all records that match that criteria and fall within date ranges for SRPDJ and CDJ

For example

Let's say users enter Community = 'OTT' into the data selection then

I want to get all records where Community is 'OTT' and SRPDJ is between 1/1/2016 and 12/31/2016

And

All records where Community is 'OTT' and CDJ is between 1/1/2017 and 12/31/2017

So it's a union of two data sets. Users will enter the date ranges into processing options but I hard code it here for simplicity.  Here's my code

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center