Imagine two tables:
TABLE A |TABLE B
Entity |Id
Id |name
Points |Ranking
How to use orderby with $expand:
$select=Entity,Id,Points,A_B/name&$orderby=Id asc&$expand=A_B
How can i order by Ranking which is from TABLE B? I've tried:
$select=Entity,Id,Points,A_B/name,A_B/Ranking&$orderby=A_B/Ranking asc&$expand=A_B
Not working It occurs the following error:
:: Error : 500: Internal Server Error: The expression 'IIF((Convert(value(Microsoft.Crm.Extensibility.OrganizationDataServiceVisitingQueryProvider).GetValue(p, value(System.Data.Services.Providers.ResourceProperty))) == null), null,
What this means?