In scope of ticket
MDEXP-556 it was found that at Morning Glory bugfest environment sorting mechanism by field total provide wrong result for job executions.
Data export job execution records are ordered in the alphabetical order by total value. But they should be sorted in the numeric order.
The data of sorting is provided by mod-data-export module.
The same behavior is reproduced locally:
In debug mode of mod-data-export module that was build from master branch was retrieved sql to get job executions:
Sql provides ordering result by job_executions.jsonb->'progress'->>'total' as string. The logic that responsible for sql generation is part of RMB 34.0.0.
Steps to Reproduce:
Are described in scope of
The records are ordered in the numeric order (1, 2, 15, 23)
The records are ordered in the alphabetical order (1, 15, 2, 23)