Re: Advanced Search form database queries

[CubicSpline]

This is exactly what I've been doing at work for the last six months or so. Granted, it's not perl related (what I do, I mean), but I had to go over the exact same interface questions that you are going through here.

The first thing that I think you should ask yourself is "Who is going to be using this 'Advanced Search'?" I would say go ahead and allow the user to write their own queries if:

1. They will know SQL and understand what they're doing
2. They will be able to read a paragraph or so of instructions that describe how to use the query grammar you will provide to them

This leaves out most of the web using public, so if that is your intended audience I think you're best off using standard UI widgets that they will have seen before and are comfortable with.

I've had good success with the method you are currently using. It's intuitive enough for most users to comprehend without any instructions and it converts very easily into SQL statements when you need to parse the form.

I think the most important thing here is to get feedback from your users to find out if the Advanced Search capabilities you've offered are getting the job done for them. Maybe just have a small form on your results page that they can check whether or not they found what they were looking for.

~CubicSpline
"No one tosses a Dwarf!"