Skip to end of banner
Go to start of banner

How to present Jira issues in table format in Confluence using data from JIRA

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Current »

This article explains how to present Jira issues in a table format in Confluence using Confluence Command Line Interface (CLI) and Jira Command Line Interface (CLI).

Instructions

Follow the below steps:

  1. Use getIssueList to list issues for a JQL query with storePage to create or update a Confluence page.

    -a run -i "myjira -a getIssueList --jql project=project_key --columns 1,2,3,4 --outputType html -f @temp" -i "myconf -a storePage --replace --space space_key --title title_name  --parent @home --noConvert -f @temp"
    
    


    --jql  input the JQL query which you want to display the list on the confluence page.
    --columns specify the column names you want to display.
    --outputType specify the output format type. Valid values are: text, table, HTML, JSON, variables.
    --space enters the space key.

    Refer to the below example where a Confluence page is created with Jira issues based on the JQL used.

    -a run -i "myjira -a getIssueList --jql project=TESTMKJMWE --columns 1,2,3,4 --outputType html -f @temp" -i "myconf -a storePage --replace --space SPAC --title SPAC  --parent @home --noConvert -f @temp"


    Resultant Confluence page:


It is recommended to test this scenario in a non-production environment, or run the action with the --simulate parameter, to verify the behavior before deploying in a production environment.

  • No labels