Advanced Query Builder

Advanced Query Builder ^{Prototype v2}

Fill out any or all of the following boxes: (images must match all boxes filled out)

All of these words
Any of these words	(or at least of the words)
This phrase	Match whole field only
None of these words	(must have at least one of the above)

Allow stemming (bridge matches bridging, bridges etc too)
Exact word matching

Remember matches whole words only. Not case sensitive. Seperate words with spaces.

Currently searches:

title, description, category, photographer name and shared description
image taken date ( 20071103, 200711, 2007 or even April)
subject grid-reference ( SH1234, SH13 or just SH )

Show field specific boxes

title	(All / Any / Phrase / Whole Field )
description	(All / Any / Phrase / Whole Field )
category	(All / Any / Phrase / Whole Field )
in any of the above three	(All / Any / Phrase / Whole Field )
photographer name	(All / Any / Phrase / Whole Field )
"shared description" text	(All / Any / Phrase / Whole Field )
"shared description" title	(All / Any / Phrase / Whole Field )

months (any year)	· Jan ·Feb ·Mar ·Apr ·May ·Jun ·Jul ·Aug ·Sep ·Oct ·Nov ·Dec ·
taken day(s)	YYYYMMDD format (Any if multiple)
taken month(s)	YYYYMM format (Any if multiple)
taken year(s)	YYYY format (Any if multiple)
grid reference(s)	XX9999 or X9999 format (Any if multiple)
hectads(s)	XX99 or X99 format (Any if multiple)
myriads(s)	XX or X format (Any if multiple)
user_id(s)	numeric (Any if multiple)

This page is an example interface used to create an advanced 'full text' keyword query for geograph.org.uk image search. The query produced is a SphinxSearch's 'Extended query syntax' query :) The sphinx index used has english stemming and index_exact_words enabled.

Advanced Query Builder Prototype v2

Advanced Query Builder ^{Prototype v2}