Version 1 (modified by Martin Aspeli, 9 years ago) (diff)

New hack SqlConstantsPlugin, created by optilude

SQL Constants


This plugin adds a new administration control panel that can be used to manage constants (key/value pairs) stored in the database. These can then be used in report queries.

Bugs/Feature Requests

Existing bugs and feature requests for SqlConstantsPlugin are here.

If you have any issues, create a new ticket.


Download the zipped source from [download:sqlconstantsplugin here].


You can check out SqlConstantsPlugin from here using Subversion, or browse the source with Trac.


Simply install the plugin as normal, and add a table like this to the database:

	CREATE TABLE `constants` (
	  `constant` varchar(255) NOT NULL,
	  `stringval` varchar(255) DEFAULT NULL,
	  `intval` int(11) DEFAULT NULL,
	  `floatval` float DEFAULT NULL,
	  PRIMARY KEY (`constant`)

You can then use this in report queries. The stringval column will always be stored. intval and floatval will contain the int/float equivalent if possible (i.e. the input could be cast to an int).

Visit the administration panel to update constants.

Recent Changes

4677 by optilude on 2008-10-30 15:17:02
Initial checkin - mostly working.
4676 by optilude on 2008-10-30 15:15:30
Make trunk
4675 by optilude on 2008-10-30 15:14:49
New hack SqlConstantsPlugin, created by optilude


Author: optilude