How to filter data entered in Editable grid and retrieve it in another Read-only grid?

Question

Hi guys, 
 
 I have a Editable grid with 4 columns 
 Name, Gender, Phone Number, Approve 
 Where approve is a checkbox field and remaining all are text field 
 And user Enters multiple values into the grid 
 Now I need to show the data which user entered in Editable grid 
 into another Grid(Read only) where Approve box is checked only from Editable grid 
 
 I am able to retrieve the data into Read only grid but I am not able to filter where Approve checkbox is marked 
 
 This is all in the same Interface 
 
 Thank you

martincamacho · Accepted Answer

Hi viswanath.ch, please check out the following code 
 
 load( local!data: { { Name: "AA", Gender: "M", PhoneNumber: "123", Approve: false() }, { Name: "BB", Gender: "F", PhoneNumber: "456", Approve: true() }, { Name: "CC", Gender: "M", PhoneNumber: "789", Approve: false() }, { Name: "DD", Gender: "F", PhoneNumber: "741", Approve: true() } }, { with( local!filteredData: index( local!data, wherecontains( true(), toboolean( local!data.Approve ) ), {} ), { a!gridLayout( label: "Editable Grid", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell( label: "Name" ), a!gridLayoutHeaderCell( label: "Gender" ), a!gridLayoutHeaderCell( label: "Phone Number" ), a!gridLayoutHeaderCell( label: "Approve" ) }, columnConfigs: { a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "NARROW" ), a!gridLayoutColumnConfig( width: "ICON" ) }, rows: a!forEach( items: local!data, expression: a!gridRowLayout( contents: { a!textField( value: fv!item.Name, saveInto: fv!item.Name ), a!textField( value: fv!item.Gender, saveInto: fv!item.Gender ), a!textField( value: fv!item.PhoneNumber, saveInto: fv!item.PhoneNumber ), a!checkboxField( choiceLabels: { null }, choiceValues: true(), value: if( toboolean( fv!item.Approve ) <> true, null, true() ), saveInto: fv!item.Approve ) } ) ), selectionSaveInto: {}, validations: {}, shadeAlternateRows: true ), a!gridField( label: "Read-only Grid (Selected Rows)", labelPosition: "ABOVE", data: local!filteredData, columns: { a!gridColumn( label: "Name", sortField: "Name", value: fv!row.Name ), a!gridColumn( label: "Gender", sortField: "Gender", value: fv!row.Gender ), a!gridColumn( label: "PhoneNumber", sortField: "PhoneNumber", value: fv!row.PhoneNumber ), }, validations: {} ) } ) } )

How to filter data entered in Editable grid and retrieve it in another Read-only grid?

Top Replies