Matching exact match from long list of values partial matches in filter dropdown

Question & Answer
, ,
1

I have a long list of multiple combinations of values in the filter dropdown.

Consider:
B,
C,
D,
ZA,AA
YA,
XA,WA,
VA, TA,
SA,RA,
DA,AA,
AB,BA,
AC,AD,
AA, A

So when I type in ‘A’ in the search bar I need to scroll through a lot of these options to find the exact match of the word. Is there a way to make this more manageable and prioritize the EXACT MATCH of the word to be the first match?

I have a large dataset with a number of options so calculated fields using startswith etc are really not feasible due to the number of dropdown options.

Any other creative solutions/ QS dashboard settings I can leverage here?

Thanks!!

2

Hi @Tanisha_Shetty,
Normally the search bar requires 3 characters before it starts to match more efficiently. I’m not sure if your example is made up for sample or how it actually looked, but if there are commas involved, I would try typing first word followed by the comma and that should return only options that have that first word.

Let me know if you have any additional questions!

3

Hi Brett, thanks for the response.
The example I provided was only a sample.
I mostly have partner names but a very long list(say 5000+) and combination of such names:

Here is a better example:
tan, apple, carrot, beets,
tan, apple
tan, apple, carrot
tan, apple, beets,

.
.
.
.
.
.
tan
tan, zebra, yatch
.
.

So if I search for ‘tan’ in the search bar I mostly have to search alphabetically through all combinations before I see the EXACT match. I’m seeking to check if we can somehow bump up the exact match before having to go through all the options

Thanks!

4

Hi @Tanisha_Shetty,
Thanks for the additional example, I understand what you mean now! That is a bit odd that the word on it’s own doesn’t lead off the alphabetical order and unfortunately, there’s no current option to change the sorting options.

In terms of a work around, the only thing I can think of that could potentially work (but depends on your data), would be to add another filter that could limit the results to relevant values only. But that may not help if all similar word combinations are grouped together

In terms of your original question, I’ll go ahead and mark this as a feature request for the exact word match to populate at the top of the list.

1 Like
5

Thanks Brett, that’d be helpful!

I can’t think of a solution for my dataset yet using another filter that could limit the results to relevant values only just because of the sheer number of combinations BUT it could work for others with a more manageable dataset.

1 Like