Webapp: Cockpit : order of process list is not correct

[venetrius]

Environment (Required on creation)

Any env from 7.20.0

Description (Required on creation; please attach any relevant screenshots, stacktraces, log files, etc. to the ticket)

The process list ordered in a case-sensitive way (uppercase > special character > lowercase)

Steps to reproduce (Required on creation)

Open camunda app Go to /camunda/app/cockpit/default/#/processes Sort the processes by name

Observed Behavior (Required on creation)

Expected behavior (Required on creation)

Root Cause (Required on prioritization)

org.camunda.bpm.cockpit.impl.plugin.resources.ProcessDefinitionRestService.queryStatistics method uses processDefinition query which uses the default order which is case sensitive. The result of this method call is rendered in cockpit without sorting.

Solution Ideas

• One option could be to update our sort by to use sort by upper(column_name)
  • the actual function name can be different in different DB
  • has effect on performance
• An other option could be to communicate to customers that they need to use case-insensitive in their DB if they want alphabetical ordering in the app.

Hints

Navigate high quantities of processes in process overview introduces paging for process statistic table, before that the entire list was loaded to the front end and sorted.

This behaviour can be also observed on Admin user page

Links

Breakdown

### Pull Requests

Dev2QA handover

• [ ] Does this ticket need a QA test and the testing goals are not clear from the description? Add a Dev2QA handover comment

[venetrius]

Closing this issue as not planned.

We changed the process list behaviour (Dashboard » Processes): In versions <= 7.19.0, we merged the key and name columns and sorted them using JavaScript. With 7.20.0, we separated the columns and moved the sorting from the client to the server side (the database is responsible for sorting).

Even if we would try to fix this using your outlined option #1, we cannot influence how the database sorts. It is vendor-specific.