Redmine Plugin: Wiki Lists ¶

• 目次
• Redmine Plugin: Wiki Lists
  • Downloads
  • Installation
• Usage
  • ref_issues
    • Syntax
    • example

日本語は こちら.

This plugin adds wiki macros that display ticket lists.

Downloads¶

bitbucket: https://bitbucket.org/tkusukawa/redmine_wiki_lists/downloads

Installation¶

1. Download zip file from bitbucket
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([options].., [column]..)}}

options:

• -s[=WORD[|WORD]..]
  select issues that contain WORDs in subject.

• -d[=WORD[|WORD]..]
  select issues that contain WORDs in description.

• -w[=WORD[|WORD]..]
  select issues that contain WORDs in subject or description.

• -p[=IDENTIFIRE]
  Specify the project by identifire.

• -i=CUSTOM_QUERY_ID
  Use custom query by id.

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

• -f:ATTRIBUTE[=WORD[|WORD...]]
  Additional filter. Attributes are shown below.

  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_*

You can specify two or more select option, it affect AND condition.
WORDs is one or more search words divided by '|', and multiple words affect OR condition.
If you specify no select condition, page name of wiki or number of issue is used for search word.

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

example¶

1. list up tickets that contain 'sorting' in subject
notation	{{ref_issues(-s=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 操作

2. list up tickets that contain 'sorting' in subject. and specify display column(subject,author,assigned_to,status)
notation	{{ref_issues(-s=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） 操作

3. list up tickets that contain 'sorting' in subject, and restrict by project=wiki_lists
notation	{{ref_issues(-p=wiki_lists,-s=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 操作

4. 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 操作

5. 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 操作

6. use custom query and restrict by usr_id=89
notation	{{ref_issues(-i=9,-f:assigned_to_id=89)}}
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 操作

7. display linked string that is results of custom query
notation	{{ref_issues(-i=9,-l)}}
results	filter by enum value of custom field: key value list want to use field reference of Issue in History part add [current_project_id] for value field can not use custom fields even when restrict the project ref_issues with custom fields not working use custom field to additional filter overwrite_sql_for_fieldをRedmine2.0に合わせる ref_issues: Query with custom field.

8. display linked string(=ticket id) that is results of custom query
notation	{{ref_issues(-i=9,-l=id)}}
results	1497 1482 1446 1443 1326 1248 1063 999