Photo Organizer

This is the bug tracker for Photo Organizer.
Tasklist

FS#89 - allow advanced search on any database field

Attached to Project: Photo Organizer
Opened by Solomon Peachy (pizza) - Thursday, 17 August 2006, 12:05 GMT-4
Last edited by Solomon Peachy (pizza) - Sunday, 06 January 2008, 11:01 GMT-4
Task Type Feature Request
Category Backend / Core
Status Assigned
Assigned To Solomon Peachy (pizza)
Operating System All
Severity Low
Priority Normal
Reported Version Devel
Due in Version 2.36
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

RE-do the advanced search so it's more useful -- allow any field to be searched, not just title, caption, etc etc... then build the query on the fly. This is going to be complicated, but necessary...
This task depends upon

Comment by Solomon Peachy (pizza) - Thursday, 05 October 2006, 00:07 GMT-4
#104 is requiring changes in how we handle searches, and this is a good time to rework it all.
Comment by Solomon Peachy (pizza) - Tuesday, 24 July 2007, 08:34 GMT-4
We also want dates to be searched too.
Comment by Solomon Peachy (pizza) - Thursday, 01 November 2007, 20:44 GMT-4
Dates can now be searched!
Comment by Solomon Peachy (pizza) - Sunday, 06 January 2008, 09:49 GMT-4
#315 was linked -- basically reqesting the profile fields be among those searchable.

What I'd like to see is a set of rows:

field_1 operator_1 data_box_1 comb_1
field_2 operator_2 data_box_2 comb_2

Valid 'operators' are determined by the 'field':
numeric fields can be >,>=,=,<=,!=, between (requiring two fields)
text fields can be 'exact match', 'like' (substring), and 'regexp', (plus NOT variations of this)
date fields can be > >= = <= != or 'between' (the latter requiring two input fields!)

'between' can be replicated with two rows on th same field, one >= and the other <=, or it can be explicit.

'fields' include:

caption, author, photo_id, version_id, location, geolocation (ie lat/long), camera, film, etc etc etc.. The profile fields should probably be restricted to exact matches only, using a pulldown list of valid choices.
Comment by Solomon Peachy (pizza) - Tuesday, 22 April 2008, 18:21 GMT-4
Once this is implemented, I'd like to see an "save this search query" button that will generate a "virtual" album.

Loading...