Sorting option on Report Definition does not work well
The report generated by Report Definition rule FullfillmentWorkbasket (of Assign-WorkBasket class) has been unreliable regarding sorting abilities.
When I click on a column header – such as Client Name (see screenshots in the attached .doc) – the report puts a value “Nescafe101” on top of all others even though the rest of the list is sorted alphabetically.
This can be observed on the column itself as well as on the Filter pop-up screen.
I spent hours trying to understand whether might be a problem with my design but no luck.
1) If you run the report definition directly (from the ruleform) is this reproducible?
2) When you the report, can you please capture the query from the clipboard (or tracer by enabling DB Query) and share it? Also, please execute the query directly against the DB and see if the same behaviour is observed.
Thanks Rajiv, this issue was resolved. It was not on PRPC side but on rooted in our bad data - one of the fields had empty white space in front of the values - it has not been properly truncated. Sorry for not updating the post promptly. Thank you for the follow up. Alec