1 of 1 people found this helpful
100,000 unique elements is a lot for any user to deal with -
you could use a wildcard match
but I would look for ways to group or form a hierarchy
if the data have any sort of logical groups - geo, year of introduction, alphabetic or numeric first character etd - then use relevant filters
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
2 of 2 people found this helpful
I don't think picking from 100000 elements will be a good idea ( you may find Sort performance issues )
For actions you need Source and Destination.
If you clear the selection with Leave the filter option then you might find better performance.
And the reason is
when you leave the filter with each selection .......
Say we applied Action 1
Now we have come out of the action
View is as it is
Now applying Action 2
So there is a one to one mapping no full table scan as you will have in the former way.
1) Sort your data at data-source level itself (as we do in Oracle) , hence we need not to sort that again.
Go with Multiple Values (Custom list ) if possible