Project

General

Profile

Actions
Copy link

task #6020

closed

Consider replacing custom field 'keywords' by redmine_tags

Added by Andreas Kohlbecker about 8 years ago. Updated almost 8 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Kohlbecker
Category:
devOps
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Tags:
redmine

Description

custom issue fields cannot be edited via the bulk edit function.
Maybe the redmine_tags plugin provides better functionality

HowTo migrate the keywords to tags

To get an overview on the keywords

select c.value, count( c.value) as cnt from custom_values c where c.custom_field_id=8   group by c.value order by cnt DESC

==> some keywords are not split into single tokens, they are still concatenated by ',' characters. TODO split the keywords into tokens.

The plugin brings two new tables:

  • tags - the tag text and count of the tags in use
  • taggings - relations between the tag and the issue, wiki, etc

I should be quite easy to write an sql statement or procedure to perform a migration

Files

Download all files
split-kdata.awk (1.46 KB) split-kdata.awk Andreas Kohlbecker, 09/20/2016 06:35 PM
migrate-keywords-to-tags.sh (642 Bytes) migrate-keywords-to-tags.sh Andreas Kohlbecker, 09/20/2016 06:35 PM
Actions
Copy link

Also available in: Atom PDF