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
Ralph Schoon (63.3k●3●36●46)
| answered Aug 15, 6:52 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER edited Aug 15, 8:27 a.m. 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:
Sterling Ferguson-II selected this answer as the correct answer
|
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.