Hi, I have a model with many fields and many records in the database. To avoid clutter, I want users to be able to apply some filters when viewing all records (ie: model->index()). Let's say I have a model "Song":
id, (fk) artist_id, name, (fk) genre_id, (fk) album_id, (boolean) has_lyrics The index page should have filters like: a checkbox (has lyrics?), dropdown lists (artists, genres, etc.) and the user should be able to use these filters in conjunction (ie: has lyrics and genre=rock). I know 99% of this could be done with the WHERE clause. But what is the best way to do it in Cake, without breaking Paginator support? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en