Is there a way to filter based on if a value exists in field 1 OR field 2? From what Iām reading the filter only allows an AND filter when there are multiple values.
FYI - One work around I have come up with is to use a calculation field to combine the field values I want to search. This seems to work.
2 Likes
Hi @scostello,
Indeed, the API currently only allows combining filters via AND (i.e. = all filters must match), not OR (= any filter matches), as stated in the docs.
Thanks for sharing your workaround though - that sounds like a great solution and option for other users as well in the future!
Happy building
Tim