Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 39 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI 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
