Filter Data Grid 1 based on selection from Data Grid 2

Jeff shared this question 5 years ago
Answered

I would like to filter a data grid (contains a subset of a Data Master) on one screen by selecting a row on a data grid (containing a subset of another Data Master) on the previous screen. Each Data Master contains a common field, LoanNumber, with identical data. Can this be done?

Comments (6)

photo
1

I think so. First I'd store the selected row in a variable (this tutorial can help you with that). Then, on the other screen, create an on page load event that changes the value of the data grid (executing a set value event) and, as the new value for the data grid, build an expression like this:


filter(data grid 2, (datamaster2.LoanNumber) = (select (variable, datamaster1.LoanNumber) ) )

photo
1

Hum..

That doesn't work. I've tried exactly that between 2 or 3 active panels, but data lists all records on the data set, no matter what the variable value is. This is really frustrating...

photo
1

Just got it!

It's all in the expression list...

photo
photo
1

How can create this expression, can you please elaborate?

photo
1

In this picture datagrid2 is datagrid, number 2 is datamaster2.loannumber and number is datamaster1.loannomber


7d445e7277b932efdea1583167fcd3ee


I hope it helps

photo
1

Thanks I have managed to do it!