filter 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

Reply | Reply with quote

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,

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">

------------

</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,

Your Complete Code
Json String

To get JSON string, please refer the below image,

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

Regards,

Padmavathy Kamalanathan

Reply | Reply with quote

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

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

Reply | Reply with quote

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

Reply | Reply with quote

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

Reply | Reply with quote

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>

</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

Reply | Reply with quote

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.

Reply | Reply with quote

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.

Reply | Reply with quote

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

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US