1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Collection Question - Are these filters correct?

Avatar
Jo Vanattenhoven

Hello,

I'm having a problem with PDQ Inventory when I create a collection. The selection is this (Flash1.jpeg) and if you see my computer (flash2.jpeg), you see it shouldn't be in the collection but it is. Are the criteria not correct?

flash1.jpg

 

flash2.jpg

Originally from ticket #11159

0

Comments

1 comment
Date Votes
  • Avatar
    Corellian, Shane

    You have two filters where you really need one. With these two filters you are saying show me computers that meet the following:

    an application name beginning with "Adobe Flash" --This filter passes

    ANY application that has a version lower than 11.3.300.257 -- this also passes since you have applications which have versions lower than 11.3.300.257

    To match a version with a particular application you should use the same filter. 

    FlashCollection.png

     

    For the SQL heads out there the first example could be written like this in SQL

    SELECT * FROM Applications WHERE Name LIKE 'adobe flash%' OR Version < '11.3.300.257'

    By using the second example (combining the two filters into one) we replace the OR with AND

    0