Hi,

- is it possible to add extra column into table that comes from MySQL? ( I need to add print icon on the end of the row))

- can I use DataTables on tables generated "on the fly"?

Best regards, Tomasz.

Hello,

1. It is possible to add an extra column to "SELECT" SQL query and then format it with help of "Columns settings -> Format" parameter. For example use the following query:

SELECT id, 1 AS print FROM tel

Set "Column settings -> ID" to print and populate "Columns settings -> Format" with appropriate formatting rule. For example:

<b>Print</b>

2. Could you explain in more details what you mean under "tables generated on the fly"? The extension can show data from a database based on "SELECT" SQL query.

Regards,
ARI Soft

Query will be generated basing on the HTML form after selecting the appropriate
fields.

Then I would like to show table formated as DataTable.

It is possible to use request variables in "WHERE" clauses of SQL query, but the extension doesn't support ability to change SQL query dynamically.

Regards,
ARI Soft