Filter rows in a view

Need Help
1

Hi together, is there a plugin js or do I have to implement something in the controller?
I have a List of user which are displayed in a list in the index view and all is fine.
but now I want to filter the displayed list, filter all “Johns” or filter all females or something like this.
Is there any plugin in Cakephp which is shown on top of the table, that can filter this list?
Maybe it can be done with ajax.
Or do I have to put a form on top of the list with some search fields and I have to do a request?
Thanks a lot.

cheers Frank

2

There are a few search plugins, but as far as I know they are all about how to manage the query, not providing front-end specifics. Probably because how people do that varies significantly, and getting data from the front-end to the back-end is pretty well covered anyway. A search form is the easy way to go; making some Ajax that simulates that is not all that hard.

3

Hi thanks,
I did now a form and retrieved data from the request, all fine.
But now I have to combine them, which is also no big deal
I have something like that
WHERE condition1 AND (condition2 OR condition3)
But how to deal when these conditions are not filled?
Is there some possibility in cake to easy combine them in case they are not null?

4

Not sure whether GitHub - FriendsOfCake/search: CakePHP: Easy model searching or GitHub - CakeDC/search-filter or GitHub - skie/plum_search: Plum Search plugin for CakePHP would give you out-of-the-box functionality that fits your needs. If not, then the combining of things will have to be custom code on your part, checking whether specific conditions are provided.