Calling Rest Api when we filter on data, and on each next/previous page click.

[gourav@e-labs.aiParticipant]

Hi Team,

1. We want to pull data from Rest Endpoint and show it on the grid.

2. As our data is huge around 100k records in a single grid, we want to filter data run time basis i.e. Each of our filter will hit one rest query at Rest Endpoint to filter it further. Because we donot want to show complete data in one go.
In short for example – we want to show 25 records in 1 page and user can still filter on complete database table and as soon as user submits, data from db is retrieved to show data on ui in same grid.

3. As soon as user click on next page, data for next page should be retrieved from DB and shown to the grid.

[HristoParticipant]

Hello gourav@e-labs.ai,

I would like to suggest you look at this demo:
https://www.jqwidgets.com/jquery-widgets-demo/demos/php/index.htm#demos/php/serverfiltering_paging_and_sorting.htm
It demonstrates how to bind to the database and also, it handles filtering and paging on the Server-Side.
You could change the default settings of the pager to show more records via the pagesize property and also, you could combine it with the pagesizeoptions property.
Also, I would like to suggest you look at this help-topic:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/phpintegration/php-server-side-grid-paging-and-filtering.htm?search=
There you could find how to handle the query parameters which the jqxGrid sends to the server.
The same approach you could use in your environment.

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[gourav@e-labs.aiParticipant]

Hi,

This example talks about JavaScript/jQuery and PHP.

Can I use Angular and Java ? Do we have some example of TS code around that ?

[HristoParticipant]

Hello gourav@e-labs.ai,

The approach is similar to the one mentioned before.
Please, take a look at this tutorial:
https://www.jqwidgets.com/jquery-widgets-documentation/documentation/java-integration/grid-server-side-sorting-paging-filtering-using-jsp.htm?search=
More specifically for the Angular project, I would like to suggest you look at this tutorial:
https://www.jqwidgets.com/angular-components-documentation/documentation/angular-serverside/angular-serverside-filtering.htm?search=

Best Regards,
Hristo Hristov

jQWidgets team
https://www.jqwidgets.com

[Author]

Posts