This question already has an answer here:

I have tried below URL for filter using Author column in list in REST API.


but it doesnt work in OnPremise. It works as expected in SharePoint Online.Please provide solution if anyone have.

marked as duplicate by Eric Alexander Jan 19 '17 at 15:12

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • try using $expand=Author and then $filter=Author\AuthorId – dsouzajoel22 Jan 19 '17 at 13:09

If you expand the field Author, you can filter it. Example:

$filter=Author/Id eq 18&$expand=Author&$select=Author/Id,Title


is it possible without select parameter ? No, it's not, when you expand a field you must provide the select with the output fields.

  • One is happy to be of service :) – Marco Jan 19 '17 at 14:24

Not the answer you're looking for? Browse other questions tagged or ask your own question.