I have two tables joined by a unique ID – is it possible to have two grids on the same page and filter both grids at the same time?
Yes, you have to use 'select_command' property to enter your JOIN query. e.g.
$g->select_command = "select ….. ";
Refer documentation for more.
For searching, it would work with above query. There is a chance that 2 columns may have same name, so you can provide table prefix with 'dbname' property of column to avoid ambiguity.
$col["dbname"] = "table2.field";
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?