Plugins Directory » Redmine Custom tables
|
|
Author: | Ivan Marangoz |
|---|---|---|
| Website: | https://redmineplus.com/custom-tables/ | |
| Code repository: | https://redmineplus.com/custom-tables/ | |
| Registered on: | 2019-08-18 (almost 6 years ago) | |
| Current version: | 1.1.0 | |
| Compatible with: | Redmine 6.1.x, 6.0.x, 5.1.x, 5.0.x | |
| User ratings: |
This plugin enables you to create custom tables using Redmine custom fields. It allows you to build any type of database tailored to your business needs and integrate it seamlessly into your workflow. Try demo: https://redmineplus.com/sign-up-to-redmine-plus/
- Table constructor
- Filtering
- Sorting
- Grouping
- Integration with issues
- History of changes
- Commenting entities
- Export CSV/PDF
- API
- Visit Administration->Custom tables to open table constructor.
- Press button New table. Fill the name field, select projects you want to enable table on and submit the form.
- Add custom fields to your new table.
- 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_values":{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_values":{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.1.0 (2025-06-06)
Compatible with Redmine 6.1.x, 6.0.x, 5.1.x, 5.0.x.
- REDMINE 6 custom_tables plugin upgrade by @frywer in #50
- In Redmine 6, ActiveRecord::Base was replaced with ApplicationRecord, which is essential for ensuring plugin compatibility with the latest Redmine versions. Additionally, Redmine 6 introduces a new set of icons that may affect UI elements.
- This update also includes a fix for the user custom field dropdown, resolving issues with not showing users list in the dropdown
- That fix is compatible with Redmine 5 and Redmine 6
- add custom tables to the issue pdf export
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.
