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 4 years ago)
Current version: 2.8
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.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 7 months 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 2 years ago

very good

  by Artur Nigmatullin almost 3 years ago

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

  by Dileep Kumar over 4 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 4 years ago

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