ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: queensgambit9 on August 15, 2018, 01:40:54 am

Title: Remote paging
Post by: queensgambit9 on August 15, 2018, 01:40:54 am

Using remote paging which works fine with v5.1.0...
When upgrading to v5.2.0 it stoppped working...no figures are displayed.

Are there some adjustments needed? No error in console.

Title: Re: Remote paging
Post by: paramvir on August 15, 2018, 06:39:38 am

Remote paging works same in both versions. Outgoing params are pq_curpage and pq_rpp in both cases.

https://paramquery.com/pro/demos/paging

https://paramquery.com/pro/demos51/paging

Only thing changed is css class names of pager elements, that may affect if custom jquery/js code is used to manipulate the view of pager.

Title: Re: Remote paging
Post by: queensgambit9 on August 15, 2018, 04:08:50 pm

As I load paramquery-5.2.0/pqgrid.min.js its gone.
Checking the elements the data is not there. Return from DB is fine and keys are correct...any tip how to troubleshoot this?

Thanks.

Title: Re: Remote paging
Post by: paramvir on August 15, 2018, 10:49:19 pm

Pleae open your browsers' console, under network tab check the outgoing parameters from grid and incoming response from remote server.

Title: Re: Remote paging
Post by: queensgambit9 on August 16, 2018, 01:46:33 pm

Request:
....php?pq_datatype=json&pq_curpage=1&pq_rpp=20&_=1534407201899

Response:
{"totalRecords":12345,"curPage":1,"data":[{"...

Title: Re: Remote paging
Post by: paramvir on August 16, 2018, 02:24:17 pm

That looks right.

How does the pager look like? Any screenshot to share.

Please ensure to replace all old pqgrid css files with new version files during migration to new version.

Title: Re: Remote paging
Post by: queensgambit9 on August 16, 2018, 04:39:57 pm

- Tried your example (https://paramquery.com/pro/demos/paging).
- Removed 5.2.0, downloaded again and doublechecked versions.

Still same problem..

Included files and order:

Code: [Select]

<!-- jQuery -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/jquery-ui.min.js"></script>
<link rel="stylesheet" href="https://ajax.googleapis.com/ajax/libs/jqueryui/1.12.1/themes/redmond/jquery-ui.css">

<!-- ParamQuery Grid -->
<link rel="stylesheet" href="paramquery-5.2.0/pqgrid.min.css">
<link rel="stylesheet" href="paramquery-5.2.0/pqgrid.ui.min.css">
<script src="paramquery-5.2.0/pqgrid.min.js"></script>

<!-- pqSelect -->
<link rel="stylesheet" href="paramquery-5.2.0/pqSelect/pqselect.min.css">
<script src="paramquery-5.2.0/pqSelect/pqselect.min.js"></script>

<!-- jsZip file to support xlsx and zip export -->
<script src="paramquery-5.2.0/jsZip-2.5.0/jszip.min.js"></script>
<script src="FileSaver.min.js"></script>
Screenshot is attached.

Thanks for help.

Title: Re: Remote paging
Post by: paramvir on August 16, 2018, 05:31:13 pm

Thanks for screenshot and include file details.

Please include the localization file too, it's necessary since v5.2.0.

Title: Re: Remote paging
Post by: queensgambit9 on August 16, 2018, 06:16:52 pm

Works fine. Thank you.