Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 209 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OBIEE 12c - Watchlist sort order on Score column is alphabetical.

Comments
-
Do you see numbers? Not me
It's known that right after 0 is 100 and all the others come after
0 -
Yup, Gianni, I see numbers in the Score column, as shown in the screenshot. Are you saying that, on your system, you don't see numbers in the Score column? If so, I don't think I've done anything special to make it happen on mine. I'm on version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit). Also, I've assigned scores using the Show Advanced Properties checkbox on the States screen. Other than that, I can't imagine why you wouldn't see numbers in the Score column. Weird.
And you are absolutely correct that 0 is displayed first, then 100, then the others. My point is that the sort is treating the numeric Score column as char, and therefore it is sorting alphabetically rather than numerically. The underlying field is numeric -- when entering a Score on the States page, it won't accept anything other than numbers between 0 and 100. I can't imagine why anyone would think that it is correct to treat those numbers as characters and to sort them alphabetically. That makes ZERO sense.
0 -
Sorry @Mark T. , it was a totally not serious comment (because it's Saturday) and it's just totally absurd as thing.
Scores have always been numbers (actually percentages without the '%' sign), and it's totally dumb that there they are sorted as text.
Worth opening a SR asking for a fix I would say (maybe there is always something about it).
0