I have a query that brings the contents of a list based on a query like this:
https://myserver.com/LibraryABC/_api/lists/getbytitle('MyList')/items?$select=*,FileLeafRef&$filter=(MyField eq '700095')
This was working before some changes that were made in Sharepoint. Now the same causes the following error:
<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <m:code>-1, Microsoft.SharePoint.SPException</m:code> <m:message xml:lang="es-ES"> No se puede usar el campo "MyField" de tipo "BusinessData" en la expresión de filtro de consulta. </m:message> </m:error>
The error message translation would be something like this:
The field "MyField" of type "BusinessData" cannot be used in an expression of filter or query.
I think they have changed the field to update it from an external source (not sure) so it cannot be queried. Exists some way to overcome this?