Redmine Plugin: Wiki Lists

マクロ count の実行中にエラーが発生しました (Validation failed: Page はすでに存在します)

¶

• 目次
• • • This is the issue[#1389]'s description that explain 'ref_issues' wiki macro example.
• Redmine Plugin: Wiki Lists マクロ count の実行中にエラーが発生しました (Validation failed: Page はすでに存在します)
  • Links
  • Installation
• Usage
  • ref_issues
    • Syntax
    • example
  • history

日本語は こちら.

This plugin adds wiki macros that display ticket lists.

Links¶

redmine.org: http://www.redmine.org/plugins/redmine_wiki_lists
repository: https://github.com/tkusukawa/redmine_wiki_lists
downloads: https://github.com/tkusukawa/redmine_wiki_lists/releases

Installation¶

1. Download zip file from GitHub
2. Unzip
3. Move the unziped folder into the $REDMINE/plugins/
4. Restart REDMINE

Usage¶

ref_issues¶

ref_issues macro displays list of issues.

Syntax¶

{{ref_issues([option].., [column]..)}}

options:

superseded 表示隠す

• -i=CUSTOM_QUERY_ID
  Use custom query by id.

• -q=CUSTOM_QUERY_NAME
  Use custom query by query name.

• -f:ATTRIBUTE OPERATOR [VALUE[|VALUE...]]
  filter. Attributes are shown below.
  　
  [ATTRIBUTE]
  

  tracker_id,project_id,subject,description, 
  due_date,category_id,status_id,assigned_to_id,priority_id, 
  fixed_version_id,author_id,lock_version,created_on,updated_on, 
  start_date,done_ratio,estimated_hours,parent_id,root_id, 
  lft,rgt,is_private,closed_on, cf_*
  

  
  [OPERATOR]
  

  =:is, !:is not, o:open, c:closed, !*:none,
  *:any, >=:>=, <=:<=, ><:between, >t+:in more than, 
  >w:this week, lw:last week, l2w:last 2 weeks, m:this month, lm:last month,
  y:this year, >t-:less than days ago, ~:contains, !~:doesn't contain, 
  =p:any issues in project, =!p:any issues not in project, !p:no issues in project, 
  

You can specify two or more select option, it affect AND condition.
If you use this macro in a Issue, you can use the field value of the issue as VALUE by writing to the following field(column) name in the [] (brackets).

• -l[=column]
  Put linked text.

• -t[=column]
  Put markup text.

• -c
  number of issues.

columns:
You can choose columns that you want to display.
If you do not specify the columns, same columns with customquery are displayed.

• project
• tracker
• parent
• status
• priority
• subject
• author
• assigned_to
• updated_on
• category
• fixed_version
• start_date
• due_date
• estimated_hours
• done_ratio
• created_on
• closed_on
• relations

example¶

1. use custom query by ID
notation	{{ref_issues(-i=9)}}
results	# ステータス 題名 担当者 更新日 1497 終了（Closed） filter by enum value of custom field: key value list Tomohisa Kusukawa 2021/04/18 08:35 操作 1482 終了（Closed） want to use field reference of Issue in History part Tomohisa Kusukawa 2021/04/18 08:34 操作 1446 終了（Closed） add [current_project_id] for value field Tomohisa Kusukawa 2017/07/29 09:51 操作 1443 終了（Closed） can not use custom fields even when restrict the project Tomohisa Kusukawa 2016/12/05 01:09 操作 1326 終了（Closed） ref_issues with custom fields not working Tomohisa Kusukawa 2015/07/19 19:29 操作 1248 終了（Closed） use custom field to additional filter Tomohisa Kusukawa 2013/07/22 00:26 操作 1063 終了（Closed） overwrite_sql_for_fieldをRedmine2.0に合わせる Tomohisa Kusukawa 2012/09/09 16:55 操作 999 終了（Closed） ref_issues: Query with custom field. Haru Iida 2012/10/20 10:17 操作

2. use custom query by name
notation	{{ref_issues(-q=MyCustomQuery1)}}
results	# ステータス 題名 担当者 更新日 1497 終了（Closed） filter by enum value of custom field: key value list Tomohisa Kusukawa 2021/04/18 08:35 操作 1482 終了（Closed） want to use field reference of Issue in History part Tomohisa Kusukawa 2021/04/18 08:34 操作 1446 終了（Closed） add [current_project_id] for value field Tomohisa Kusukawa 2017/07/29 09:51 操作 1443 終了（Closed） can not use custom fields even when restrict the project Tomohisa Kusukawa 2016/12/05 01:09 操作 1326 終了（Closed） ref_issues with custom fields not working Tomohisa Kusukawa 2015/07/19 19:29 操作 1248 終了（Closed） use custom field to additional filter Tomohisa Kusukawa 2013/07/22 00:26 操作 1063 終了（Closed） overwrite_sql_for_fieldをRedmine2.0に合わせる Tomohisa Kusukawa 2012/09/09 16:55 操作 999 終了（Closed） ref_issues: Query with custom field. Haru Iida 2012/10/20 10:17 操作

3. list up issues that contain 'sorting' in subject
notation	{{ref_issues(-f:subject ~ sorting)}}
results	# プロジェクト トラッカー ステータス 優先度 題名 担当者 更新日 対象バージョン 進捗率 1235 Wiki Lists Defect 終了（Closed） 通常（Normal） Sorting of table of trackers is not compliant with custom query Tomohisa Kusukawa 2013/06/05 17:36 0.0.2 操作 1045 Wiki Extensions Defect 終了（Closed） 通常（Normal） Table sorting does not work. Haru Iida 2012/10/20 15:13 Wiki Extensions - 0.6.0 操作 779 Wiki Extensions Defect 却下（Invalid） 通常（Normal） Problems with table sorting with redmine wiki extensions Haru Iida 2011/06/14 00:10 Wiki Extensions - 0.3.5 操作

4. list up issues that contain 'sorting' in subject. and specify display column(subject,author,assigned_to,status)
notation	{{ref_issues(-f:subject ~ sorting, subject, author, assigned_to, status)}}
results	# 題名 作成者 担当者 ステータス 1235 Sorting of table of trackers is not compliant with custom query vincent auroch Tomohisa Kusukawa 終了（Closed） 操作 1045 Table sorting does not work. Haru Iida Haru Iida 終了（Closed） 操作 779 Problems with table sorting with redmine wiki extensions Haru Iida Haru Iida 却下（Invalid） 操作

5. list up tickets that contain 'sorting' in subject, and restrict by project=Wiki Lists
notation	{{ref_issues(-f:subject ~ sorting, -f:project = Wiki Lists)}}
results	# プロジェクト トラッカー ステータス 優先度 題名 担当者 更新日 対象バージョン 進捗率 1235 Wiki Lists Defect 終了（Closed） 通常（Normal） Sorting of table of trackers is not compliant with custom query Tomohisa Kusukawa 2013/06/05 17:36 0.0.2 操作

6. pickup issues that have subject=Sample, and put linked ID
notation	{{ref_issues(-f:subject = Sample, -l=id)}}
results	1389

7. pickup issues that have subject=Sample, and put markuped description
notation	{{ref_issues(-f:subject = Sample, -t=description)}}
results	This is the issue[#1389]'s description that explain 'ref_issues' wiki macro example.¶ refer issue's field value notation {{ref_issues(-f:issue_id = 1389, -t = cf_2 )}} results SampleY use field value for filter condition notation {{ref_issues(-f:subject = [cf_2])}} results # プロジェクト トラッカー ステータス 優先度 題名 担当者 更新日 対象バージョン 進捗率 1444 Wiki Lists Feature 解決（Resolved） 通常（Normal） SampleY 2016/12/07 07:36 操作

8. put number of issues that contain 'sorting' in subject
notation	{{ref_issues(-f:subject ~ sorting, -c)}}
results	3

history¶

→ Roadmap