Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > WCF OData Clientside binding with filter from dropdown

• Marcel

  Posted on Sep 6, 2011 (permalink)

  Hi,
  Can you help me with an example of setting a filter on a oData Clientside binded RadGrid.
  For example:
  I want to filter my Table Patients on Surname contains 'Jan'
  
  
  Hope you can help me.
  Greetings
  Marcel de Groot
  

  Reply

• Tsvetoslav Tsvetoslav

  Posted on Sep 9, 2011 (permalink)

  Hello Marcel,
  
  Your requirement is demonstrated in the following online example:
  http://demos.telerik.com/aspnet-ajax/grid/examples/clientbinding/defaultcs.aspx
  
  Hope it helps.
  
  Regards,
  Tsvetoslav
  the Telerik team

  Thank you for being the most amazing .NET community! Your unfailing support is what helps us charge forward! We'd appreciate your vote for Telerik in this year's DevProConnections Awards. We are competing in mind-blowing 20 categories and every vote counts! VOTE for Telerik NOW >>

  Reply


• Marcel

  Posted on Sep 13, 2011 (permalink)

  Thanks for you answer, but not what i expected.
  The only example i see is:
  

  <ClientSettings><BR> <DataBinding

  Location="http://services.odata.org/Northwind/Northwind.svc"

  ResponseType="JSONP"><BR> <DataService TableName="Products" Type="OData"

  /><BR> </DataBinding><BR> </ClientSettings><BR>

  
  but what i really want is something like this:
  

  <ClientSettings><BR> <DataBinding

  Location="http://services.odata.org/Northwind/Northwind.svc"

  ResponseType="JSONP"><BR> <DataService

  TableName="Products<STRONG>?$filter=substringof('Alfreds', CompanyName) eq true" Type="OData" /><BR> </DataBinding><BR>

  </ClientSettings><BR>

  
  So i only get companynames containing Alfreds.
  
  Hope you can help me.
  
  

  Reply

• Tsvetoslav Tsvetoslav

  Posted on Sep 15, 2011 (permalink)

  Hello Marcel,
  
  Filter operators are not supported as yet by RadGrid's binding to OData service. I will forward this as a feature suggestion to our development team.
  
  
  Regards,
  Tsvetoslav
  the Telerik team

  Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal

  Reply

• Tsvetoslav Tsvetoslav

  Posted on Sep 21, 2011 (permalink)

  Hello Marcel,
  
  I am glad to inform you that the feature we were discussing has already been implemented into RadGrid's OData binding. Now it sports a FilterQueryOption and a SortQueryOption property where you can add your filter and sort condtions. NB: the $filter= and $orderby= operators along with the equal sign should not be included in the values for those two properties.
  
  The improvement should be available in the next latest internal build of the controls that should come out by the end of the week or in the beginning of the next one.
  
  Regards, Tsvetoslav
  the Telerik team

  If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now

  Reply

• Ronak Intermediate

  Posted on Feb 21, 2012 (permalink)

  Thanks Telerik team
  i would like achive same thing like bind combobox to one entity and once user select value it will bind grid and Telerik odata binding support Filter can you please point me to direction mean some examples i am not able to find on telerik sites.
  
  Thanks
  Ronak

  Reply

• Tsvetoslav Tsvetoslav

  Posted on Feb 24, 2012 (permalink)

  Hello Ronak,
  
  In order to accomplish this requirement, just set the AutoPostBack property of the combo box to true and attach an event handler to its SelectedIndexChanged event. In the event handler on the server, get hold of the newly-selected item and build your filter query as per your scenario. Then assign it to the grid's FilterQueryOption setting. Upon the page being rendered the grid will trigger a web service request to the OData service now with the new filter query option in its settings and get the filtered data.
  
  Hope it helps.
  
  
  Regards, Tsvetoslav
  the Telerik team

  If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.

  Reply

• Ronak Intermediate

  Posted on Feb 24, 2012 (permalink)

  Thanks Tsvetoslav for your reply i know that but i can not write any Server side code here as we can not access service my development box i know its strange so please advise me if i can achieve through client side.As you know for Odata we do not have to write any Server side code so i would like to get it done through Odata.
  
  Thanks
  Ronak

  Reply

• Tsvetoslav Tsvetoslav

  Posted on Feb 29, 2012 (permalink)

  Hello Marcel,
  
  If you need to do it on the client, just use the $find('<%=YouGridID.ClientID').ClientSettings.DataBinding.DataService.FilterQueryOption to set the query option. If you are using RadComboBox, this should be done in the SelectedIndexChanged client-side event of the combo.
  
  
  Regards, Tsvetoslav
  the Telerik team

  If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.

  Reply

• Ronak Intermediate

  Posted on Feb 29, 2012 (permalink)

  Thanks for you reply

  Reply

Back to Top

Home / Community & Support / Developer Productivity Tools Forums / ASP.NET AJAX > Grid > WCF OData Clientside binding with filter from dropdown