Register   Login Thursday, August 13, 2020
ForumForumMy Photo Index ...My Photo Index ...Bug reportsBug reportsTag SelectionTag Selection
Previous Previous
Next Next
New Post
 1/10/2009 4:50 AM

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:


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?


New Post
 1/10/2009 11:46 AM

Hi Brian,

I'm currently checking this, indeed it looks like a bug,

The system actually doesn't use SQL rather then an in memory query engine, so SQL syntax is not currently supported,

in the meantime you can select(check) the 'Pets' tag from the tag tree and then using the CTRL key select(check) the 'Pets\Butch' tag, this should give you the effect you are looking for. please read section 3 here

I'll post back when I have more findings regarding this issue.




Previous Previous
Next Next
ForumForumMy Photo Index ...My Photo Index ...Bug reportsBug reportsTag SelectionTag Selection

Membership Membership:
Latest New User Latest: zampetta
Past 24 Hours Past 24 Hours: 0
Prev. 24 Hours Prev. 24 Hours: 0
User Count Overall: 683

Online Now Online Now: | technorati technorati | reddit reddit | stumbleupon stumbleupon | facebook facebook | live live
Copyright 2006-2014 by My Photo Index - the free open source photo organizer