Redmine sql custom field

This plugin add two sql format for custom fields

• sql - format for simple sql-expression.
• sql_search - format for search sql query with form parameters

Compatibility

• Redmine 3.4.0 or higher

Installation

• Clone or download this repo into your redmine_root/plugins/ folder

$ git clone https://github.com/apsmir/custom_field_sql.git

• If you downloaded this repo, make sure to rename the extracted folder to custom_field_sql
• Restart Redmine

Usage

1. Visit Administration->Custom fields.
2. Press the button New custom field. Select format Sql or Sql search.
3. Enter sql query

SQL parameters

You can use parameters for sql expression. sql format: support %id% => id of the customized object. This may be id of issue or id of project

sql_search Query must have field 'value'. This field used be as field value. format: support multiply forms parameters. Parameters must be written in jquery.

---

Simple 1:

"sql expression":

select subject as value, description as label from issues where subject like ? and description like ?

"sql form params":

p0='%'+$('#issue_custom_field_values_31').val()+'%' p1='%'+$('#issue_custom_field_values_30').val()+'%'

---

Simple 2 (for MySQL):

"sql expression":

select subject as value from issues where id = if( ? ='new', id, ?);

"sql form params":

p0=window.location.toString().split('/').pop()

p1=window.location.toString().split('/').pop()

This expression window.location.toString().split('/').pop() calculate issue id on form. For new issues calculated value = 'new'.

---

Query in sql search field can be executed by mouse click. Use parametr "search by click" in settings page.

Scripts

view_customize/custom_field_autselect_first_value.js It is script for plugin "view customize" https://www.redmine.org/plugins/view_customize The script allows you to automatically select the first value for a custom field (drop-down list)

Uninstall

1. Delete all custom fields with format Sql.
2. Remove folder redmine_root/plugins/custom_field_sql
3. Restart Redmine