SMS2003 Collection Query Help

[sennen1234]

Hi all,

I'm fairly new to bespoke queries within SMS so any assistance would be much appreciated....

What I'm trying to do is create a new collection with clients that do not have the current version of a specific application or do not have the application at all. Querying on an old version isn't a problem but the query for clients without the application doesn't seem to work.

I've tried various different options, ie. product name is not like "app name" but the query just comes back with the full estate...

Thanks. R