Multi-Column Ordering

DataTables allows ordering by multiple columns at the same time, which can be activated in a number of different ways

Name

Position

Office

Age

Start date

Salary

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Office

Age

Start date

Salary

Complex Headers

When using tables to display data, you will often wish to display column information in groups. DataTables fully supports colspan and rowspan in the table's header, assigning the required order listeners to the TH element suitable for that column.

Name

HR Information

Contact

Position

Salary

Office

Extn.

E-mail

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Salary

Office

Extn.

E-mail

DOM Positioning

When customizing DataTables for your own usage, you might find that the default position of the feature elements (filter input etc) is not quite to your liking. To address this issue DataTables takes inspiration from the CSS 3 Advanced Layout Module and provides the dom initialization parameter which can be set to indicate where you wish particular features to appear in the DOM. You can also specify div wrapping containers (with an id and / or class) to provide complete layout flexibility.

Name

Position

Office

Age

Start date

Salary

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Salary

Office

Extn.

E-mail

Alternative Pagination

The default page control presented by DataTables (forward and backward buttons with up to 7 page numbers in-between) is fine for most situations, but there are cases where you may wish to customise the options presented to the end user. This is done through DataTables' extensible pagination mechanism, the pagingType option.

Name

Position

Office

Age

Start date

Salary

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Office

Age

Start date

Salary

Scroll - Vertical

This example shows the DataTables table body scrolling in the vertical direction. This can generally be seen as an alternative method to pagination for displaying a large table in a fairly small vertical area, and as such pagination has been disabled here (note that this is not mandatory, it will work just fine with pagination enabled as well!).

Name

Position

Office

Age

Start date

Salary

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Office

Age

Start date

Salary

Scroll - Vertical, Dynamic Height

This example shows a vertically scrolling DataTable that makes use of the CSS3 (vh) unit in order to dynamically resize the viewport based on the browser window height. The (vh) unit is effectively a percentage of the browser window height. So the (50vh) used in this example is 50% of the window height. The viewport size will update dynamically as the window is resized.

Name

Position

Office

Age

Start date

Salary

Tiger Nixon

System Architect

Edinburgh

61

2011/04/25

$320,800

Garrett Winters

Accountant

Tokyo

63

2011/07/25

$170,750

Ashton Cox

Junior Technical Author

San Francisco

66

2009/01/12

$86,000

Cedric Kelly

Senior Javascript Developer

Edinburgh

22

2012/03/29

$433,060

Airi Satou

Accountant

Tokyo

33

2008/11/28

$162,700

Brielle Williamson

Integration Specialist

New York

61

2012/12/02

$372,000

Herrod Chandler

Sales Assistant

San Francisco

59

2012/08/06

$137,500

Rhona Davidson

Integration Specialist

Tokyo

55

2010/10/14

$327,900

Colleen Hurst

Javascript Developer

San Francisco

39

2009/09/15

$205,500

Sonya Frost

Software Engineer

Edinburgh

23

2008/12/13

$103,600

Jena Gaines

Office Manager

London

30

2008/12/19

$90,560

Quinn Flynn

Support Lead

Edinburgh

22

2013/03/03

$342,000

Charde Marshall

Regional Director

San Francisco

36

2008/10/16

$470,600

Haley Kennedy

Senior Marketing Designer

London

43

2012/12/18

$313,500

Tatyana Fitzpatrick

Regional Director

London

19

2010/03/17

$385,750

Michael Silva

Marketing Designer

London

66

2012/11/27

$198,500

Paul Byrd

Chief Financial Officer (CFO)

New York

64

2010/06/09

$725,000

Gloria Little

Systems Administrator

New York

59

2009/04/10

$237,500

Bradley Greer

Software Engineer

London

41

2012/10/13

$132,000

Dai Rios

Personnel Lead

Edinburgh

35

2012/09/26

$217,500

Name

Position

Office

Age

Start date

Salary

Language - Comma Decimal Place

A dot (.) is used to mark the decimal place in Javascript, however, many parts of the world use a comma (,) and other characters such as the Unicode decimal separator (⎖) or a dash (-) are often used to show the decimal place in a displayed number.