I am trying to use the complex tag search but I am not getting the expected results. Lets say I have I have the following tags:
Pets\Bo
Pets\Duke
Pets\Butch
Pets\Barney
If I drag Pets into "With (And)" and Pets\Butch into "WIthout", I would expect to get all Pictures of Pets except those tagged with Pets\Butch. Instead I get all Pets pictures, including Pets\Butch
Not knowing the exact structre of the DB and Tables, I would expect my query would be something like:
SELECT * from MyPhotoIndex WHERE Tag LIKE 'Pets\%' AND NOT Tag = 'Pets\Butch'
Am I doing something wrong or am I interpretting your query tool wrong? Also can you add a simple Free form SQL Query tool too?
Thanks.
Brian