Redmine Plugin: Wiki Lists ¶

• Table of contents
• • • This is the issue[#1389]'s description that explain 'ref_issues' wiki macro example.
• Redmine Plugin: Wiki Lists
  • Links
  • Installation
• <Usage> ref_issues
  • Syntax {{ref_issues([option].., [column]..)}}
    • option
    • column
  • 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]..)}}¶

option¶

superseded ShowHide

• -i=CUSTOM_QUERY_ID
  Use custom query by id.

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

• -0
  Do not display the table If query result is 0.

• f:<ATTRIBUTE>␣<OPERATOR>␣<[VALUE[|VALUE...]]>
  filter. Attributes are shown below.
  e.x. {{ref_issues(-f:tracker_id = 3)}}
  　
  [ATTRIBUTE]
  

  issue_id,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_*,
  
  tracker,category,status,assigned_to,version,project, 
  treated, author
  　
  

  
  [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).
  > Besides [<column>], You can use [id], [current_project_id], [current_user], [current_user_id], [<number> days_ago] .
  　
• -l[=column]
  Put linked text.
  　
• -t[=column]
  Put markup text.
  　
• -c
  number of issues.

column¶

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	# Status Subject Assignee Updated 1497 終了（Closed） filter by enum value of custom field: key value list Tomohisa Kusukawa 04/18/2021 08:35 AM Actions 1482 終了（Closed） want to use field reference of Issue in History part Tomohisa Kusukawa 04/18/2021 08:34 AM Actions 1446 終了（Closed） add [current_project_id] for value field Tomohisa Kusukawa 07/29/2017 09:51 AM Actions 1443 終了（Closed） can not use custom fields even when restrict the project Tomohisa Kusukawa 12/05/2016 01:09 AM Actions 1326 終了（Closed） ref_issues with custom fields not working Tomohisa Kusukawa 07/19/2015 07:29 PM Actions 1248 終了（Closed） use custom field to additional filter Tomohisa Kusukawa 07/22/2013 12:26 AM Actions 1063 終了（Closed） overwrite_sql_for_fieldをRedmine2.0に合わせる Tomohisa Kusukawa 09/09/2012 04:55 PM Actions 999 終了（Closed） ref_issues: Query with custom field. Haru Iida 10/20/2012 10:17 AM Actions

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

3. list up issues that contain 'sorting' in subject
notation	{{ref_issues(-f:subject ~ sorting)}}
results	# Project Tracker Status Priority Subject Assignee Updated Target version % Done 1235 Wiki Lists Defect 終了（Closed） 通常（Normal） Sorting of table of trackers is not compliant with custom query Tomohisa Kusukawa 06/05/2013 05:36 PM 0.0.2 Actions 1045 Wiki Extensions Defect 終了（Closed） 通常（Normal） Table sorting does not work. Haru Iida 10/20/2012 03:13 PM Wiki Extensions - 0.6.0 Actions 779 Wiki Extensions Defect 却下（Invalid） 通常（Normal） Problems with table sorting with redmine wiki extensions Haru Iida 06/14/2011 12:10 AM Wiki Extensions - 0.3.5 Actions

4. list up issues that author_id is 89(kusu) and status is not 'closed'. specify display column(project,subject,author,assigned_to,status)
notation	{{ref_issues(-f:author_id = 89, -f:status ! 終了（Closed）, project, subject, author, assigned_to, status)}}
results	# Project Subject Author Assignee Status 1514 Work Time CKEditorプラグイン利用時にMemoの整形が機能しない Tomohisa Kusukawa Tomohisa Kusukawa 解決（Resolved） Actions 1513 Work Time エンターキーでSubmitしないようにしたい Tomohisa Kusukawa Tomohisa Kusukawa 解決（Resolved） Actions 1512 Wiki Lists 日本語の説明Wikiでエラー Tomohisa Kusukawa Tomohisa Kusukawa 解決（Resolved） Actions 1444 Wiki Lists SampleY Tomohisa Kusukawa 解決（Resolved） Actions 1430 Work Time 今更ですが埋め込みStyleの見直し Tomohisa Kusukawa Tomohisa Kusukawa 新規（New） Actions 1427 Work Time 開始日が入っていない期限切れ担当チケットを表示するようにしたい Tomohisa Kusukawa Tomohisa Kusukawa 新規（New） Actions 1389 Wiki Lists Sample Tomohisa Kusukawa Tomohisa Kusukawa 解決（Resolved） Actions 1374 Work Time 工数付け替えのAjaxの高速化 Tomohisa Kusukawa Tomohisa Kusukawa 新規（New） Actions 1346 Work Time anchor not work correct on Firefox Tomohisa Kusukawa Tomohisa Kusukawa 担当（Assigned） Actions

5. list up tickets that tracker is Support(3) or Question(6), and restrict by project=Wiki Lists
notation	{{ref_issues(-f:tracker == Question | Support, -f:project = Wiki Lists)}}
results	# Project Tracker Status Priority Subject Assignee Updated Target version % Done 1436 Wiki Lists Question 終了（Closed） 通常（Normal） How to specify current project but not to specify id or name. Toru Takahashi 10/10/2016 12:27 PM Actions 1432 Wiki Lists Support 新規（New） 通常（Normal） How can I use the plugin to sort the issues by some attribute? Steven Wong 09/23/2016 03:31 PM Actions 1431 Wiki Lists Support 終了（Closed） 通常（Normal） How can I use the plugin when I need to picked out the bug and new feature Steven Wong 10/10/2016 12:32 PM Actions 1399 Wiki Lists Question 終了（Closed） 通常（Normal） Option to bring only the number of lines Adriano Ceccarelli 03/22/2016 02:34 AM 0.0.7 Actions 1371 Wiki Lists Question 終了（Closed） 通常（Normal） IDを調べる良い方法はありますか？ Tatsuya Hisaki 05/20/2015 10:44 PM Actions 1370 Wiki Lists Question 終了（Closed） 通常（Normal） assigned_to_id が 「なし」のチケット一覧を表示するにはどうしたら良い？ Tatsuya Hisaki 07/21/2015 11:09 AM Actions 1358 Wiki Lists Question 終了（Closed） 通常（Normal） It shows error when I use "fixed_version_id" ? Tomohisa Kusukawa 04/19/2015 09:33 PM 0.0.5 Actions

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 # Project Tracker Status Priority Subject Assignee Updated Target version % Done 1444 Wiki Lists Feature 解決（Resolved） 通常（Normal） SampleY 12/07/2016 07:36 AM Actions

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

9-1. filter by issue_id (between)
notation	{{ref_issues(-f:issue_id >< 1389|1391)}}
results	# Project Tracker Status Priority Subject Assignee Updated Target version % Done 1391 Wiki Lists Defect 終了（Closed） 急いで（Urgent） Error Ismael Morales 12/05/2016 11:38 PM Actions 1390 r-labs Defect 新規（New） 通常（Normal） Testlink Plugin Issue 09/03/2015 05:34 PM Actions 1389 Wiki Lists Feature 解決（Resolved） 通常（Normal） Sample Tomohisa Kusukawa 01/08/2017 02:30 AM Actions

9-2. filter by issue_id (or)
notation	{{ref_issues(-f:issue_id == 1389|1391)}}
results	# Project Tracker Status Priority Subject Assignee Updated Target version % Done 1391 Wiki Lists Defect 終了（Closed） 急いで（Urgent） Error Ismael Morales 12/05/2016 11:38 PM Actions 1389 Wiki Lists Feature 解決（Resolved） 通常（Normal） Sample Tomohisa Kusukawa 01/08/2017 02:30 AM Actions

10. Do not display the table If query result is 0.
notation	{{ref_issues(-0,-f:subject = Sample2)}}
results

11. OR condition by name
notation	{{ref_issues(-f:category == sample|error, subject, category)}}
results	# Subject Category 1516 Fixed version-name of ticket/issue can not be shown with -t or -l option error Actions 1391 Error error Actions 1389 Sample sample Actions

12. created or updated by user kusu from 2017-05-01 to yesterday
notation	{{ref_issues(-f:treated kusu 2017-05-01|[1days_ago])}}
results	# Project Tracker Status Priority Subject Assignee Updated Target version % Done 1514 Work Time Defect 解決（Resolved） 通常（Normal） CKEditorプラグイン利用時にMemoの整形が機能しない Tomohisa Kusukawa 12/12/2021 06:10 PM Actions 1513 Work Time Feature 解決（Resolved） 通常（Normal） エンターキーでSubmitしないようにしたい Tomohisa Kusukawa 12/26/2021 04:50 PM Actions 1512 Wiki Lists Defect 解決（Resolved） 通常（Normal） 日本語の説明Wikiでエラー Tomohisa Kusukawa 04/18/2021 12:00 PM 0.0.11 Actions 1511 Wiki Lists Defect 終了（Closed） 通常（Normal） Ruby2.7でエラーになる Tomohisa Kusukawa 04/18/2021 08:33 AM 0.0.10 Actions 1507 Work Time Defect 解決（Resolved） 高め（High） Work Time cannot be saved with Redmine-trunk(r19944) Tomohisa Kusukawa 11/03/2020 11:05 AM Work Time - 0.4.1 Actions 1504 Work Time Defect 新規（New） 通常（Normal） 日毎工数入力時、工数の書き込みに失敗しても、メモは追記される Tomohisa Kusukawa 08/05/2020 09:10 AM Work Time - 0.4.0 Actions 1502 Work Time Defect 終了（Closed） 通常（Normal） redmine work time plugin fails Tomohisa Kusukawa 10/04/2020 05:24 PM Work Time - 0.4.1 Actions 1501 r-labs Defect 終了（Closed） 通常（Normal） redmine work time plugin fails 06/23/2019 06:19 PM Actions 1499 Work Time Support 終了（Closed） 通常（Normal） support Redmine4.0 (Rails5) Tomohisa Kusukawa 10/04/2020 05:25 PM Work Time - 0.4.0 Actions 1497 Wiki Lists Feature 終了（Closed） 通常（Normal） filter by enum value of custom field: key value list Tomohisa Kusukawa 04/18/2021 08:35 AM 0.0.10 Actions 1482 Wiki Lists Feature 終了（Closed） 通常（Normal） want to use field reference of Issue in History part Tomohisa Kusukawa 04/18/2021 08:34 AM 0.0.10 Actions 1477 Work Time Question 新規（New） 通常（Normal） チケットに関連づいてない作業時間の集計について 07/27/2017 12:28 AM Actions 1476 Wiki Lists Defect 終了（Closed） 高め（High） Mysql2::Error: Not unique table/alias: 'users' Tomohisa Kusukawa 11/24/2023 07:06 AM 0.0.9 Actions 1447 Wiki Lists Feature 終了（Closed） 通常（Normal） recognize login name by filter attribute 'treated' Tomohisa Kusukawa 07/29/2017 09:51 AM 0.0.8 Actions 1446 Wiki Lists Feature 終了（Closed） 通常（Normal） add [current_project_id] for value field Tomohisa Kusukawa 07/29/2017 09:51 AM 0.0.8 Actions 1428 Work Time Feature 終了（Closed） 通常（Normal） CKEditorプラグイン利用時にmemoが正しく読み書きできるようにしたい Tomohisa Kusukawa 08/27/2016 11:15 PM Work Time - 0.3.3 Actions 872 Work Time Defect 終了（Closed） 通常（Normal） 権限設定の項目順序変更 Tomohisa Kusukawa 11/26/2023 05:35 PM Work Time - 0.1.5 Actions

history¶

→ Roadmap