The DataTable2 Extension is a brilliant concept and work RV1971. Your extension has been extremely helpful to me.
Column Ordering - Bug
I have discovered a bug in the data entry <datatable2> tag. After saving the page, the tag shows the content of columns in alphabetical order rather than numerical order. For example, column contents are displayed after saving a page as Column1, Column10, Column11, Column12 ... Column19, Column2, Column20, Column21 ... etc. Thus, this bug only becomes apparent when creating tables with more than 9 columns.
For example, the following code would demonstrate this:
<datatable2 table="column order test" class="wikitable" columns = "column1|column2|column3|column4|column5|column6|column7|column8|column9|column10|column11|column12|column13|column14|column15|column16|column17|column18|column19|column20|column21|column22"> <head> ! column1 ! column2 ! column3 ! column4 ! column5 ! column6 ! column7 ! column8 ! column9 ! column10 ! column11 ! column12 ! column13 ! column14 ! column15 ! column16 ! column17 ! column18 ! column19 ! column20 ! column21 ! column22 </head> field1|field2|field3|field4|field5|field6|field7|field8|field9|field10|field11|field12|field13|field14|field15|field16|field17|field18|field19|field20|field21|field22 </datatable2>
Fortunately, the <dt2-showtable> tag correctly displays columns as Column1, Column2 ... Column10, Column11, Column12 ... Column19, Column20, Column21 ... etc.
Field Separator - Feature Request No. 1
I have found that the DataTable2 Extension is intolerant of '|' (pipes) field separators with whitespace on either side. I have created a table which has more than twenty columns. Each row of my input data can be quite long and screen wrapping can be an issue. Due to 'human factors', it would be easier for humans to read and prepare the input data if whitespace was permitted on at least one side of the pipes. The difficulty of not accepting whitespace with pipes is also visible with the list of columns in the code example above.
Additional SQL Statements - Feature Request No. 2
I would like to be able to use the following SQL Statements such as:
- GROUP BY <- most important for me
- SELECT DISTINCT
- SELECT COUNT
- SELECT SUM
I do not think the Extension permits the use of these statements (or at least I do not know how to). Could these be added too please (or explained in Help Page)?