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

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

java - How to filter a backspace keyboard input -

java - Show Soft Keyboard when EditText Appears -