Author Topic: User defined filter.  (Read 3355 times)

0 Members and 1 Guest are viewing this topic.

pencilhead

  • Guest
User defined filter.
« on: July 31, 2009, 03:21:48 am »
Hi Nostra,

Would it be possible to have a user defined filter.
Something along the lines of a drop down selection containing all database fields that the user can select and possible filter on or off against that. ie the field is populated with data or not.

I am trying to find all movies that have the media location as unpopulated after adding new entries.
This would allow me to do a bulk add of movies, filter on whatever field (in my case the media location) and then go an populate this field and store my movies (physically) in this location

Tried to achieve the same thing using advanced search it doesn't appear to let you search against unpopulated if there is data in unpopulated. I tried to add a "null" under preferences/lists/locations. It allowed me to add a null value, but searches don't work against it.

Regards
PH
« Last Edit: July 31, 2009, 03:50:20 am by rick.ca »

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: User defined filter.
« Reply #1 on: July 31, 2009, 03:57:10 am »
Mathematically, "null" means "empty" or "not existing." It is a condition, not a value that can be searched. In Advanced Search, select the "is null" or "is not null" operator, as appropriate.

pencilhead

  • Guest
Re: User defined filter.
« Reply #2 on: July 31, 2009, 04:47:25 am »
Yep - I know. I want to be able to filter on fields that are empty.
ie filter/search on the "media location" field and return a result when that field contains no data.

When I tried adding it via preferences/lists, I selected the "add" box with selection box empty (clicked in it but didn't add anything),
It added what appears to be a "null" selection, but this does not appear to work when selecting it from an advanced search.

See attached pic.

[attachment deleted by admin]

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: User defined filter.
« Reply #3 on: July 31, 2009, 05:48:03 am »
Quote
It is a condition, not a value that can be searched.

[attachment deleted by admin]

pencilhead

  • Guest
Re: User defined filter.
« Reply #4 on: July 31, 2009, 06:05:51 am »
Cool...

Didn't realise you could click on the word (eg. containing) to change its value.
(This should be added to help index thread)

Problem solved.

Thanks
PH

pencilhead

  • Guest
Re: User defined filter.
« Reply #5 on: July 31, 2009, 06:33:14 am »
Would it be worthwhile making this 'condition selector' a selection box so it is more obvious that it is user selectable?

Offline rick.ca

  • Global Moderator
  • *****
  • Posts: 3241
  • "I'm willing to shoot you!"
    • View Profile
Re: User defined filter.
« Reply #6 on: July 31, 2009, 10:37:42 am »
Then it would be too obvious to be called "Advanced" Search.

pencilhead

  • Guest
Re: User defined filter.
« Reply #7 on: July 31, 2009, 11:37:33 am »
Then it would be too obvious to be called "Advanced" Search.

LOL
;D