Change pageSize thru code?

[DaveyWaveyParticipant]

Hi folks,

Is it possible to change the height (pageSize) of a DataTable through code, and if so, an example would be very much appreciated.

The scenario:

I have a DataTable with serverProcessing=true displaying rows from a database via JSON.
I have hyperlinked the rows so that clicking on an item changes browser document.location to the details page for that item.
I have a ‘Close’ button on the item details page which takes me back to the DataTable page.

What I need:

When the ‘Close’ button is clicked, I need to be returned to the DataTable page showing the same results that were displayed before I clicked on an item to view its details.

By Same Results, I mean that the DataTable should display the same Paged data AND the same pageSize that was set.

What I’ve got:

Using PHP session variables I am re-displaying the DataTable at the correct Paged position.

But, I *cannot* get the DataTable to adjust its pageSize back to anything other than the default size of 10 rows.

It must be possible from Javascript to change the DataTable size because the ‘Show Rows’ dropdown of the Paging toolbar does it, but because the code is minified it’s going to take too long to find how it’s doing it.

Any help is much appreciated.

DW

[Peter StoevKeymaster]

Hi DW,

At present, you can do that only during the initialization of the widget by setting the pageSize property – http://jsfiddle.net/jqwidgets/pd6bg/

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[DaveyWaveyParticipant]

Peter,

Thanks for the quick reply. That is such a shame.

Are the API docs ahead-of-the-game, because they say:

Set the pageSize property.

$('#dataTable').jqxDataTable({ pageSize: 20 });

My code is currently doing this (with the desired pageSize being passed into it from the dataAdpater) but all it does is change the value in the ‘Show Rows’ dropdown – it won’t fire a redraw of the table.

I’ve attempted $("#dataTable").jqxDataTable('refresh'); but that doesn’t appear to do anything.

Is there some jQuery trick that could be used to click the ‘Show rows’ dropdown maybe?

DW

[Peter StoevKeymaster]

Hi DW,

pageSize is related to the data view, not only to the rendering which means that “refresh” will not be a solution. As I wrote, there is no option to dynamically set this property. Yes, the API says that you can set the pageSize and you can set it when you create the widget, but not after that.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[DaveyWaveyParticipant]

Thanks Peter,

At least knowing it can’t be done will stop me hitting my head against it.

I’ve worked around it now so both the page and the pagesize remain after returning from the display page.

DW

[Author]

Posts