Author Topic: Remote paging  (Read 2956 times)

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Remote paging
« 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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Remote paging
« Reply #1 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.

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Remote paging
« Reply #2 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.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Remote paging
« Reply #3 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.

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Remote paging
« Reply #4 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":[{"...

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Remote paging
« Reply #5 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.

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Remote paging
« Reply #6 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.
« Last Edit: August 16, 2018, 04:43:28 pm by queensgambit9 »

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Remote paging
« Reply #7 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.

queensgambit9

  • Pro Ultimate
  • Sr. Member
  • *
  • Posts: 341
    • View Profile
Re: Remote paging
« Reply #8 on: August 16, 2018, 06:16:52 pm »
Works fine. Thank you.