Upvote 3

Filter Data Grid 1 based on selection from Data Grid 2

Answered Victor Conesa ● ago

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?

Replies (4)

Victor Conesa ●

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) ) )

javier morales ●

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...

javier morales ●

Just got it!

It's all in the expression list...

Enrique Cano ●

How can create this expression, can you please elaborate?

Enrique Cano ●

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

I hope it helps

Enrique Cano ●

Thanks I have managed to do it!