Versions Compared

Key

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

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

Instructions

Follow the below steps:

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

    Code Block
    themeMidnight
    -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.

    Please refer to the below example where we have created/updated the Confluence page with Jira issues based on the JQL we enter.

    Code Block
    themeMidnight
    -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"


    Screenshot of the Confluence page:
    Image Modified


Info

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 the production environment.