Server-Side CRUD operations

When a new Table row is added, removed or updated a request with CRUD data object is made via 'virtualDataSource' on the Server-Side Datasource. The server uses the SQL query sent by the Server-Side Datasource to get the rows which are then passed as the Pivot Table's data source and aggregated.

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.
+


SQL Query



Data