select table rows based on value from the list down box

angeli ho shared this question 7 years ago
Answered

have a datagrid define with rows of data, want to add a list box with shows all colume 1 data only. have user pull on list box and select a value, then datagride only display the rows with the selected value. can't make it work at all

Comments (6)

photo
1

You have to define this expression: filter(datamaster, (data master attribute you want to filter by) has (select list))

photo
1

where should i define it? in the drop down box as on click event with set value? I think I need another event as on change to refresh the data value in the table?

photo
1

also who can i define action where users want to see all table rows again after seeing a selected rows?

photo
1

oh i mean where can i define action, not who from the previous reply

photo
1

Yes, you need to assign a set value event with that expression as the calculated value and the data grid as the receiver of that value. That action can be triggered either with an onchage event defined in the drop down or with an onclick event in a button.

photo
1

You need another setvalue action similar that the one that filters but this time just drag the data master to the calculated expression. So the action would be set value -> data grid -> value is -> DataMaster. Again you decide which event launches this action.