rest - Cannot filter by string from remote url -
created wcf data service pull data oracle database , when debugging in vs can use ?$filter syntax filter returned sets.
however, using remote url cannot.
point note: can filter integers , dates, cannot filter strings.
also, cannot filter string field in code. filter ignored.
sample item below:
<?xml version="1.0" encoding="utf-8" standalone="yes"?> <feed xml:base="http://localhost:61905/campaignersvc.svc/" xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices" xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" xmlns="http://www.w3.org/2005/atom"> <title type="text">contacts</title> <id>http://localhost:61905/campaignersvc.svc/contacts</id> <updated>2015-04-29t15:06:48z</updated> <link rel="self" title="contacts" href="contacts" /> <entry> <id>http://localhost:61905/campaignersvc.svc/contacts(23517014)</id> <title type="text"></title> <updated>2015-04-29t15:06:48z</updated> <author> <name /> </author> <link rel="edit" title="contactlist" href="contacts(23517014)" /> <category term="campaigner_dal_wcf.contactlist" scheme="http://schemas.microsoft.com/ado/2007/08/dataservices/scheme" /> <content type="application/xml"> <m:properties> <d:licensenumber m:type="edm.int32">23517014</d:licensenumber> <d:clientcode>2000</d:clientcode> <d:clientname>doodler</d:clientname> <d:clientmnemonic>dd</d:clientmnemonic> <d:lastname>kerr</d:lastname> <d:firstname>rover</d:firstname> <d:middlename>frank</d:middlename> <d:title>mr.</d:title> <d:preferredfirstname>rover</d:preferredfirstname> <d:preferredmiddlename>frank</d:preferredmiddlename> <d:companyname m:null="true" /> <d:jobtitle m:null="true" /> <d:gender>m</d:gender> <d:dateofbirth m:type="edm.datetime">1947-04-27t00:00:00</d:dateofbirth> <d:primarychaptercode m:type="edm.int16">400</d:primarychaptercode> <d:alternatechaptercode m:type="edm.int16" m:null="true" /> <d:mainaddrstreetno>121</d:mainaddrstreetno> <d:mainaddrline1>so crescent</d:mainaddrline1> <d:mainaddrline2 m:null="true" /> <d:mainaddrline3 m:null="true" /> <d:mainaddrcity>maick</d:mainaddrcity> <d:mainaddrprovcode>on</d:mainaddrprovcode> <d:mainaddrprov>ontario</d:mainaddrprov> <d:mainaddrpostalcode>kb7</d:mainaddrpostalcode> <d:mainaddrcountrycode>ca</d:mainaddrcountrycode> <d:mainaddrcountry>canada</d:mainaddrcountry> <d:mainphonenum>610-000-0703</d:mainphonenum> <d:mainphoneext m:null="true" /> <d:mainfaxnum m:null="true" /> <d:mainemailaddr>someone@rogers.com</d:mainemailaddr> <d:cellphonenum m:null="true" /> <d:changetype>d</d:changetype> <d:eventtimestamp m:type="edm.datetime">2015-04-29t02:40:02</d:eventtimestamp> <d:privacyindicator>n</d:privacyindicator> </m:properties> </content> </entry> </feed>
you can filter string using string in quotes below-
'string'
Comments
Post a Comment