Query and Report show different results
7.0.2
I have a field that has 15 choices: LP01->LP15. When I run a query and sort by this field, I get:
LP09
LP10
LP11
LP12
LP13
LP14
LP15
LP01
LP02
LP03
LP04
LP05
LP06
LP07
LP08
When I run the JRS report, it sorts correctly. LP01-LP15. I looked in to the process config source, and it has something like:
LP01 *literal.12
LP02 literal.13
...
LP09 *literal.110
LP10 literal.111
Is there any way to fix this? Or do I have to delete everything and start over and fix the work items? I'm thinking the Query is sorting by the process source, and the JRS Report by the actual value....
Accepted answer
Here my 2 cent. The sorting is an issue and not pretty. I think this came up before. What you can do is the following:
- Define an enumeration in the UI and save, but do not use it just yet.
- In the process configuration source change the literal ID's to be unique and correctly lexicographic sorting.
- Introduce a new attribute, editor presentation etc.
- Rename the old attribute and editor presentation so you can tell. (e.g. zzzz_do_not_use_old_Name)
- Create a query, that finds all the work item by the same old value. Use the update multiple work items to set the new enumeration to the correct value, do this for all the values.
- Retire the old stuff as good as possible and especially remove the old presentation