Just wanted to check if anyone has come up with a better way to filter out a large lists into a filter in session relevance. In my particular case, it’s within a custom report that allows the operator to paste in a list of machines, which the report display data for but as soon as those list become larger (100+) the report get extremely slow. The two approaches I’ve tried are:
set of bes computers whose (name of it as lowercase = “name1” or name of it as lowercase = “name2” or … or name of it as lowercase = “name100”)
set of bes computers whose ((rope “,name1” & rope “,name2” & … & rope “,name100”) contains (","& name of it as lowercase &","))
and the latter is a bit faster but still not fast enough where I can scale up the size of the list to let’s say 500, 1000, 2000 or even more. Any ideas of a better way to do something like this at a larger scale?