Allow multiple criteria for advanced searches & smart labels
When creating advanced searches & smart labels, the way it structures the queries is such that each line is a separate select. That means it searches for each line, then combines the results. So if I am looking for devices with software package A version 1.0, I would think that having a two line search, the first for software title = A and the second for software version 1.0 would get it. But since it does each line separately and combines the results, if a computer has software A version 2.0 and software B version 1.0 it will match even though that isn't what I wanted. The only way I have found around it is to edit the sql directly so it is a single query.
Michael Magill
shared this idea
-
Matt
commented
I experience the same issue and have also had to resort to editing the SQL query directly. I've put in several cases with Quest in the past, but to date it has not been resolved.
I also thought for a while that creating "groups" within the search would help, but I have not seen any evidence that it helps.