001145a2-728c-40f0-8e50-395463497514.jpg

b35bde79-f220-4681-bc0f-4de7b2560ec0.jpg

Operational Excellence Partnership Lead

1de6e909-a5db-4a4d-957a-62b8868a8a00.zip

1d221aac-fae0-420b-bb56-9b7fb31c20a6.png

To filter and sort a DataTable, provide arguments as follows:

  

1) io\_dataTable: the table to be filtered.

  

2) in\_selectCriteria: the criteria string used to filter. Leave blank for no criteria (sorting only).

  

Examples are :

   "Name LIKE '%cat%'"

   "ProductID = 1234"

  

in\_sort: Flag for whether sort should occur, True or False.

  

in\_sortDescending: Flag for whether sort should occur descending for the sort field, True or False.

  

in\_sortField: Field name that the DataTable should be sorted by.

Filters a DataTable based on select criteria, and optionally sorts the result based on one field, ascending or descending.

DataTable Filter with Optional Sort