foreign property sort

Hi All

I need to sort on a foreign property from a related Itemtype. Has anyone tried that?

Usually we will set the column ‘Order by’ in property for a ItemType to sort after a specific column. But when I set ‘Order by’ column for a foreign property it does not sort the table on the chosen column as I thought it would.

Can anyone help?

Thank you in advance.

  • I never have tested this one, but from a technical perspective foreign properties behave different then regular ones. Inside the database foreign properties are empty, so there is nothing available to sort. 

    Maybe you can link the foreign value to the keyed_name property and then sort the keyed_name. But that´s just an idea.