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?