Plugins Directory » Redmine Custom tables

25431 Author: Ivan Marangoz
Website: https://github.com/frywer/custom_tables
Code repository: https://github.com/frywer/custom_tables
Registered on: 2019-08-18 (10 months ago)
Current version: 1.0.6
Compatible with: Redmine 4.2.x, 4.1.x, 4.0.x, 3.4.x
User ratings:   (9)

This plugin provides a possibility to create custom tables. The table is built with Redmine custom fields. It allows you to create any databases you need for your business and integrate it into your workflow processes.

Online demo
login: admin
password: admin

Features
  • Table constructor
  • Filtering
  • Sorting
  • Grouping
  • Integration with issues
  • History of changes
  • Commenting entities
  • Export CSV/PDF
  • API
Usage
  1. Visit Administration->Custom tables to open table constructor.
  2. Press button New table. Fill the name field, select projects you want to enable table on and submit the form.
  3. Add custom fields to your new table.
  4. Give access to the user's Administration -> Roles and permissions -> Project -> Manage custom tables

API
Make sure the External Name field is filled out in Custom fields.

Custom field external names then become keys in the JSON object

examples:

Make sure you change example variables to real values: CUSTOM-TABLE-ID, REDMINE-API-KEY, CUSTOM-ENTITY-ID, ISSUE-ID.

[GET INDEX]- List all objects from the table:

curl -X GET -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY"  "https://redmine-app.com/custom_tables/CUSTOM-TABLE-ID.json" 

[GET INDEX]- List all objects from the table related to the issue:

curl -X GET -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY"  -d '{"issue_id": "=ISSUE-ID"}' "https://redmine-app.com/custom_tables/CUSTOM-TABLE-ID.json" 

[GET OBJECT] - Get the object information:

curl -X GET -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY"  "https://redmine-app.com/custom_entities/CUSTOM-ENTITY-ID.json" 

[POST CREATE] - Add object to the table with issue

curl -X POST -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY" -d '{"custom_entity": {"custom_table_id":CUSTOM-TABLE-ID, "issue_id":ISSUE-ID, "external_names":{JSON-PARMETERS}}}' "https://redmine-app.com/custom_entities.json" 

[POST CREATE] - Add object to the table without issue

curl -X POST -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY" -d '{"custom_entity": {"custom_table_id":CUSTOM-TABLE-ID, "external_names":{JSON-PARMETERS}}}' "https://redmine-app.com/custom_entities.json" 

[PUT UPDATE] - Update object

curl -X PUT -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY" -d '{"custom_entity": {"external_values":{JSON-PARMETERS}}}' "https://redmine-app.com/custom_entities/CUSTOM-ENTITY-ID.json" 

[DELETE] - Remove object from the table

curl -X DELETE -H "Content-Type: application/json" -H "X-Redmine-API-Key: REDMINE-API-KEY"  "https://redmine-app.com/custom_entities/CUSTOM-ENTITY-ID.json" 

Installation notes

  • Unarchive plugin to folder redmine/plugins
  • run bundle exec rake redmine:plugins:migrate RAILS_ENV=production

Changelog

1.0.6 (2020-05-18)

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

1.0.5 (2020-05-16)

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

  • New permission 'View custom tables' (read only permission)
  • API (GET/POST/PUT/DELETE) on custom tables

1.0.4 (2020-01-24)

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

  • Add user custom field
  • Fix dialog view

1.0.3 (2019-09-16)

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

Fix problem with plugin installation (LoadError: cannot load such file -- rspec/core/rake_task)

1.0.2 (2019-08-22)

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

  • Fixed visibility of date custom field in table

1.0.1 (2019-08-21)

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

  • Custom table description
  • Setting trackers assign
  • Setting roles assign

1.0.0 (2019-08-18)

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

1566136389121.jpg (181 KB) Ivan Marangoz, 2019-08-18 17:10

DeepinScreenshot_select-area_20200516130602.png (22.9 KB) Ivan Marangoz, 2020-05-16 14:30

DeepinScreenshot_select-area_20200516131225.png (66.8 KB) Ivan Marangoz, 2020-05-16 14:32

User ratings

  by Constantin Grosu 1 day ago

  by Kamil AFACAN 1 day ago

This plugin gives you flexibility. I Think the limit is your mind. Permissions and roles is not so clear (Not so important). Logs : There is no log for the records and the actions in this table.

  by Jaebok Oh 10 days ago

Greate!!

  by Farrukh Mamadziyoev 2 months ago

  by Alexander Alexander 3 months ago

Super! Can you adapt the plugin to 3.4 redmine version ?

  by Marcello Sannai 3 months ago

wonderful! it would be perfect if you could create the table directly from the new issue. when you open a new issue you can add fields to the table.
/projects/test/issues/new

  by Anand Ram 9 months ago

Great Plugin. But I am having issue with installing it for both 3.4 & 4.0..
rake aborted!
LoadError: cannot load such file -- rspec/core/rake_task
C:/Bitnami/redmine-4.0.4-3/apps/redmine/htdocs/plugins/custom_tables/lib/tasks/redmine.rake:1:in `requi

  by Sanjay Jain 9 months ago

Great work... It would be nice to allow some tables to be viewable by anonymous users. I wasn't seeing that as an option.

  by dominik ch 9 months ago

Great work :)
I think tables should behave like custom fields, now You can't assign table to tracker or status like custom field. Table sticks to everything in project
Also empty tables should be minimized, now they take way to much space :/