Forum Discussion

Gazza21's avatar
Gazza21
Frequent Visitor
5 years ago
Solved

Basic text filter - exact match

Hi,

 

I have a buisness requirement to have a report with a text box search that filters the data via an exact match on the search criteria, and also doesn't try and display all the search options to the user like the smart filter does (too many possible values and the business requirement is that the user needs to know what they are looking for, we don't actually want to be too helpful here as our users are subcontractors that are also in business for themselves as well as working for us and we want to restrict their ability to randomly search as much as practically possible). 

 

Does anyone know of a custom filter that will do this? 

7 Replies

  • Gazza21 not as such I'm aware of, all search filters I have seen do a wildcard search, not an exact match.

  • Gazza21 I noticed smart filter pro has an exact match, maybe that is what you need.

    • Gazza21's avatar
      Gazza21
      Frequent Visitor

      Possibly, I tried smart filter free but that didn't work very well, the field it needs to filter has over a hundred thousand distinct values and it tries to display the options the same way a standard slicer does....which the business doesn't want to do...most of the time the report crashed when I added the smart filter...the pro version might be better / more configurable but I don't want to go through the hassle of getting approval to get it if it won't do what I need (work would need to pay for it after all)....I have emailed OKViz to check if the pro version has the functionality needed...or perhaps I should say the lack of functionality needed 🙂

    • Gazza21's avatar
      Gazza21
      Frequent Visitor

      yeah, I downloaded a trial version of smart filter pro, it works nicely for what I want, thanks

  • pjk's avatar
    pjk
    New Member

    Hi. Did you find any solution for this?

    Thanks