Block - Filter and sort the table

[lanny]

Hi,

I would like to show you how to filter and sort information in table with automation block.

I assume you know basic of automation block. If not, please refer this community post, Getting Started - Automation

1. Firstly, filter the information we need
   

   

2. After that, check whether any records found.
   NOTE: This step is important, because, the system might toss error message if no records found.
   

3. Next, sort the information found. Here, we sort the name of FETIAS User found.
   NOTE: You may click the ‘edit’ to change the name of sortedList
   

   

4. Then, define a variable for each row and create new row for each information found.
   

   

Okay, let’s see the result at Client. The table show Entry by sorting the name of FETIAs User in acsending order.

That’s it.

You can done filter and sort just with few clicks!

Enjoy~!