cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
328
Views
0
Helpful
2
Replies
Highlighted
Enthusiast

Advanced FIlters

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.

Everyone's tags (3)
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Rising star

Re: Advanced FIlters

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

-Jameson

View solution in original post

2 REPLIES 2
Highlighted
Rising star

Re: Advanced FIlters

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

-Jameson

View solution in original post

Highlighted
Enthusiast

Re: Advanced FIlters

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