Differences

This shows you the differences between two versions of the page.

--- plugin:datatables [2020-06-14 23:41] – lotar
+++ plugin:datatables [2023-08-31 15:42] (current) – lotar
@@ Line 6: / Line 6: @@
 email      : giuseppe.diterlizzi@gmail.com
 type       : syntax, action
-lastupdate : 2020-06-14
+lastupdate : 2023-08-31
-compatible : Greebo, Frusterick Manners,Elenor of Tsort, Weatherwax, Hrun, Detritus, Hogfather
+compatible : Greebo, Frusterick Manners,Elenor of Tsort, Weatherwax, Hrun, Detritus, Hogfather, Igor, "Jack Jackrum"
 depends    :
-conflicts  : indexmenu
+conflicts  : indexmenu, tabinclude
 similar    :
 tags       : datatables, tables, jquery, filter
@@ Line 140: / Line 140: @@
 ===== FAQ =====
+  * I cannot get the buttons (csv,xls,pdf) to appear as documented: see: [[https://github.com/giterlizzi/dokuwiki-plugin-datatables/issues/54|discussion on GitHub]]
   * How to use with the [[CSV]] plugin: read the [[https://github.com/giterlizzi/dokuwiki-plugin-datatables/issues/21|discussion on GitHub]]((fast answer: [[Include]] + [[CSV]] + DataTables)).
   * I would like sorting a column by date. dd/mm/yyyy doesn't work. The way I have found is mm.dd which is not obvious (for french people) and Year doesn't match in this format. I follow this [[http://datatables.net/forums/discussion/2467/need-help-for-sorting-date-with-dd-mm-yyyy-format|thread]] about but don't know if the feature is already implemented in [[plugin:datatables|Datatables]]. Thanks.  --- [[user>Digitalin|Digitalin]] //2016-02-08 13:16//
     * Information is sorted as text by default in Datatables. According to this [[https://datatables.net//forums/discussion/comment/78719/#Comment_78719|post]] and [[https://datatables.net/reference/option/columns.type|documentation]], the best format is yyyy/mm/dd and works well. In case, to get at once a new format with bash : ''sed -E 's,([0-9]{2})/([0-9]{2})/([0-9]{4}),\3\/\2\/\1,g' page.txt > page2.txt'' (to adapt to your situation)  --- [[user>Digitalin|Digitalin]] //2016-10-07 14:07//
   * It seems the tables default to a background color of white. Is there a way to change that? I tried modifying some values in the plugin css files but they are difficult to read and the changes seemed to have no effect.
+  * It would be nice if it was possible to state which column the sort should be applied to (as a default)
 ===== Discussion =====
@@ Line 172: / Line 174: @@
 but maybe the problem is on sql plugin...
+=== Possible answer: SQL links ===
+One possible answer to the above is to modify the SQL query so it outputs a link.
+  * To make a URL clickable (where the thing returned from sql is already a URL, in field "''url''"):
+<code>
+<sql>
+SELECT
+ CONCAT('<a href="',table.url,'" target=_blank">',table.url,'</a>') AS url,
+...
+FROM
+    table
+...
+</sql>
+</code>
+To make "''id''" in table "''table''" part of a clickable link:
+  * To put the id at the end of the link, e.g.: ''https://my.website.here/100''
+<code>
+<sql>
+SELECT
+ CONCAT('<a href="https://my.website.here/',table.id,'" target=_blank">',table.id,'</a>') AS id,
+...
+FROM
+    table
+...
+</sql>
+</code>
+  * To insert the field ''id'' somewhere in the link, e.g.: ''https://my.website.here/100/details''
+<code>
+<sql>
+SELECT
+    CONCAT('<a href="https://my.website.here/',table.id,'/details" target="_blank">',table.id,'</a>') AS id,
+...
+FROM
+    table
+...
+</sql>
+</code>
+And other variations on this, for example if you needed multiple fields to build the URL, that's possible too with ''CONCAT''.
+Obviously this hack is only useful if you're using datatables with the sql plugin. It also means you can't do "''SELECT *''" because you need to modify the correct field.
+I agree that auto-hyperlinks for URLs would be a neat feature. As an aside, the data in the PDF/CSV/Excel export buttons do not contain the URL link but the rendered output, which is probably what you want.
+  * Any information for Igor support?