Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Wildcards in filter

If there are a lot of values for specific field, it is possible to use wildcards in visual level filters, like:

 

starts with

422??-8pp

or

contains

422ba-*s

 

Regards.

 

JCA

Tips and Tricks
  • ankitpatira's avatar
    ankitpatira
    10 years ago

    Anonymous you certainly can, make sure your column is of data type Text, drop it to filters area -> Advanced filtering and their you will have options to do that such 'contains' and 'do not contain'

4 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    Anonymous you certainly can, make sure your column is of data type Text, drop it to filters area -> Advanced filtering and their you will have options to do that such 'contains' and 'do not contain'

    • jeffshieldsdev's avatar
      jeffshieldsdev
      Icon for Solution Sage rankSolution Sage
      10 years ago

      But this doesn't support wildcards...any other suggestion?

      • hgorina's avatar
        hgorina
        Frequent Visitor
        8 years ago

        just enclose your expression in the filter in the single quote

        works fine with ?, but i did not test with *