Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Trying to get matching issues from Linked Issues Column in Table Transformer

Hi

I have 2 tables (T1 and T2) that I am trying to join in Table Transformer.

T1 has issues that are children of issues in T2. (The link was created using Is Child of relationship)

I'm trying to get combined data with Status of T1 items and Summary from T2 items to use in a Pivot table. (so if there are 5 children linked to a Parent with Summary abc, it will show ABC with counts of T1 broken down by statuses in my table on one row)

I found the below query in another thread and it works great for me in most cases, except if an item in T2 is in Done status. It then shows in the Linked Issues column of T1 with a strikethrough and then it does not seem to match the actual key in T2. 

SELECT T1.'Status', T2.'Summary FROM T1
LEFT JOIN T2 ON T1.'Linked Issues'->split("XXX-")->indexOf(REPLACE(T2.'Key', "XXX-", "")) > -1

XXX is the Project key

Any suggestions for doing the match for Parent items that are done?

 

2 comments

Never mind, found my own answer !!

The above query was actually returning > -1 only if items other than item no 1 in the list from T1 matched part of the key in T2. In my case, the Done items just happened to be first in the list of linked issues and hence were not returned.

I adjusted the query to be 

SELECT T1.'Status', T2.'Summary FROM T1
LEFT JOIN T2 ON T1.'Linked Issues'->split(",")->indexOf(T2.'Key') > -1

and it works good now.

Like # people like this

Hi @Bhalchandra Wagle ,

Thanks for reaching out - we check the related to our Table Filter and Charts for Confluence team questions but I guess there was a delay due to the time zones difference. Glad that everything works fine now!

If you come across any difficulties in the future, don't hesitate to post your question here or create a support request (please attach the screenshots of the source tables as well).

Like # people like this

Comment

Log in or Sign up to comment
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

38,465 views 28 126
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you