Filter Datatable. This example shows how column filtering can be used alongside searchpanes. The filter function finds records in a table that satisfy a formula.
The filter function finds records in a table that satisfy a formula. Name position office age start date salary. Datatables example individual column filtering select inputs datatables example.
We can also sort the filtered data.
The latest data that has been loaded is shown below. Var filtereddata table columns 0 1 data flatten filter function value index return value 20. Select the column header arrow for the column you want to filter. Foundrows table select expression dim i as integer print column 0 of each returned row.