Added serial numbers for Datatables (1.10 new implementation)

Little scum · Posted on 11/14/2017 1:52:30 PM

JQuery's Datatables plugin is very good for making tables.

I thought it was easy to add a serial number to the table, but after reading the official implementation of Datatables, the code seems to be not simple, and the test found some problems, and it was not easy to use. I didn't find a good solution on the Internet, so I traced the code and found a way myself.

Serial number implementation (convenient, unofficial implementation)
Since column data can be a function, then look at the data in the parameters. It turned out that some useful data was indeed found and we started to get started.

The code is as follows:

Login is visible.

The point is the following sentence
meta.settings._iDisplayStart + meta.row + 1;
After analysis, it is known that:
meta.settings._iDisplayStart The starting index of each record displayed;
meta.row+1 is the row index of the current page, plus 1 is the line number;
The sum of the two is the line serial number of the current period.

This method is not officially provided or recommended, but I think it is more intuitive and less expensive to handle the displayed data in data.

QWERTYU · Posted on 11/14/2017 2:44:37 PM

Little scum · Posted on 3/8/2018 2:25:32 PM

name	type	description
draw	integerJS	The number of requests is countered, and it is returned as it is each time it is sent to the server.
start	integerJS	The starting position of the first piece of data, for example, 0 represents the first piece of data
length	integerJS	Number of items displayed per page.
search[value]	stringJS	Global search criteria for each column (searchable needs to be set to true)
search[regex]	booleanJS	If true means that the value of the global search is processed as a regular expression, if false it is not.
order[column]	integerJS	i is an array index, corresponding to columns, starting from 0, and the subparameter indicates which column needs to be sorted
order[dir]	stringJS	The column is determined above, and the sorting method of this column is descending asc
columns[data]	stringJS	columnsbinding, defined by columns.data
columns[name]	stringJS	columns.name
columns[searchable]	booleanJS	Whether a tagged column can be searched to true means yes, otherwise it can't, which is controlled by columns.searchable
columns[orderable]	booleanJS	Whether the tagged columns can be sorted to true means yes, otherwise no, this is controlled by columns.orderabl
columns[search] [value]	stringJS	Search criteria for specific columns
columns[search] [regex]	booleanJS	Whether a search criteria for a particular column are considered regular expressions

[Jquery] Added serial numbers for Datatables (1.10 new implementation)

Related Posts

Sections viewed