Dynamic Filtering of JIRA tickets

Question

Hi,

I'm looking for a way to dynamically lookup all tickets which are linked to a master ticket. The user should be fill in his ticket number and all tickets linked to it should be shown in table form.

I'm quite new in confluence stuff so any pointers/help would be appreciated.

Thanks in advanced

Craig Nodwell_7eve9b · Answer

Probably, user macros are written at the admin level.  Talk to your admin about your requirements they may have recommendations or help with a solution.

Stiltsoft support · Answer

Hi @Hassan Zerda ,

With the help of our Table Filter, Charts & Spreadsheets for Confluence app and its Table Transformer macro you'll be able to combine two Jira Issue tables: one with Epics and linked issues (a comma separated list) and the other is with issue keys of these linked issues and their own fields.

You may look here for an example: https://docs.stiltsoft.com/tfac/cloud/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-MergingJiraIssuetablesbylinkedissuesandkeys

Further you may wrap your Table Transformer macro in the Table Filter macro and filter your result table by Epics on the fly.

Hassan Zerda · Answer

Hi, Thanks for the swift reply.

Unfortuantly I dont see Administration at space tools. Can it be that this has been disabled by the adminstrator (IT)?