We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

filter grid

Thread ID:

Created:

Updated:

Platform:

Replies:

145505 Jun 25,2019 11:01 PM UTC Jul 1,2019 05:09 AM UTC ASP.NET Web Forms 7
loading
Tags: Grid
Alfonso
Asked On June 25, 2019 11:01 PM UTC

Good day

I need your support for a couple of details with a data linked in a GRID.

1.- When you apply the filter in a GRID and execute another event (link button), the filter that was loaded on the GRID in which it is loaded can not see the content there.(attached Video)

2.- Something similar happens when the link button is executed but with different data about the date objects, these or the same data that is stored there or does not bring anything when a query is executed.

I tried clean the datasource but doesn´t work it (in the code on the script part i commentted these lines)

Attach code and video on same file.

From your support and understanding, thank you, best regards.

Attachment: Consulta_Contenedor_727fc2d1.7z

Padmavathy Kamalanathan [Syncfusion]
Replied On June 26, 2019 04:03 PM UTC

Hi Alfonsa, 

Thanks for contacting Syncfusion Forums. 

QUERY: cannot see the content after filtering 


From your query we understand that, initially you render grid by filtering particular records (by choosing start date and end date) and binding it to grid. After rendering the grid, on performing filtering, the grid content get emptied. 

Please refer the below sample for your reference, 

In the above sample, before rendering the grid, particular data are filtered  (by posting query) and binded to grid. After Grid Rendering, when you perform filter operation, both the queries ( (1)query used for initial rendering for fetching particular record , (2)query for filtering record after the rendering) will be sent as ajax post.  

Please refer the below code, 

         
 
<ej:Grid ID="OrdersGrid" runat="server" Query="ej.Query().where(ej.Predicate('OrderID', ej.FilterOperators.lessThan, 10448, true).and('ShipCountry', 'notequal', 'null', true))" AllowPaging="True" AllowFiltering="True"> 
        <DataManager URL="//js.syncfusion.com/demos/ejServices/Wcf/Northwind.svc/Orders/" CrossDomain="true"></DataManager> 
            <FilterSettings FilterType="Menu"></FilterSettings> 
            <Columns> 
                 ------------ 
            </Columns> 
                 ------------- 
        </ej:Grid> 



You have not shared details regarding Grid Rendering and Data Binding to the Grid. 

Try the above solution and if you still face the same issue, please share us the below details, 

  1. Your Complete Code
  2. Json String

To get JSON string, please refer the below image, 

 


If we have misinterpreted your query, please let us know. 

Regards, 
Padmavathy Kamalanathan 


Alfonso
Replied On June 26, 2019 10:50 PM UTC

i read documentation was you give me, but i cant adapted to my proyect

ok i will send all my code zipped, i will upload in my onedrive because the its more big than than maximun file size permitted

and added json string who execute and bring results:

var obj = $("#Grid").data("ejGrid")
undefined
obj
undefined
JSON.stringify(obj)
undefined


thank you for supporting me

Padmavathy Kamalanathan [Syncfusion]
Replied On June 27, 2019 03:15 PM UTC

  
Hi Alfonso, 
 
Thanks for contacting Syncfusion Support. 
 
QUERY: cannot see the content after filtering 
 
We are validating your query. We will get back to you tomorrow (27/06/2019). 
 
Till then we appreciate your patience. 
 
Regards, 
Padmavathy Kamalanathan 


Padmavathy Kamalanathan [Syncfusion]
Replied On June 27, 2019 03:20 PM UTC

Hi Alfonso, 
 
Please ignore the previous update
 
QUERY: cannot see the content after filtering 
 
We are validating your query. We will get back to you tomorrow (28/06/2019). 
 
Till then we appreciate your patience. 
 
Regards, 
Padmavathy Kamalanathan


Padmavathy Kamalanathan [Syncfusion]
Replied On June 28, 2019 12:32 PM UTC

Hi Alfonso, 

Thanks for your patience. 

From your query we understand that you have issue with loading all records, when you filter records and then change the date and trying to render grid for those selected records. We have validated your query. The issue is due to the caching of data (last filtered record) . Thus the grid with selected date’s record can’t be rendered. We suggest you to use EnableViewState property. When you set EnableViewState to false, the view state of the grid will not be maintained and thus when you change date and click button to render records, the grid will be rendered properly. 

        
 <ej:Grid ID="grdIngresoCont" runat="server" AllowSorting="true" AllowResizing="true" 
 
 AllowScrolling="true" AllowFiltering="true"  
           
            EnableViewState="false"  > 
 
            <Columns> 
                  -------- 
            </Columns> 
        </ej:Grid> 

Please refer the below sample, 

If you have further queries, please get back to us. 

Regards, 
Padmavathy Kamalanathan 


Alfonso
Replied On June 28, 2019 03:54 PM UTC

The solution proposed works very well in my code.

Thank you by you supporting and patience with me, thank you

good day and best regards.

Manivannan Padmanaban [Syncfusion]
Replied On July 1, 2019 05:09 AM UTC

Hi Alfonso, 

We are happy to hear that the mentioned issue has been resolved. 

Please get back to us, if you need further assistance. 

Regards, 
Manivannan Padmanaban. 



CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon