This topic is locked

Adding a search to a menu item

11/3/2009 7:13:13 PM
PHPRunner General questions
D
Dale author

I have tried to use the search in the forum but it really sucks. Nuf said.
Sorry to vent before I ask for help. Probably not a good way to start.
Is there a way, a file or something that I can do so when a user selects a menu option I can force the search on it.

I have a table for construction deficiencies. One of the fields is a checkbox for Done. When the item is checked done, its done.

When a user picks the Active deficiencie menu tab, I want to list the table with records that are NOT checked done.
Can this be done. I dont want to force to the Search Page as this confuses users. Using the menu editor I have One tab built with three links under it.

Active, Done, and ALL. I would like the user to click the appropriate menu choice and I can pop the filter on the request.

Im worried that even if I get this filter on, what happens when I am viewing a list and I click the SHOW ALL button.
I thought I would ask before I spend another hour going through search returns on this forum. The search I preformed today on the forum was the actual Topic Title on this post. After going through 4 or more pages I just had to stop and ask the above.
Oops, went back into vent mode there.
Help always appreciated.

Thank god for the great support.

How about that for a closing, a good note.

Sergey Kornilov admin 11/3/2009

'Show all' button removes all previous filtering.
You can either remove 'Show all' button or create a separate 'Custom view' for each case and add a corresponding WHERE clause on 'SQL Query' screen.