Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Div
idProductTOC

On this page

Table of Contents
maxLevel1
excludeOn this page
typeflat
separatorpipe

Overview

This page demonstrates how to use the Table Plus macro, which is part of the Advanced Tables for Confluence add-on app, to enhance the JIRA Jira Issues macro. Simply insert a Table Plus macro onto your page, configure its parameters, and then insert a JIRA Jira macro inside of the Table Plus macro.

If you are on a version of the JIRA issues Jira Issues macro that no longer has sorting (latest Confluence release and OnDemand - see see CONF-30114), then this can be very helpful. The Table Plus macro can add sorting and other features to the JIRA Jira Issues macro including styling the table differently. The key to doing this successfully can sometimes be dependent on the Confluence release (or more specifically, the release of the plugin containing JIRA issues Jira Issues macro). The following example on this page is based on OnDemand.

Tip
titleLimitations

Currently, the JIRA issues macro limits the display to the first 20 issues. There does not appear to be an option to control this (sad) - see CONF-30116. Sorting is only done on the visible issues.

Macro

...

browser input

Select this

...

macro

Macro NamenameAdvanced Tables - Table Plus
Macro Syntaxsyntax{table-plus}

...

Parameters/

...

values

Row formatting > Header & Footer rows > Number of Header rows

Column settings > Formatting > Column type (1

2

3

4

5

6

7

8

9

10

11)

S

S

X

M

M

S

MS

S

F

F

SE


Info

...

Please note that the Column types parameter is required for sorting. It should contain a comma separated list of values for handling each column. 

...

Click Display Options from within the

...

Jira Issues macro

...

 to review and optionally customize the columns to display, and thus determine how to set the Table Plus macro's Column types parameter.


UseFor
String (S)String columns
Exclude this column from user selectable sorting (X)Exclude column from sorting. Example: use for type For example, using Type column as that sorts by key, which is confusing.
Hide the column (H)Hide columns you don't want to seehide.
Date (M)Date columns.
Numeric and float values (F)Columns with numeric or float values.

Screenshot

Image RemovedImage Added

Wiki

...

markup input

Code Block
languagetext
linenumberstrue
{table-plus:heading=2|columnTypes=S,S,X,M,M,MS,S,S,EF,F,S}
{jiraissues:url=[https://bobswift.atlassian.net/sr/jira.issueviews:searchrequest-rss/temp/SearchRequest.xml?jqlQuery=project+%3D+TBL+AND+fixVersion+%3D+%226.1.0%22+ORDER+BY+priority+DESC}
{table-plus}

...

Example result

Table plus
columnTypesS,S,X,M,M,MS,S,S,F,EF,S
heading2

Jira Legacy
serverSystem JIRA (bobswift.atlassian.net)
columnskey,summary,type,created,updated,due,assignee,reporter,priority,fixversions,story points,status,resolution
maximumIssues20
jqlQueryproject = TBL AND fixVersion = "6.1.0" ORDER BY priority DESC
serverId729d679a8382ec9d-302cabb6-339f3a29-958b8d72-015e107badcd95b9a5732a63

Other

...

examples

Visit our full list of product examples for additional inspiration!Image Removed