Do you see numbers? Not me
It's known that right after 0 is 100 and all the others come after
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.
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).
Agenda Presentation: What's New in FDI 26.R3 Open Q & A: Ask your questions of implementation and product specialists Replays of past FDI CEAL Guidance Office Hours are available on Oracle VideoHub here. Fusion Data Intelligence - CEAL Guidance Office Hours The FDI Office Hours are hosted by CEAL solution architects who…
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (CX). The session will cover updates on Service, Sales, Marketing & other relevant areas. Presented by: Kausik Misra - Director, CX Product Management, Fusion Data Intelligence…
Build on the foundational concepts from Part 1 with a deeper look at implementation patterns for extending the FDI semantic model. This session covers common use cases such as modifying subject areas, creating custom subject areas, combining external application models, and supporting custom security requirements. It also…