Compare Joined String to an Array in a Query Filter

Kyle Jorgensen over 7 years ago

I am trying to compare a field that is a joined array of customer locations (ex: "Factory A; Factory X; Factory Y") to an array locations put in as a filter (user selects "Factory X"). Essentially what I would like to have happen is if any part of this array {"Factory X", "Factory Z"} is present in this field "Factory A; Factory X; Factory Y" then I'd like to return that record.

Is this possible?

Discussion posts and replies are publicly visible

Parents

0 Tyler Criste
Appian Employee
over 7 years ago

Kyle - I think in this case you would need to use Reviteja's idea of looping over your fabs to create one query filter for each. Then your logical expression would use OR logic, so that you'd get results where either the string includes Fab1 OR it includes Fab 2.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Tyler Criste
Appian Employee
over 7 years ago

Kyle - I think in this case you would need to use Reviteja's idea of looping over your fabs to create one query filter for each. Then your logical expression would use OR logic, so that you'd get results where either the string includes Fab1 OR it includes Fab 2.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data