Data Table Stored Proc Results

Hi,
I have a stored proc that runs and return data for a data table.
The columns should be Date;Name; then each following column is time . So it looks something like this.

Date;Name;00:00; 00:15; 00:30; 00:45;01:00… this continues till 24:00.

How can i get the data table to automatically generate the columns in the correct order.

The reason for this is because the result being returned is a sql pivot result.

Hope you can help

DatatableautoConfig will initialize columns according to the order and names of attributes in data source: https://webix.com/snippet/e19ca555

In other cases, you need to configure columns by yourself.

But can you please clarify, will the date-name-time structure be static or columns have to change depending on the loaded dataset?

Hi.
Thank you. I Managed by configuring columns by myself.
All thou something of topic. How can i get the selected items in a list and send it to a servlet.

Kind Regards

datatable.getSelectedItem(true)

Will return seleced items as an array. Here’s also the description of the method.

Thank you, much appreciated.