Collection Question - Are these filters correct?

Comments

1 comment

  • Shane Corellian

    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
    Comment actions Permalink

Please sign in to leave a comment.