SortSpec is not working for SSA Primary Field(Primary)

Hi All,

 

I am working on a requirement where client wants to sort a child list applet of the view  based on Primary and this primary list column is based 'SSA Primary Field'.

 

Since the SSA Primary Field does not map to any column in the base table and act as calculated field and Sorting is not possible in calculated field it gives below error:

"Sorting on calculated field 'SSA Primary Field' is not allowed.(SBL-DAT-00502)”

As per the MOS document “Sorting (Doc ID 479959.1)”  we can implement this requirement by creating a joined field with the parent BC table which stores the Row Id of primary selected record. And use this joined field for sorting.