Set custom sorting

Workspace enables sorting of Manual Tasks by date created and due date. However, sorting by these fields does not guarantee proper task order within the same process run. To ensure consistent ordering, the FIFO mechanism is used.

Control Tower

The column named _sys_record_order (from CSV or Bot Task input) contains a JSON object with two parameters:

• hitOrder: the task's order index within the run
• hitOrderDate: the timestamp used for order sequencing

title	_sys_record_order
Task 1	{hitOrder:2,hitOrderDate:'2020-03-11T10:15:55.935'}
Task 2	{hitOrder:1,hitOrderDate:'2020-03-11T10:15:55.935'}
Task 3	{hitOrder:1,hitOrderDate:'2020-04-11T10:15:55.935'}

As a result, Manual Tasks are sorted based on the hitOrderDate and hitOrder parameters in the ascending order. For the example above, the tasks are displayed in the following order: Task 2, Task 1, Task 3.

Workspace

In Workspace, FIFO sorting is automatically available through the custom sorting feature. There is no need to enable FIFO manually in any configuration files.

The sorting information is stored in the hit_order and hit_order_date columns of the hit table. For backward compatibility, the data is also saved in the custom_attributes column.

troubleshooting

For troubleshooting tips, refer to Hits are not shown in correct order in Control Tower.