Design Tools & Output Technologies - JDE1 (MOSC)

MOSC Banner

A better way to construct "Set User Selection" for this?

edited Jun 18, 2015 10:03AM in Design Tools & Output Technologies - JDE1 (MOSC) 3 commentsAnswered

Here are my fields

Car, Brand, Color, Units

Here's my data. I have max of 6 records at a time

  1. Honda, Civic, White, 1
  2. Honda, Civic, Black, 2
  3. Honda, Civic, Silver, 3
  4. Honda, Civic, Green, 4
  5. Honda, Civic, Blue, 5
  6. Honda, Civic, Gray, 6

As you can see, Car and Model fields are the same. The only differences are Color and Units. I'm planning to have 4 "Set User Selection" statements for each record (24 total). I don't know if there's a limit to number of conditions in data selection or not.  For example

Car Equal Honda And

Brand Equal Civic And

Color Equal White And

Units Equal 1 OR

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