Forums

That is called "server-side pagination and sorting", that is the name you will find in the list of examples. You are asking for pagination but when doing it on the server side, it requires sorting to be handled on that side as well.

In some browsers, calculating the layout of the page takes a very long time and it may be several times the data retrieval at the server and its transmission to the client. Check out where your time is being spend, your server-side delays might not be the issue.

The links to the pages are generated by the Paginator component based on two pieces of data you give it. One is the rows per page configuration attribute that you provide when you create the Paginator instance. The other is the total number of pages that you get from the server as 'meta-data' and that you can extract in the handleDataReturnPayload. Usually, this comes from a plain Select count(*) SQL statement done prior to the actual query. If you don't know how many, Paginator provides the YAHOO.widget.Paginator.VALUE_UNLIMITED constant to leave it open.

http://developer.yahoo.com/yui/docs/YAH ... _UNLIMITED

To keep easy for you to undestand, this is my code for the page?

"
YAHOO.ServerPagination = new function() {
//Columns
var ColumnsDef = [
{ key: "timestamp", label: "Timestamp" },
{ key: "status", label: "Status" },
{ key: "title", label: "Title" },
{ key: "objectname", label: "Objectname" },
{ key: "callingname", label: "Callingname" }
];

this.WebSupervisor = new JsonService("WebSupervisor.ashx");
this.MO = "Three Phase Transformer 01";

//DataSoruce
var ValSource = new YAHOO.util.DataSource("mySQLStatement (that will return 25 rows)");
ValSource.responseType = YAHOO.util.DataSource.TYPE_JSON;
ValSource.responseSchema = {
maxCacheEntries: 10,
resultsList: "eventList", //the list of data that will be populated on the datatable
totalRecords: "MaxRows", //the total number of data that exists on the table
pageSize: 10,
fields: ["timestamp", "status", "title", "objectname", "callingname"]
};

//Request generate data
var CustomRequest = function(oState, oSelf) {
oState = oState || { pagination: null, sortedBy: null };
var startIndex = (oState.pagination) ? oState.pagination.recordOffset : 0;
};

//Table configuration
var DataConfig = {
generateRequest: CustomRequest,
paginator: new YAHOO.widget.Paginator({
pageLinks: 10,
rowsPerPage: 20
})
}

//DataTable
var EventTable = new YAHOO.widget.DataTable("EventsTable", ColumnsDef, ValSource, DataConfig);

//Pagination handle data
EventTable.handleDataReturnPayload = function(oRequest, oResponse, oPayload) {
oPayload.totalRecords = oResponse.meta.totalRecords;
return oPayload;
}
}
"

Is something missing to do what I want?

My data is a new class that I created that will generated an array used by the JSArray:

the metadata generated by the json data is:
eventList: list of all data that will populate the DataTable
MaxRows: the total number of rows in the specific table that I run my sql statement ("select count(*) from mytable")

then I repass those values to the responseSchema like the example show me:
myDataSource.responseSchema = {
resultsList: "eventList",
fields: ["timestamp", "status", "title", "objectname", "callingname"],
metaFields: {totalRecords: "MaxRows" }
}

using that and the handleDataReturnPayload should be the necessary to make the DataTable works like I wanted, rightt?

the eventList is returnin a list of 20 events and MaxRows a string "2947" which is the total number of rows in the table according to the select statement.

Well, Satyam. It's not like my DataTable is not working, what I want to know if there is any possibility that I can make the Paginator works a little different from the default.

My JSONData is valid in JSONLint.

As far as I have tested so far is that I cannot control the way the paginator counts the total number of page links like an asp.net gridview does (I don't want to compare the tools).

It's just that, what I am searching now if there anyway of creating a custom paginator control to do that!

Thanks for all your responses, you show me a lot of things that I could do with YUI.