Patch to bug report 3727
- Status
- Closed
- Subject
- Patch to bug report 3727
- Version
- 6.x
- Category
- Usability
- Patch
- Feature
- Wiki Plugin (extends basic syntax)
- Resolution status
- Fixed or Solved
- Submitted by
- Steve
- Lastmod by
- Ushindi Gedeon
- Rating
- Related-to
- Description
The attached file updates the SQL wiki plugin so that the user has a choice whether the returned data should be Wiki parsed or not instead of just preventing it. Parsing is the default with "noparse=>1" preventing the parsing. There are also two additional features added to the code:
- "raw=>1" will eliminate any headers or formatting.
- "delim=>'|'" will set the data delimiter for columns to being an "or" bar. Any other separator can be used.
These additional features are useful when selecting summary data like "count(*)" and resultant headers are unwanted or when selecting data normally, but wanting to format the output aside from the standard SQL return.There is a remaining issue with the submitted patch. While I have updated the help array at the top I don't know how to make the new parameters reflected in the GUI help system as seen by the user when accessing the plugin through the help system.
I will update the SQL plugin documentation on the Tiki site if this patch is accepted. Doing so before-hand will only set false expectations for functionality not yet there.
--Steve
- Files
- Solution
- Workaround
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 3741
- Created
- Wednesday 12 January, 2011 15:57:15 UTC
by Steve - LastModif
- Tuesday 30 June, 2026 14:23:39 UTC