Project

General

Profile

Plugins Directory » Custom Field Sql

 Author: Alexey Smirnov
Website: https://github.com/apsmir/custom_field_sql
Code repository: https://github.com/apsmir/custom_field_sql
Registered on: 2020-12-29 (over 5 years ago)
Current version: 2.9
Compatible with: Redmine 5.1.x, 5.0.x
User ratings:   (5)

This plugin adds "sql" and "sql_search" format for custom fields

sql format: you can use parameters for sql expression. id => id of the customized object

sql_search format: support multiply forms parameters. Parameters must be written in jquery

Atom

Changelog

2.9 (2026-05-15)

Compatible with Redmine 5.1.x, 5.0.x.

Add option - Multiple selection (multi_select)
-------------------------------------
sql_search supports multiple selection via the `multi_select` option.

1) Go to Administration -> Custom fields and edit/create a field with format Sql search.
2) Check the "Multiple selection" checkbox in the field settings.
3) When enabled, the field on the issue form shows:
- An autocomplete input to search and add values
- Selected values displayed as tags (chips) below the input
- A green "+" button (visible when `strict_selection` is disabled and no results found)
4) Tags can be removed by clicking the "×" icon on each tag.
5) Values are stored as a JSON array (e.g. `["val1","val2","val3"]`) in the database.
6) In the issue list, values are displayed as a comma-separated string.

3.jpg (10.5 KB) 3.jpg Alexey Smirnov, 2026-05-15 14:38

2.8 (2024-04-29)

Compatible with Redmine 5.1.x, 5.0.x.

2.6 (2022-09-19)

Compatible with Redmine 5.0.x, 4.0.x, 3.4.x.

  • Added strict error message and max-height for sql_search field
  • Disable sql custom fields for bulk edit

2.1 (2021-04-19)

Compatible with Redmine 5.0.x, 4.2.x, 4.1.x, 4.0.x, 3.4.x.

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

2.0 (2021-04-05)

Compatible with Redmine 5.0.x, 4.2.x, 4.1.x, 4.0.x, 3.4.x.

add support sql_search custom field

2.png (8.19 KB) 2.png Alexey Smirnov, 2021-04-04 23:43

1.0 (2020-12-28)

Compatible with Redmine 5.0.x, 4.2.x, 4.1.x, 4.0.x, 3.4.x.

image_1.png (10.1 KB) image_1.png Alexey Smirnov, 2020-12-29 15:39

User ratings

  by Jimmy Westberg over 1 year ago

Got it working under 6.0.1 but had to fix the problem with the custom_sql_search_controller.rb file

  by mo xun over 3 years ago

very good

  by Artur Nigmatullin over 3 years ago

Thanks, great plugin! But unfortunately there is an error at bulk edit. Is a fix planned?

  by Dileep Kumar over 5 years ago

I liked this plugin. It is very useful.
can we write queries with conditions like
"select description from projects where id=self.id"

  by Krzysztof Irzyk over 5 years ago

I looks plugin with field with list of issues (subject of issues). For me plugin very useful.