Table Transformer: SQL query on Jira URL

[Craig.Harley]

Hi, I am pulling a Jira table into Table transformer

I want to display all the rows, which is simple enough

however I want to manipulate the data that is displayed in one of the columns

The column in question returns all the Linked Issues for each Jira Entry returned in the table (this can have multiple entries)

I want to be able to only display linked issues of a particular type (so for instance anything starting with "SISLE") and blank out any linked issues starting with anything else, but at the same time still display the full list.

any guidance would be greatly appreciated

[Stiltsoft support]

Hi @Craig.Harley ,

You may flatten your array and break each linked issue in a separate row. Then you may filter out that rows which don't start with "SISLE".

[Craig.Harley]

thanks for the quick response, however i don't want to filter the rows out

I still want to display all the rows (including the ones that don't contain "SISLE" as an entry in Linked issues)

For the ones that don't contain "SISLE", I just want to blank that particular field out

i.e all rows displayed, all entries under linked issues blanked out, apart from the ones containing "SISLE"

[Stiltsoft support]

Then you may just aggregate the table back after the filtering if a linked issue per row doesn't suit you.

Or you may look into the MATCH_REGEXP function (write a regular expression that is suitable for your unwanted expressions) and REPLACE function (replace your unwanted expressions by spaces or smth).

You can find the list of the supported SQL functions here.

[Stiltsoft support]

And maybe this question will help: https://community.atlassian.com/t5/Confluence-questions/Table-Transformer-Sorting-out-multiple-values-from-a-column/qaq-p/2622470

To find the "SISLE" parts and move them to a separate column. The original 'Linked Issues' column should be hidden (not listed in the query).