Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Complex filterCriterion

edited Feb 29, 2020 11:53PM in Visual Builder 1 comment

Summary

Complex filterCriterion with both AND and OR

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!