I’m trying to get some code working using OData. The following bit of code doesn’t seem to work.
ds is OpenDataServiceProxy.
adapterTypeId is the string representation of a Guid.
adapterName is a string name
ds.query('/DataAdapters?$filter=DataAdapterType.DataAdapterTypeId eq guid(\'' + adapterTypeId + '\') and Name eq \'' + adapterName + '\'', ifmgr_CreateAdapter_Step1, onGenericFailure, 'Error');
The above line give the following error:
Expression of type ‘System.Boolean’ expected at position 0.
If I remove the Guid section of the filter so that it’s just using the “Name” part it works fine.
The DataAdapters table field “DataAdapterTypeId” is foreign keyed to the “DataAdapterTypes” table DataAdapterTypeId field.
Can anyone spot what I’m doing wrong?
-------------------EDIT----------------------
OK, I've changed the filter as shown below. I no longer get an error but get lots of results back rather than one record that matches the filter. Can anyone say why it's not filtering?
ds.query('/DataAdapters?($filter=Name eq \'' + adapterName + '\' and $filter=DataAdapterTypeId eq guid\'' + adapterTypeId + '\')', ifmgr_CreateAdapter_Step1, onGenericFailure, '');