sorting pivot2/clickable URLs by the clickable value displayed and not the URL itself

How are you converting the values in that column to a clickable link? We use a script to accomplish the same thing, but we've never noticed any issues with sorting the resulting links.

Here's an example of what I mean:

The "Matter Name" column is normally NOT a hyperlink; it's just plain text. We convert it into a clickable URL with a widget script. The script we use is constructing the link using a hardcoded base URL and then dynamically adding the values from the "Primary Key" and "Object Type" columns. So the first row's URL would be something like "[baseURL]/TRAN_692999" while the second row would instead be "[baseURL]/DISP_939420".

As you can see, I'm sorting by the "Matter Name" column and it appears to be sorting as expected: alphabetically ascending by the actual text of the Matter Name itself. It's not sorting by the HTML code or the URL, because it if were, then that first row would've sorted to the bottom (since "[baseURL]/DISP_..." would come before "[baseURL]/TRAN_...").

Hey bminehart ,

from the screenshot shared, the Sorting is minimal due to Pivot Grouping level. 
in case the link is Unique: 

1. Does the sorting works with a single column in the Pivot rows? 
2. can the Grouping level can be removed, for example, place the Link or primary column in the first Pivot Row?
3. Does the Hyperlink generated via the datamodel or pivot script?
   in case it's pivot script, as Jake_Raz mentioned the sorting should work 

Grouping screenshot: 

best regards

Hello @bminehart,

I’m following up to see if the solutions offered by @AssafHanina or @Jake_Raz worked for you.

If so, please click the 'Accept as Solution' button on the appropriate post, that way other users with the same questions can find the answer. If not, please let us know so that we can continue to help.

Thank you.