Plugins Directory » Redmine Custom tables
|
|
Author: | Ivan Marangoz |
|---|---|---|
| Website: | https://github.com/frywer/custom_tables | |
| Code repository: | https://github.com/frywer/custom_tables | |
| Registered on: | 2019-08-18 (over 5 years ago) | |
| Current version: | 1.0.6 | |
| Compatible with: | Redmine 4.2.x, 4.1.x, 4.0.x, 3.4.x | |
| User ratings: |
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.
- 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.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.
