Hi Jamie
WHERE clauses are typically AND, so the scenario you described, in general, should work..
I picked a random table and went into SE16 - you'll see something like this
I picked 3 random fields - activity status, employee status and training status and said if all 3 are 1, along with EE group = 1 and EE subgroup between U1 and U9. I see the above rows - only 2 rows should be returned in my query based on my criteria.
Query builder shows this for the where clause
You should check zero padding on your fields in the search criteria - default is zero padding. In my case they are text fields, so I needed to set no padding on the search criteria screen
Run time search criteria
I only see rows that meet my criteria.
If you share your query, someone on community might have a tip. Alternatively, you could open a Support ticket, and they can help you debug any issues you may be having.
Best Regards,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle North America
------------------------------
Original Message:
Sent: 05-15-2019 15:51
From: Jamie Borja
Subject: Query: Criteria IF statements for multiple fields possible?
Hello,
When creating selection criteria, is there a way to say if field A, B, and C, all 3 fields = 0 ("A" could have a value, B and C are zero, but in this case it's not met). Even though the criteria fields have "AND" in between fields, my extract results show its treated as OR. Need to combine fields as a criteria, curious if possible?
------------------------------
Jamie Borja | SAP BSA IT
Bloomin Brands, Inc. Tampa, FL
------------------------------