Odata URL question

Relativity Server
1

If I have a schema datatable (UsersTable) defined with a parameter (:adminId) - how do I specify that in the URL I am passing int ?

If I try :
http://localhost:8090/odata/UsersTable?adminID=1

I just get a syntax error from by database engine because no parameter substitution was done.

Also -second related question - if I’m using linqpad4 (as suggested for testing by http://www.remobjects.com/da/odata.aspx) - how would I pass these parameters in ?

Thanks in advance…

2

Hello.

If I try :
http://localhost:8090/odata/UsersTable?adminID=1
I just get a syntax error from by database engine because no parameter substitution was done.

To solve the problem you need to use such a syntax:
http://localhost:8090/odata/UsersTable?$filter=@adminID eq 1

Also -second related question - if I’m using linqpad4 (as suggested for testing by http://www.remobjects.com/da/odata.aspx) - how would I pass these parameters in ?

Not sure that using “filter” parameter in linqpad4 is simple but you can follow instructions described at http://naveensrinivasan.com/category/linqpad/. Alternatively you can get resultest by using the url above in any browser.

Hope this helps.