11-10-2014 03:55 PM
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.
Solved! Go to Solution.
11-11-2014 06:05 AM
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
11-11-2014 06:05 AM
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
11-11-2014 09:30 AM
Cheers Jameson I have used the Matches pattern as thankfully what I need to advance filter on all started with the same prefix...
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide