I want to sort order my REST results data with a lookup column's Id in my SharePoint list.
I tried using $orderby in my REST query, but got no luck.
can anyone of you help me out with this ?
below is the query I am using and in that "CourseTitle" is the field based on whose Id I want to order the result. Please note that I want to sort by Id only, Not by LookUp Title.
_spPageContextInfo.webAbsoluteUrl + "_api/web/lists/getbytitle('Training Evaluation')/items/?$select=Title,Id,CourseTitle/Id,CourseTitle/Title&$expand=CourseTitle&$orderby=CourseTitle"
OrderBy
always sorts lookup title, not id. You can try sorting it after you get all the items using Javascript. – Akhoy Jul 27 '15 at 7:28