Radicore Forum: How To » Creating filters

Home » RADICORE » How To » Creating filters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Creating filters [message #294]

Mon, 25 September 2006 15:58

ecw201
Messages: 1
Registered: September 2006

Junior Member

This really is a great way to set up a web application. I have a question regarding searching/filtering data that appear in LIST2 screens. How would you go about creating an "on the fly" search to filter out data from a LIST1 screen to a LIST2 screen? The search you currently have works great, but what if you'd like to search within a range of integer field values or dates, rather than only a specific value.
Also, is there any way you can think of implementing a saved search function that would allow for a way to change the sql_where of a list screen based on values in another table?

Thanks!! I hope these questions make sense.

[Updated on: Mon, 25 September 2006 17:14]

Report message to a moderator

Re: Creating filters [message #295 is a reply to message #294]

Mon, 25 September 2006 19:12

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

If you want to enter a range of values as search criteria then take a look at http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq52. For a working example take a look at http://www.tonymarston.net/php-mysql/menuguide/audit_dtl(sea rch).html

If you want to generate other search criteria then you can put whatever code you like into the _cm_pre_getData() method.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Different users per database
Next Topic:	Display field from related table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Nov 27 06:58:40 EST 2024

Total time taken to generate the page: 0.01007 seconds