Project

General

Profile

Actions

Redmine Plugin: Wiki Lists

日本語は こちら.

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

  • -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
2. use custom query by name
notation {{ref_issues(-q=MyCustomQuery1)}}
results
3. list up issues that contain 'sorting' in subject
notation {{ref_issues(-f:subject ~ sorting)}}
results
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
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
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
1502 Work Time Defect 解決(Resolved) 通常(Normal) redmine work time plugin fails Tomohisa Kusukawa 10/03/2019 03:13 PM Work Time - 0.4.0

Actions
1501 r-labs Defect 終了(Closed) 通常(Normal) redmine work time plugin fails 06/23/2019 06:19 PM

Actions
1499 Work Time Support 新規(New) 通常(Normal) support Redmine4.0 (Rails5) Tomohisa Kusukawa 12/10/2018 12:03 AM Work Time - 0.4.0

Actions
1497 Wiki Lists Feature 解決(Resolved) 通常(Normal) filter by enum value of custom field: key value list Tomohisa Kusukawa 10/28/2018 10:54 PM 0.0.10

Actions
1482 Wiki Lists Feature 解決(Resolved) 通常(Normal) want to use field reference of Issue in History part Tomohisa Kusukawa 07/29/2017 11:02 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 07/23/2017 05:47 PM 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

history

Roadmap

Updated by Tomohisa Kusukawa about 1 year ago · 16 revisions