Server-side Table Tree mode

Table in this example is used in Tree mode. That is achieved by setting the dataSource's 'keyDataField' and 'parentDataField' properties. When a row is expanded the Table sends a request with the expanded row data object on the Server-Side Datasource. The server uses the SQL query sent by the Server-Side Datasource and returns the requested sub-rows collection. This example uses a demo server with AlaSQL that generates SQL to show how a real server might use the requests sent by the Table. The Server-Side Table usage does not have any restrictions on the server-side technologies used.

First Name	Last Name	Birth Date	Notes

Andrew	Fuller	Tue Feb 19 1952 00:00:00 GMT+0000 (Coordinated Universal Time)	Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.

First Name

Last Name

Birth Date

Notes

Andrew

Fuller

Tue Feb 19 1952 00:00:00 GMT+0000 (Coordinated Universal Time)

Andrew received his BTS commercial and a Ph.D. in international marketing from the University of Dallas. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.

Server-side Table Tree mode

SQL Query