Advanced FIlters

[sarbarnes]

I am trying to set up an advance filter on a column i have created which shows either Not Equal to, Equal to or Matches Pattern.

All of which are set to <string>

I want to do as a range, CT_A CT_B etc... or by 111222 111221...

I am probably missing something quote fundamental, however I have used a comma, a &, the word and, the word or and none of theme seem to work, however if I put the string in individually or leave it as any i get the data.

As always any and all help greatly appreciated.

[Jameson Gagnepain · Accepted solution]

Sarah,

You can't do a range. The closest you can get to that behavior is to use "Matches Pattern".

If you do Matches Pattern: CT_

You end up with SQL like: WHERE columnName LIKE '%CT_%'

Your other option would be creating a custom Value List to apply to the column.

-Jameson

[sarbarnes]

Cheers Jameson I have used the Matches pattern as thankfully what I need to advance filter on all started with the same prefix...