Table transformer merge tables to show dependent tickets

[Megan]

We are linking Initiative tickets to other tickets via the Depends On issue link. I want to use the table transformer macro to display a table that ultimately shows

Parent Issue Key | Dependent Ticket Key 1 | Summary 1 | Other Field 1|

Parent Issue Key | Dependent Ticket Key 2 | Summary 2 | Other Field 2|

Is this possible?

[Stiltsoft support]

Hi @Megan ,

Please check this example: https://docs.stiltsoft.com/tfac/dc-server/custom-transformation-use-cases-with-advanced-sql-queries-42241587.html#CustomTransformationusecaseswithadvancedSQLqueries-MergingJiraIssuetablesbylinkedissuesandkeys

If you are stuck, you may refer to our support. Attach two screenshots of your Jira Issues tables (when the page is published so that we can see the headers and several rows with data). The portal is confidential. We'll recreate your tables and help with the query.

[Megan]

Is there a reason that I'm getting an error that concat_view_aggr is not a function? Was it deprecated? 

[Stiltsoft support]

Hi @Megan ,

No, the function isn't deprecated.

Please check the version of the app that is installed for your instance, it seems that yours may be older than that version in which this function was introduced.

The current version is 9.12.0, please update.

[Megan]

Appreciate this.

What is the version when this functionality became available? Or in another way, when was the functionality introduced?

[Stiltsoft support]

Hi @Megan ,

Really not sure as it is considered a minor change within the app, maybe 8-something or so.

But we recommend to get the latest version: as for now it is 10.0.0. It was a major release where we added a new macro Spreadsheet from Table which allows transferring your regular table or a table outputting a macro's content into Table Spreadsheet with all its tools.