plugin:datatables
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
plugin:datatables [2018-11-25 12:31] – "asc" => ascending, "desc" => descending Stefanobasta | plugin:datatables [2024-04-21 09:58] (current) – 2001:1c04:2a92:5f00:4a0f:68f2:3f0c:20c6 | ||
---|---|---|---|
Line 5: | Line 5: | ||
author | author | ||
email : giuseppe.diterlizzi@gmail.com | email : giuseppe.diterlizzi@gmail.com | ||
- | type : syntax, | + | type : syntax, action |
- | lastupdate : 2016-03-14 | + | lastupdate : 2023-08-31 |
- | compatible : Greebo, | + | compatible : Kaos, Greebo, Frusterick Manners, |
depends | depends | ||
- | conflicts | + | conflicts |
similar | similar | ||
- | tags : datatables, tables, jquery | + | tags : datatables, tables, jquery, filter |
- | downloadurl: | + | downloadurl: |
- | bugtracker : https:// | + | bugtracker : https:// |
- | sourcerepo : https:// | + | sourcerepo : https:// |
donationurl: | donationurl: | ||
Line 26: | Line 26: | ||
Search and install the plugin using the [[plugin: | Search and install the plugin using the [[plugin: | ||
+ | |||
+ | :!: **Note for Hogfather users** \\ | ||
+ | Hogfather use the JS " | ||
===== Examples/ | ===== Examples/ | ||
Line 137: | Line 140: | ||
===== FAQ ===== | ===== FAQ ===== | ||
+ | * I cannot get the buttons (csv, | ||
+ | * How to use with the [[CSV]] plugin: read the [[https:// | ||
* I would like sorting a column by date. dd/mm/yyyy doesn' | * I would like sorting a column by date. dd/mm/yyyy doesn' | ||
* Information is sorted as text by default in Datatables. According to this [[https:// | * Information is sorted as text by default in Datatables. According to this [[https:// | ||
- | * 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 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 ===== | ===== Discussion ===== | ||
+ | |||
This plugin looks like the answer to my dreams!:-) | This plugin looks like the answer to my dreams!:-) | ||
Line 148: | Line 156: | ||
Also, are the table editing functions of DataTables available? | Also, are the table editing functions of DataTables available? | ||
+ | |||
+ | ==== Suggestion: autolink ==== | ||
+ | This is quite a very nice & practical plugin, that you may use in conjunction with [[plugin: | ||
+ | |||
+ | < | ||
+ | < | ||
+ | < | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | Only a little suggestion if you use it with sql plugin: wouldn' | ||
+ | |||
+ | < | ||
+ | https:// | ||
+ | <a href=" | ||
+ | </ | ||
+ | |||
+ | 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 "'' | ||
+ | |||
+ | < | ||
+ | <sql> | ||
+ | SELECT | ||
+ | | ||
+ | ... | ||
+ | FROM | ||
+ | table | ||
+ | ... | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | To make "'' | ||
+ | |||
+ | * To put the id at the end of the link, e.g.: '' | ||
+ | |||
+ | < | ||
+ | <sql> | ||
+ | SELECT | ||
+ | | ||
+ | ... | ||
+ | FROM | ||
+ | table | ||
+ | ... | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | * To insert the field '' | ||
+ | |||
+ | < | ||
+ | <sql> | ||
+ | SELECT | ||
+ | CONCAT('< | ||
+ | ... | ||
+ | FROM | ||
+ | table | ||
+ | ... | ||
+ | </ | ||
+ | </ | ||
+ | |||
+ | And other variations on this, for example if you needed multiple fields to build the URL, that's possible too with '' | ||
+ | |||
+ | Obviously this hack is only useful if you're using datatables with the sql plugin. It also means you can't do "'' | ||
+ | |||
+ | I agree that auto-hyperlinks for URLs would be a neat feature. As an aside, the data in the PDF/ | ||
+ | |||
+ | |||
+ | * Any information for Igor support? | ||
plugin/datatables.1543145481.txt.gz · Last modified: 2018-11-25 12:31 by Stefanobasta