Sort Data Model

The Sort data model action allows you to create a list by merging the data of two other lists.

Scenario

As a PROCESIO user who created a data model to use in my project I need a way to sort the data by multiple criteria.

How to

The example requires a process with just the Sort data model action with the following configuration.

Step 1. Create the data model CompanyDetails who uses the data model Company.





Step 2. Create a new process and give it a name.

Step 3. Drag the Sort data model action to the canvas and link it to the other actions.



Step 4. Create the variable we will use to hold the input data, for simplicity we will provide a default value to it.



{
  "id": "asfw2mki4",
  "Company": [
    {
      "city": "Berlin",
      "Company": "Rutherford Group"
    },
    {
      "city": "London",
      "Company": "Nevett"
    }
  ]
}

Step 5. Click the Sort data model action to access its configurations and add the variables as follows. We will use a json configuration that will sort the city in ascending order and the company name in descending order.



{
  "IdField":"id",
  "Sort":[
			{"Field":"Company.city","OrderType":"Asc"},
			{"Field":"Company.company","OrderType":"Desc"},
		]
}

Step 6. Save and Validate the process.

Step 7. Run the process.

Step 8. Click Check instance to see the results in the output section.