What’s the best way of setting up a filter for a repeater that brings back all records that match any value in a global variable?
For example, the variable might contain a string like: “DD,FF,VV” which would be used to match on a column in a repeater called “ID” which might contain “DD” or “VV” or “XX” or “NN” etc. The values here can be anything - I’m just using letter pairs for an example.
So essentially - whatever appears in the global variable would bring back records in the repeater that match any of those values.
I’m assuming I’d need to “pre-process” the variable in some way to “feed” the output into a filter, but I don’t quite know where to start…