Dynamic Filtering of JIRA tickets

[Hassan Zerda]

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

[Stiltsoft support]

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.

[Craig Nodwell]

Hi @Hassan Zerda welcome to the community.  Since you are on DC you can write your own user macros.  I would recommend you look into doing this to satisfy your requirements.
Writing User Macros

[Hassan Zerda]

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)?

[Craig Nodwell]

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.