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. 

[Stiltsoft support · Accepted solution]

Hi @Jitendra Shembekar ,

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

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

Hope this helps your case.

[Jitendra Shembekar]

Hi @Stiltsoft support 

Thanks for the revert. I tried the suggested solution but I am getting parsing error.

Here is the table I am using

This is the formula I am using

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

This is the error

Can you please check what is wrong here. Thanks in advance for your help!

[Stiltsoft support]

Try to use not

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

but just

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

[Jitendra Shembekar]

@Stiltsoft support - I found the mistake in my formula. :)

Thanks a lot for the solution. You guys rock! Excellent!!

[Craig Nodwell]

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.

[Jitendra Shembekar]

Hi @Craig Nodwell 

Yes I am using that option, but it gives output like this - '66 issues' not just the number '66'.

Thanks!