Searching with fixed search terms

I've imported all of the bug reports from my company's existing bug reporting tool into our TWiki. But I'd like to be able to search these bug reports via a search form, but have some implicit fixed terms.

For instance, I would like to be able to search for all issues assigned to me. I can do this by using the WebSearch forms, and searching for:

    Assigned to:\* lcloss

I'd like to just have a single text box, where I would enter (in this example) lcloss, and when I submitted, I would actually search for the above string.

I've searched codev looking for an answer to this type of question.

Any thoughts?

-- LukeCloss - 06 Jun 2003

FormPivotPlugin doesn't do exactly what you want, but will pivot on the fields you request. We've used it for exactly the purpose you describe.

Still it would make sense to link the existing form facility to search forms.

-- JohnTalintyre - 06 Jun 2003

Could you provide a link to a place where you've used it for exactly the purpose I described? After reading the FormPivotPlugin page, I don't really see how I would use it.

Cheers, -- LukeCloss - 06 Jun 2003

I can't give a link, because it's on an Intranet. But, imagine one field is assigned to. Pivot on this field and you have a unique list of all people with bugs assigned to them, next to that a count of the number of bugs. Click on count and you get all the topics assigned to you. Pivot on assigned to and status and you get a 2d grid, click on a box to see all bugs at that status assigned to that person.

-- JohnTalintyre - 06 Jun 2003

Another approach is to use a query-by-example form and FormattedSearch on the same page. See TWikiInstallation example.

-- PeterThoeny - 07 Jun 2003