Skip to main content

Activity Configuration: Defining activity order

The Activity_order field is used as a tie breaker when two events are happening on the same timestamp.

Option 1: SQL configuration​

The following code shows an example of configuring Activity_order with a SQL CASE statement:

    case
            when tableA."Activity" = 'ActivityA'
                then 1
            when tableA."Activity" = 'ActivityB'
                then 2
            when tableA."Activity" = 'ActivityC'
                then 3
            when tableA."Activity" = 'ActivityD'
                then 4
    end as "Activity_order"

Option 2: CSV seeds file​

Instead of using a SQL CASE statement, you can define Activity_order using the activity_configuration.csv file .

The following illustration shows an example activity_configuration.csv file:

Example activity_configuration.csv file

Recommendations​

Most UiPath app templates come with predefined fields for activity configuration, which you can adapt to your specific business requirements. If predefined fields are unavailable or insufficient, you can always create custom fields using either SQL or the activity_configuration.csv seeds file, as outlined.