filter grid

[Alfonso]

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]

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, 

https://asp.syncfusion.com/demos/web/grid/odatabinding.aspx 

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]

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

All Code

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]

  

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]

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]

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, 

https://www.syncfusion.com/downloads/support/directtrac/general/ze/WebApplication3493622603.zip 

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

Regards, 

Padmavathy Kamalanathan 

[Alfonso]

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]

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.