Sorting found set by field in portal
I am trying to sort the records by a field in a portal row, however it is not working.
I have a checkbox called "Preferred", I want to sort the list of results by this field.
However when I do the sort by field, the record that is ticked in the portal as preferred is not appearing as 1/5 etc
I have tried sorting by both ascending and descending however still no luck. The reason for this is I want to create a button on the records that are not marked as "preferred" which will allow the user to click the button and it will take them to the first record in the found set (the record with the preferred checkboxed checked)
Any help would be much appreciated.