We would like to do a crossjoin to get items with their translations.
So we came up with the following url:
$crossjoin(Items,MultiLanguageTranslations)?$expand=Items($select=ItemCode, ItemName,ItemsGroupCode),MultiLanguageTranslations($select=TableName,FieldAlias,PrimaryKeyofobject)&$filter=Items/ItemCode eq MultiLanguageTranslations/PrimaryKeyofobject and MultiLanguageTranslations/TableName eq 'OITM'
But now we also would like to get the actual translation from the MultiLanguageTranslations.TranslationsInUserLanguages property.
How can we achieve this?