How can I filter table by field contains in confiforms?

[Christian Perry]

Hi, I have a form with multiple fields. I want a table to show results filtered by if a summary field contains the word "TBD"  and "Not now"

On a slightly separate note. Can I filter by character count ex: showing all responses that were 100+ characters

Thanks!

[Alex Medved _ConfiForms_ · Accepted solution]

Can use asLength virtual function https://wiki.vertuna.com/spaces/CONFIFORMS/pages/2359385/Virtual+functions

summary.asLength:>100

[Christian Perry]

I know I can use fieldname:*val* but OR does not seem to work for multiple Vals 

[Christian Perry]

okay nevermind it was syntax. Still curious about character count though.