Maintain list of static data as key-value pairs


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.


0 / 1


Download the zipped source from here.


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


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. Also, intval and floatval will contain the int/float equivalent if possible, ie 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
Maintainer: Martin Aspeli

Last modified 8 months ago Last modified on Nov 23, 2015, 11:24:38 AM