Server-side Nested Grid with Filtering (PHP and MySQL Setup)

[linuxloonieParticipant]

Hi,
First of all congratulations on creating a wonderful software. Currently working with the ‘server_side_grid__with_nested_grids’ example that came with the download of the ‘jqwidgets-ver4.1.2.zip’ file. To implement filtering on the main grid inserted the filter option inside the var source and also added the ‘filterable: true’ option to the $(“#jqxgrid”).jqxGrid (jsfiddle link below). After this filter option is now available along with the sort function in the grid’s title bar. In the data.php file inserted the ‘if (isset($_GET[‘filterscount’]))’ code block (with filter query modified accordingly) above the if (isset($_GET[‘sortdatafield’])) code block. After this ran a filter search but I got the below error,

jqxgrid.js:7 Uncaught Error: jqxGrid: The data is still loading. When the data binding is completed, the Grid raises the ‘bindingcomplete’ event. Call this function in the ‘bindingcomplete’ event handler.

My aim is to make the filtering work in conjunction with the nested grid but unable to do so. Am only a beginner in Javascript/jQuery so please help me out.

jsfiddle link: https://jsfiddle.net/qxw113um/

[HristoParticipant]

Hello linuxloonie,

The shared example url no response.
I would like to suggest you to look some different projects.
http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/nestedgrids.htm?arctic
http://www.jqwidgets.com/jquery-widgets-demo/demos/php/serverfiltering.htm?arctic
http://www.jqwidgets.com/jquery-widgets-documentation/documentation/phpintegration/bind-jquery-grid-to-mysql-database-using-php.htm?search=
(those examples could be helpful)
We could give advice on some small particular issue about our widgets.
Looks like the nested grid does not receive data.
Please try with simple example.

Best Regards,
Hristo Hristov

jQWidgets team
http://www.jqwidgets.com

[linuxloonieParticipant]

Thanks for taking the time to reply.

“The shared example url no response.”

Created the ‘jsfiddle’ to show only the changes I made in the index.php’s javascript code.

“http://www.jqwidgets.com/jquery-widgets-documentation/documentation/phpintegration/bind-jquery-grid-to-mysql-database-using-php.htm?search=”

After posting in your forum, I worked out each and every ‘server_side_grid’ example you’ve provided in the “jqwidgets-ver4.1.2.zip” under the “phpdemos” folder in my WAMP setup. Now I have a fair understanding of how the grid works and how sorting, pagination and filtering options work.

My doubt is whether is it possible to implement filtering in a Server-side Nested Grid.

“http://www.jqwidgets.com/jquery-widgets-demo/demos/jqxgrid/nestedgrids.htm?arctic”

[linuxloonieParticipant]

Thanks to your detailed online documentation, I was able to implement the filtering in a server-side nested grid setup. This post can be marked as Solved.

[Author]

Posts