This was a big help! Thank you, Pai.
One question: I'm trying to use LIKE with a wildcard, but I'm not having luck. Here's what I'm trying:
Is it as simple as this to return values? It isn't working for me. I also tried '*' + "Reason1" + '*' and a few other variations.
Hi Jon, You can use most of the regular expression that a java script supports, like Carles mentioned you can use '*' to filter data. Also day if you want to filter data while has 'Result' as prefix followed by a number then you can use "Result\\d", in this case you will get Result1, Resut2 but not Results ot Results1.
Another exaple is, if you want to filter all records with values a or b or c then you can use "[abc]"
Hope this helps,