nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence - Jira Macro. How to exclude 'issues' text from the retuned value

Jitendra Shembekar

Whenever we use JIRA macro in Confluence, it returns value like - 105 issues.

If I want to get only the numeric value and exclude text 'issues', is it possible?

If this is possible then it will help a great deal in performing automated arithmetic operations in Confluence, by pulling values in a table and then using table transformer (sql queries) macro.

Accepted answers

Stiltsoft support

Hi @Jitendra Shembekar ,

You may use an additional Table Transformer macro to split your string by the space character and leave only numbers:

Wed 3-1.png

SELECT *,
T1.'Column 2'->split(" ")->0 AS 'Column 2'
FROM T*

Wed 3-2.png

Hope this helps your case.

All comments

Craig Nodwell_7eve9b

Hi @Jitendra Shembekar this is fully possible. When you are in the macro definition there is a link in there for Display Options. In Display Options you can select Issue Count Only.