I’m trying to create a GET API call and need to check if a specific value is part of any of a subset of fields.
For example, in my data, I have 4 different mailing address fields (field1, field2, field3 and field4). I want my response list to be filtered to include if my value is included in any of the 4 fields.
So basically, I want to get a response if (field1=value OR field2=value OR field3=value OR field4=value.
I can get a response if I just use 1 condition or also if I use an AND (example _filter=field1::Boston||field2::Boston) but can’t figure out syntax for an OR condition. Any ideas? Thanks.
