Two Grids – One Filter

QuestionsTwo Grids – One Filter
Paul M asked 6 years ago

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?

2 Answers
Abu Ghufran answered 6 years ago

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";

Paul M answered 6 years ago

Thank you …..

Your Answer

10 + 11 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.

How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

We are sorry that this post was not useful for you!

Let us improve this post!