Hi, I am trying to make a grid with filter above. I wrote this SAIL:= load( local!BUfilter, local!pagingInfo: a!pagingInfo( startIndex: 1, batchSize: - 1, sort: { field: "InvestmentMain.InvID", ascending: false } ), with( local!datasubset: if( isnull( local!BUfilter ), rule!getAllInvestments( local!pagingInfo ), rule!getInvestmentByBU( local!BUfilter, local!pagingInfo ) ), a!dashboardLayout( firstColumnContents: { a!textField( label: "Filter by Bu", value: local!BUfilter, saveInto: local!BUfilter, refreshAfter: "KEYPRESS" ), a!gridField( totalCount: local!datasubset.totalCount, columns: { a!gridTextColumn( label: "ID", data: local!datasubset.data.InvestmentMain.InvID, field: "InvestmentMain.InvID...
OriginalPostID-97336
Discussion posts and replies are publicly visible