StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POYui Datatable with AutoComplete and Pagination
text
Body
copied!<p>I try to understand how use server-side Pagination for Dynamic Data (I see example : <a href="http://developer.yahoo.com/yui/examples/datatable/dt_dynamicdata.html" rel="nofollow noreferrer">http://developer.yahoo.com/yui/examples/datatable/dt_dynamicdata.html</a>).</p> <p>My problem is I can not customize my request, when I try the pagination, my request is : qct-list.htmlsort=geneid&dir=asc&startIndex=50&result=25</p> <p>The request should be in the following form : qct-list.html?name=cd4&symbol=cd4&start=0&limit=25 or qct-list.html?name=cd4&symbol=cd4&start=25&limit=50 ...</p> <p>Here is a copy (part) of my code :</p> <pre><code> var myColumnDefs = [ {key:"geneid", label:"Gene", sortable:true}, {key:"name", label:"Name", sortable:true}, {key:"symbol", label:"Symbol", sortable:true}, {key:"lastupdated", label:"Last Updated", formatter:"date", sortable:true}, {key:"lastmodified", label:"Last Modified", formatter:"date", sortable:true} ]; var myDataSource = new YAHOO.util.DataSource("qct-list.html"); myDataSource.responseType = YAHOO.util.DataSource.TYPE_JSON; myDataSource.connXhrMode = "queueRequests"; myDataSource.responseSchema = { resultsList: "geneItemList", fields: ["col","qv","limit","start","geneid","name","symbol","lastupdated","lastmodified"], metaFields: { totalRecords: "totalRecords" // Access to value in the server response } }; var qctPaginator = new YAHOO.widget.Paginator({ rowsPerPage: 25, totalRecords : YAHOO.widget.Paginator.VALUE_UNLIMITED, template: YAHOO.widget.Paginator.TEMPLATE_ROWS_PER_PAGE, rowsPerPageOptions: [25,50,75,100] }); var myRequestBuilder = function(ostate, oSelf) { oState = oState || {pagination:null}; var name = Dom.get('dt_input_name').value; var symbol = Dom.get('dt_input_symbol').value; var start = (oState.pagination) ? oState.pagination.recordOffset : 0; var limit = (oState.pagination) ? oState.pagination.rowsPerPage : 25; return "?name=" + name + "&symbol"+ symbol + "&start=" + start + "&limit=" + limit; } var oConfigs = { dynamicData: true, // Enables dynamic server-driven data selectionMode: "single", paginator: qctPaginator , generateRequest : myRequestBuilder, paginationEventHandler : YAHOO.widget.DataTable.handleDataSourcePagination, initialRequest: "?name=&symbol=&start=0&limit=" }; var myGeneListTable = new YAHOO.widget.DataTable("geneListTable", myColumnDefs, myDataSource, oConfigs); myGeneListTable.handleDataReturnPayload = function(oRequest, oResponse, oPayload) { oPayload.totalRecords = oResponse.meta.totalRecords; return oPayload; } </code></pre> <p>Can someone explain how to use the pagination with DataTable and how to personalize request ?</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload