Complex filterCriterion
Summary
Complex filterCriterion with both AND and ORContent
I'm trying to create a complex filterCriterion on data in a VBCS business object SDP that is based on values of two different input variables. One is a select-one list of values and the other is input text.
The condition is:
ledgerName = ledgerVar AND (controlNumber contains searchVar OR controlName contains searchVar OR description contains searchVar)
It appears using the filterCriterion builder you can only have match all (AND) or match (ANY) but not both can be used. When I use AND, no results and using OR it returns all records. Creating the JSON manually, I cannot make it work. I've tried to build a string for the q parameter but not sure how to format to get the results needed.