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 (7 months ago)
Current version: 2.1
Compatible with: Redmine 5.0.x, 4.2.x, 4.1.x, 4.0.x, 3.4.x
User ratings:   (2)

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.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) 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) Alexey Smirnov, 2020-12-29 15:39

User ratings

  by Dileep Kumar 6 months 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 7 months ago

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