Skip to main content
SharePoint

Return to Question

Tweeted twitter.com/#!/StackSharePoint/status/563014154005790721
edited tags
Link
Ciprian Grosu
Ciprian Grosu
  • 347
  • 3
  • 9
added 144 characters in body
Source Link
Ciprian Grosu
Ciprian Grosu
  • 347
  • 3
  • 9

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer with Id equal to 10 for example ?

I've tried :

http://myserver:10113/_vti_bin/listdata.svc/Activities()?$filter=Engineer/Id eq '10'&$expand=Engineer&$select=Id,Name,StartDate,EndDate,Engineer/Id,Engineer/FirstName, Engineer/LastName

For this I receive thet 'Id' property do not exist. I think this is because Engineer is a colection.

Or if somewone know how to do this using LINQ and WCF Data Services in Visual Studio 2010 ? Then I will use Fiddler to see the call translation.

Thank you !

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer with Id equal to 10 for example ?

I've tried :

http://myserver:10113/_vti_bin/listdata.svc/Activities()?$filter=Engineer/Id eq '10'&$expand=Engineer&$select=Id,Name,StartDate,EndDate,Engineer/Id,Engineer/FirstName, Engineer/LastName

For this I receive thet 'Id' property do not exist. I think this is because Engineer is a colection.

Thank you !

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer with Id equal to 10 for example ?

I've tried :

http://myserver:10113/_vti_bin/listdata.svc/Activities()?$filter=Engineer/Id eq '10'&$expand=Engineer&$select=Id,Name,StartDate,EndDate,Engineer/Id,Engineer/FirstName, Engineer/LastName

For this I receive thet 'Id' property do not exist. I think this is because Engineer is a colection.

Or if somewone know how to do this using LINQ and WCF Data Services in Visual Studio 2010 ? Then I will use Fiddler to see the call translation.

Thank you !

Source Link
Ciprian Grosu
Ciprian Grosu
  • 347
  • 3
  • 9

REST API Filter by multilookup property

Having an Activities list with a column called Engineer of type lookup that allow multiple values. How to build a call to listdata.svc in order to get only activities that are asigned to an Engineer with Id equal to 10 for example ?

I've tried :

http://myserver:10113/_vti_bin/listdata.svc/Activities()?$filter=Engineer/Id eq '10'&$expand=Engineer&$select=Id,Name,StartDate,EndDate,Engineer/Id,Engineer/FirstName, Engineer/LastName

For this I receive thet 'Id' property do not exist. I think this is because Engineer is a colection.

Thank you !