Application Studio Grid Filter Conditions List?

[jdtrent (Joe D Trent)]

Hey,

Is there a list of conditions that work on the grid BAQ options/where list?

For example, I’m looking for “begins” or “startswith” below, but it ignores anything I try there. “>=” works, but it’s not quite the same effect.

Thanks,

Joe

[jdtrent (Joe D Trent)]

'Doh. Just “starts”.

[hmwillett (Hannah Willett)]

For posterity, these are the ones I’ve found:

=, <, >, <=, >=. <>, starts, contains, ends, matches, in

[jdtrent (Joe D Trent)]

Thanks, Hannah.

[jwphillips (Jonathan Phillips)]

You can add in to that list

[tonyb1986 (Tony Burke)]

what about a condition where it is not in another dataview? i used <> and successfully filtered out 1 of the values…

[Rick_Bird]

@hmwillett

=, <, >, <=, >=. <>, starts, contains, ends, matches, in

I was needing to do something like ‘not starts’ or ‘not contains’, etc… and that doesn’t work… what does work is: not(field starts ‘somevalue’)