INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: enervation on January 03, 2006, 11:42:37 am

Title: Help with database expressions
Post by: enervation on January 03, 2006, 11:42:37 am

After looking in the help files, I cannot see a way to do this: I have loads of pictures tagged with the people displayed in the pictures. I want to be able to create smartlists that display pictures including combinations of people, but exclude pictures that also have other people in.
The only way I can see of doing this so far is like this:

Code: [Select]

[Media Type]=[Image] [People]=[Bob] [People]=[Jane] -[People]=[],[Matt],[Sam],[etc. etc. etc.]Which would get really annoying to maintain as the number of pictures grows.

As far as I can tell, using a double negative doesn't work, which would be something like this:

Code: [Select]

[Media Type]=[Image] [People]=[Bob] [People]=[Jane] -[People]=(-[Bob],-[Jane])
Can anyone help me with a better way of doing this?

Thanks in advance :)

Title: Re: Help with database expressions
Post by: marko on January 03, 2006, 02:01:16 pm

you are not alone :)

this thread might help you....

http://yabb.jriver.com/interact/index.php?topic=30671.0

Title: Re: Help with database expressions
Post by: enervation on January 03, 2006, 05:18:09 pm

Thanks! I used:

Code: [Select]

[=isequal([people],Bob;Jane,1)]=1 or [=isequal([people],Jane;Bob,1)]=1
I hope they implement a slicker way of doing it though, if you were looking for 3 people you would need 6 expressions, for 4 people you would need 24... would get very annoying.

Thanks for your help :)