Basic text filter - exact match

[Gazza21]

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? 

[pjk]

Hi. Did you find any solution for this?

Thanks

[parry2k]

@Gazza21 good to hear. good luck. cheers!! Thanks for the update.

[parry2k]

@Gazza21 I think pro will work, good luck. Do share your findings. Thanks!

[Gazza21]

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

[parry2k · Accepted solution]

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

[Gazza21]

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 🙂

[parry2k]

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