I have a list A, which has a column owner
of type "Person or Group". I am using REST API to query this list(using jquery).
I would like to use column owner
to filter records by username. I have a user/group picker from which I get username in this format: i:0#.f|membership|username
The query I am trying is:
http://site//_api/web/lists/getbytitle('A')/items?$select=column1,column2$filter=owner/LoginName eq 'i:0#.f|membership|username'
But I am getting error 500 with message
"One or more field types are not installed properly. Go to the list settings page to delete these fields."
I would like to know what I am donig wrong
Also is there any other way to filter using username?