INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Help with database expressions  (Read 1161 times)

enervation

  • Junior Woodchuck
  • **
  • Posts: 93
Help with database expressions
« 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 :)
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9139
Re: Help with database expressions
« Reply #1 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

enervation

  • Junior Woodchuck
  • **
  • Posts: 93
Re: Help with database expressions
« Reply #2 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 :)
Logged
Pages: [1]   Go Up