Searching - Combining

You may combine many search criteria into a single search command, effectively searching through many different fields at once, while sorting and perhaps summarizing the results. To create a complex search, simply put all the search criteria into a single URL or HTML form, or even an embedded [Search] context.

Examples:


Find all product Descriptions that contain either of the words "Television" or "Stereo" or both, sorting the found items that contain both words (best match) to the top of the list.

Results.tpl?command=search&woDescriptiondata=Television,Stereo&db=Products.db

Find all product Descriptions that contain either of the words "Television" or "Stereo" or both, sorting the found items by Price in descending order.

Results.tpl?command=search&woDescriptiondata=Television,Stereo&Pricesort=1&Pricesdir=de&Pricetype=num&db=Products.db


Find all product Descriptions that contain both of the words "Television" and "Stereo".

Results.tpl?command=search&waDescriptiondata=Television,Stereo&db=Products.db


Find all product Descriptions that contain neither the word "Television" nor "Stereo".

Results.tpl?command=search&wnDescriptiondata=Television,Stereo&db=Products.db


Find all product Titles that are blank (contain no text whatsoever, not even a space).

Results.tpl?command=search&eqTitledata=[blank]&db=Products.db


Find all records whose product Description contains at least one of "Television" or "Stereo" and also whose product Title contains at least one of "Car" or "Boat"

Results.tpl?command=search&woDescriptiondatarq=Television,Stereo&woTitledatarq=&Car,Boat&db=Products.db