Versions Compared

Key

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

JQL sections for Email, Confluence, Release page notification, JSON, HTML, Markdown, MS Word templates

Excerpt
nameJQL section introduction

Introduction to JQL section

This section plays a crucial role in ARN templates. JQL dictates the appearance of your content and determines the data to be included in release notes and reports. It serves as the central hub for all information intended for end users.

There are three tabs on Add/Edit JQL section pop-up -

  • Section

  • Fields

  • Layout

Excerpt
nameJQL section - section tab

Section

In the section tab you will find below fields to define the content that will be posted in the release notes.

  • Title - This text will be shown as a section header in the generated email or page.

  • Description - This fields can contain the description of your given JQL section.

  • JQL - This field is where you add the JQL to fetch the relevant issues to your release notes

  • Hide section (checkbox) - Check if you wish to hide the JQL section when given JQL does not return any Jira issues

  • Message - When the checkbox is unchecked, write a message that needs to be displayed when no issues are returned from the given JQL.

Excerpt
nameJQL section Fields tab

Fields

This tab is to display what all Jira issue fields/custom fields that are to be added to your release notes. If the Table layout is selected then these fields are added as columns. In the case of the sequential layout, selected fields will be listed in the sequence you have added them.

As shown in the below image, ⚙️ icon in front of each selected field would show some extra settings for the field like header style, Entry Style, display as link or text, etc.

Fields.png

Read how to Save release notes without Jira fields using issue properties.

Excerpt
nameCustom CSS for release notes

Custom CSS

Introduction

To further customise the release notes that ARN generates, it is possible to configure custom CSS within different templates.

How to

Note that custom CSS can be applied only when the layout of the template is Tabular. Sequential layout does not support applying custom CSS as it already uses a WYSWYG editor.

Open any one of the above-mentioned template types & click on any JQL section to open it in Edit mode or start to Create a new one. Make sure the layout/format is set to Table.

Custom CSS can be applied for any of the selected columns, listed in the left-hand section of the Fields tab. Click on the gear icon beside any column name & it will reveal a couple of free text fields where custom CSS can be added.

Header styles refer to the styling applied to the table header for that specific column whereas Entry styles CSS attributes are applied to all the data points generated within that column.

If the JQL section data is grouped by a specific column, it is possible to apply custom CSS to that data as well. Just click on the Gear icon beside Group by option. It shows the custom CSS options.

Note

Gear icon beside Group by option will show the WYSWYG editor if you are creating a new template from scratch. Custom CSS options are available only if you are using ARN defulat templates by cloning them.

Info

For example read this to know how to control width of table columns - https://amoeboids.atlassian.net/wiki/spaces/ARN/pages/126255121/FAQs#How-to-control-width-of-table-columns-within-generated-release-notes%3F

Excerpt
nameTable layout

Layout

Table layout

This layout is fairly straightforward & does not need any additional configurations. All the fields that are selected (from Feilds tab as shown in the above image), will be displayed as table columns from left to right. Below is a sample screenshot of the generated release notes in tabular format.

table.png

In this example you can see coulmn in the table like Priority, Key, Status, Issue type, and Summary. At the left top corner of tble notice the Task issue type icon which means the table is grouped by the issue type. This way using different customisation you can define the way of displaying issues from the given release.

Excerpt
nameSequential layout

Sequential layout

Selecting equential layout presents the selected fields (from the Fields tab) in a sequenced format. The desired layout needs to be designed within the area highlighted below.

seq1.jpg

Here, the design is simply a sequence of available variables. These variables are displayed based on what fields you have chosen on the Fields tab.

seq2.png

Any fields that you have selected to be used, can be arranged in any order you wish. For every field that is configured under Fields tab on the left, there will be two variables on the right. One that will fetch the field value & other to fetch its display label. e.g. for Priority field, there are two variables - {priority} & {priorityLabel}.

Required condition is, you have to add fields & their configurations before they can be used in the Layout section. The layout created will be repeated for every issue that is returned by your section JQL. For example, layout in the above screenshot will generate data that looks like the below screenshot.

seq3.png

In below image check the check box called Hide field label variable when the field value is empty. If this is checked, and if the JQL does not fetch any data in the field value against a particular issue, then it hides the field variable and you can make sure that the release notes do not look like an incomplete piece of information.

sequencial layout.png
Info

If you are using Priority, Status, Issue type in your layout - the generated Email/PDF could be a bit misaligned because these issue fields are images.

To avoid this, modify the field configuration for these fields - and check the box Display as text.

Stats & charts

Introduction

ARN provides Stats & charts macro to make release notes more insightful for you & your team. To put it simply, Stats feature comes up with a number that corresponds to the count of issues that are returned by the configured JQL & chart feature lets you include a simple bar chart showing the count of issues returned by configured JQL aggregated over values of specific Jira field.

Stats

Clicking on Stats & charts would open a pop-up where the system accepts a JQL. And a return value. Return value identifies what kind of data will have to be extracted from the Jira issues that the JQL returns.

statsncharts.pngImage Removed

Typical use cases may include, informing the audience about

  • Issue distribution based on priority, type, assignee, etc

  • Time spent on different kinds of issues

  • Story point distribution across different issue types

Currently, the system can return a number of issues the stored JQL retrieves. So a typical use of this would look something like the image below.

Note that you can also optionally display the number as a link that leads back to Jira.

Sample stats generated with ARN:

Image Removed

Charts - bar chart

Clicking on Stats & charts would open a pop-up where select the type as Bar chart. Below are the fields you have to to add or edit while creating a Bar chart.

  • Title - Chart title, this is displayed to the end user

  • Type - If creating Bar chart select Bar chart, to display the count. select Stats

  • JQL - Add the relevant JQL

  • X-axis - Define the Jira issue field that should be displayed on the x-axis.

    • For eg. in chart from image below, we have selected Assignee for the X-axis so it shows the names of the users and on Y-axis it shows the numbers by default

  • Return - It will be counted by default

Image Removed

A bar chart place holder image shall be inserted into the template. Users can resize this image to resize the designated area for the bar chart within the template.

Image Removed

No of issues returned by the JQL shall be aggregated against the unique value of the selected Jira field and a bar chart shall be included within the area designated within the template.

cropped.pngImage Removed
Excerpt
nameGroup by option in layouts

How to sort 'Group-by’ fields in a JQL section

The Order by clause in JQLs respects the sorting of Group by fields as well. This means that groups created by the Group by fields in the JQL section can be ordered in the desired sequence. Additionally, you can now choose where to place orphan elements of the respective Group by field. This update provides greater flexibility and control over the organization of your data.

Here is an example:

  • There is JQL section with the Components field as a group-by field.

grp by.png
  • So the Jira issue data returned by this JQL section will be grouped by the value of their component.

  • If you want those groups to appear in a certain order (ascending or descending), then you should include the group-by field (Components field in this case) in the Order by clause of the JQL like this

compo.png
  • This will automatically order the groups created by the Group-by’ field in the order defined in the JQL.

  • You can include multiple fields in the order by clause of the JQL and the order of all such fields will be honored in the output of that JQL section.

Orphan elements

  • Now if there are any Jira issues where the value of the Components field is blank, such issues are called orphans.

    • By default, the orphan issues are placed at the bottom of the group.

    • However, you can choose to place them at the top of the group.

    • Navigate to the field customization menu of the concerned group by field to choose where the orphan issues should be placed.

orph.png
Excerpt
nameStats and charts
Excerpt
nameAI generator macro

AI generator

ARN templates now feature an AI-powered summary of the issues retrieved by a given JQL. This enables you to swiftly share a concise overview of the content included in the release notes or release notes report you're preparing. The process is as straightforward as adding a JQL section but with an AI element.

Steps

While customising any of the above templates, you will notice an option called +AI generator in the template editor.

AI templates.pngImage Removed

Clicking on this +AI generator opens up a pop-up with the below fields -

AI fields.pngImage Removed

  • Title - This title will show up in release notes for the summary generated using this feature

  • Prompt - Give a prompt to AI based on what content needs to be generated as a summary. You can input a maximum of 500 characters as a prompt.

    • +Variables - You can use ARN variables so those will be replaced with relevant values from the associated Jira issues

  • JQL - Detail out the JQL so system retrieves the relevant Jira issues. System will look for the Jira issye fields that you have specified below and it will consider that selected field for the issues retrieved as per the JQL.

  • Where to fetch issue data from? - Read detailed description https://amoeboids.atlassian.net/wiki/spaces/ARN/pages/3801612289/Generator+for+AI-powered+release+notes#Feilds-in-the-AI-generator.

When you select 'Use a Jira issue Field' it list down all Jira issue fields of the below type -

  • Summary (default Jira field)

  • Short text (Plain text only)

  • Hide section - Check this option if you wish to hide this AI-generated section when there are no issues retrieved from the given JQL.

  • Message - If you uncheck, Hide section option above then define the message you want to show when there are no issues retrieved from the JQL.

Once you are done with specifying all the above fields, click on Insert. You can check the preview to check what content AI has generated. You edit the content manually or update the prompt based on the given content and what you were expecting as a result.

ai eg.pngImage Removed
Note

Currently this AI generator macro is available for specified ARN templates at the top of this documentation. We are actively working to cover all other remaining macros.

Excerpt
nameCustom variables
Custom variables bring a different level of power to the ARNR app

JQL section for MS PoperPoint template

The JQL functionality in MS PowerPoint operates uniquely compared to other templates such as Email and HTML.

Below, we elaborate on the process of incorporating a JQL section for creating release notes and reports in MS PowerPoint format.

Excerpt
nameJQL section MS PowerPoint

The JQL section in MS PowerPoint template has three tabs -

  • Section

  • Fields

  • Available variables

Section

This tab contains only JQL that will fetch Jira issues and their details to your release notes or reports.

JQL ppt.pngImage Added

Fields

This tab is to display what all Jira issue fields/custom fields that are to be added to your release notes and reports. This will generate a sequential layout by default in PowerPoint slides, selected fields will be listed in the sequence you have added them.

Feilds PPT.pngImage Added

As shown in the below image, ⚙️ icon in front of each selected field would show some extra settings listed below -

Fields ppt1.pngImage Added
  • Display as text -

    • If checked, value will be displayed as text

    • In case of Description feild, if this setting is checked, value of this field will be displayed as text ignoring any media files and links in the content fetched from the Jira issue content. Currently MS PopwerPoint template does not support images from the Jira issue content.

Field PPT2.pngImage Added
  • Hide field label variable when the field value is empty -

    • When checked, if the field value is empty, the field label variable shall also be kept empty in the sequential layout.

Available variables

  • All the Jira issue variables and custom field variables that you have added from the Field's tab are displayed in this tab. So it becomes easy to track all the variables you need to add to the slide that you want to upload in MS PowerPoint template editor.

variables ppt.pngImage Added
Tip

Make sure you are adding the Jira issue variables that are included in the PowerPoint presentation you are going to upload in this template.

On this page

Table of Contents
maxLevel6
minLevel2
outlinefalse
stylesquare
typelist
printablefalse

Iframe
scrollingauto
srchttps://form.typeform.com/to/loItQqk5#url=xxx
width350
frameborderhide
alignmiddle
height250

Request support👨‍💻

Leave us a review(green star)