Collectorz.com Forum

Catalog your movies, books, music, comic books and video games.
It is currently Thu Jul 24, 2014 4:39 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Using a Filter
PostPosted: Thu Aug 27, 2009 12:13 pm 
Offline

Joined: Fri May 08, 2009 2:43 pm
Posts: 52
Hi, I am still evaluating PC, and I am having some difficulty creating a filter.
I want to list photographs where both Category and People are NOT blank.
I have tried a few different things, but none of them are working.

TIA, Richard.


Top
 Profile  
 
 Post subject: Re: Using a Filter
PostPosted: Thu Aug 27, 2009 2:14 pm 
Offline

Joined: Fri Sep 05, 2003 5:27 pm
Posts: 1242
Location: England
As far as I can tell, what you want to do is not possible in any easy way - since to complete the condition you have to select items from the pick lists.

However, you could sort on Category and People at the same time (Sort Order | Choose Fields and then select Category and People).
This will list all of the items with blank categories and blank people at the top, then blank categories with actual people next, and finally those items with category filled in - with or without people.

In my database, I specifically use "_No_People" as a field value, to specify that there are no people in the photo. This would help with your issue, but also helps you distinguish between blank (ie haven't put a value in the field - it needs reviewing) and those actually having no people in them (eg landscapes)


Top
 Profile  
 
 Post subject: Re: Using a Filter
PostPosted: Thu Aug 27, 2009 5:54 pm 
Offline

Joined: Fri May 08, 2009 2:43 pm
Posts: 52
Thanks Stephen, I can see how your suggestion will help. I still need to spend more time playing around with PC to see if I can get it to do exactly what I need.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group