Patch to bug report 3727
- Status
- Open
- Subject
- Patch to bug report 3727
- Version
- 6.x
- Category
- Usability
- Patch
- Feature
- Wiki Plugin (extends basic syntax)
- Resolution status
- New
- Submitted by
- Steve
- Lastmod by
- Steve
- 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
- Priority
- 25
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tikiwiki.org
Please demonstrate your bug on show2.tikiwiki.org
Version: Create show2.tikiwiki.org instanceAbout show2.tikiwiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tikiwiki.org instance. To start, simply select a version and click on "Create show2.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tikiwiki.org.
- Ticket ID
- 3741
- Created
- Wednesday 12 January, 2011 15:57:15 GMT-0000
by Steve - LastModif
- Wednesday 12 January, 2011 15:57:15 GMT-0000
;){kind=link}
;){kind=link}
;){kind=link}
;){kind=link}