As you may know, searching using the search field of either Interactive Report or Interactive Grid “compounds” the search terms used, e.g. I search for "rey" and the report searches for "rey" and then if I type in “jeff”, the report searches for entries with “rey” and “jeff”.
I am using the customer table from the sample datasets in the above image.
What I need is to limit the search entries to one, instead of "compounding" the search terms.
So when I type in “rey”, the report searches for “rey” and when I type in “jeff”, the “rey” search term gets discarded and only the “jeff” one remains.
I know I can just remove the other search term by pressing the “x button”, but what I need is a “single search term only” search.
Anyone know how to do this?