Version 1 (modified by optilude, 6 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 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 16:17:02
Initial checkin - mostly working.
[4676] by optilude on 2008-10-30 16:15:30
Make trunk
[4675] by optilude on 2008-10-30 16:14:49
New hack SqlConstantsPlugin, created by optilude


Author: optilude