Use confluence page properties in "Jira Issue/Filter" macro

Andreas Eder

Hi,

is there a possibility to use Page properties as filter criteria in "Jira Issue/Filter" macro?

I have some confluence-pages where some information from jira issues is displayed using some Jira Issue/Filter-macros.

I'd like to define some filter criteria once in the page, all jira-filter should use this attribute.

e.g: 

• all jira-filter should use a defined timestamp / date to display all items resolved before this date.

 

Roma Bubyakin _Wombats Corp_

Hello @Andreas Eder, 

It seems that you have a quite special request
I can propose for it our app User Macro for Confluence Cloud

If I understand you correctly, you have a page. The page has page property. The page property should be used in JQL for searching (and representing) issues from Jira.

Here is how I did it with our app.

Our Jira and JQL with the word "site":

I have added to the target page property "filter" with the value "site"

And now the most interesting, I have created a new User Macro which

1. gets "site" from the page properties
2. make the search in Jira
3. and represent tickets as a table

## the key of the property we are looking for
#set($propertyKey = "filter")

## get all properties for the current page
#set($properties = $ConfluenceManager.get("/wiki/api/v2/pages/${page.id}/properties").results)
## looking for our property one-by-one
#foreach ( $property in $properties )
  ## check if current property same as $propertyKey
  #if ($property.key == $propertyKey)
    ## store the value int $filter variable
    #set($filter = $property.value)
  #end
#end

## setup JQL with the $filter value
#set($jql = "text ~ '${filter}' AND project = TEST ORDER BY created DESC")

## making Jira search
#set($issues = $JiraManager.get("/rest/api/3/search?jql=${jql}").issues)

## show results as a simple table
#set( $jiraUrl = $StringUtils.remove($baseUrl, "wiki/") )
<table class="aui aui-table-sortable">
  <thead>
    <tr>
      <th class="aui-table-column-issue-key">Issue key</th>
      <th>Summary</th>
      <th>Status</th>
    <tr>
  </thead>
  <tbody>

#foreach ( $issue in $issues )
  <tr>
    <td><a href="${jiraUrl}/browse/${issue.key}">$issue.key</a></td>
    <td>$issue.fields.summary</td>
    <td>$issue.fields.status.name</td>
  </tr>
#end

  </tbody>
</table>

On the app code looks much better

 

And the final result: list of issues listed on the page

I hope, I understand you correctly and this is what you need.
User Macro app provides a lot of possibilities for custom logic, integration, and representation.

Regards,
Roman, CEO of Wombats Corp