PHPCG allows to add filters to your end-user's Admin READ lists within a few clicks.
To add filters to your admin panel READ lists with PHPCG you must beforehand:
PHPCG offers two ways to add dropdown lists to filter your records in your Admin READ lists:
You can use them to filter your list using any field of the current table.
For example you can filter articles by id, title or publish date.
You can use them to filter your list using any field of any related table.
To create an "advanced filter" you have to build a custom SQL query to get the value you want to use in your filter dropdown list.
Enter the values in the CRUD Generator (Build READ List => add filter => advanced):
optiondropdown list, separated by the "+" sign.
optionvalue used to filter the list.
In the previous example we want to display a dropdown list with Authors names + first names to filter the articles READ list by author_id, where author_id is the foreign key.