nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Table Filter and Charts String Splitting

Craig.Harley

I'm pulling a Jira table into the table filter and charts macro in Confluence. One of the fields returned contains a comma separated list of url links to a confluence page.

Each page has details on either an API consumer or an API provider

they are returned in the following format

Consumer URL 1, Consumer URL 2: Provider URL 1, Provider URL 2

where the consumers and provider urls are split by a ":"

Is there any way to split this into 2 columns, so that

Column 1 = everything Left of ":"

Column 2 = everything Right of ":"

Unfortunately it would have made sense to put providers and consumers into different Jira fields, but I have no control over anything done in Jira.

So is there nay way to achieve my ask?

Accepted answers

Aliaksei Mikhailau {Stiltsoft}

Hello @Craig_Harley ,

It is difficult to say why the result is not as expected in your case. I noted that you used % instead of : as separator. Was it planned?

Feel free to share how your "Acceptance criteria" column in Jira is displayed to understand your case better. You can create a support ticket here.

All comments

Aliaksei Mikhailau {Stiltsoft}

Hello @Craig_Harley,

As you've mentioned our Table Filter, Charts & Spreadsheets for Confluence app, let me note you can achieve the expected result using our Table Transformer macro. The example SQL query for your request is as follows:

SELECT
SPLIT_VIEW(T1.'Your column name', ":")->0 AS 'Consumers',
SPLIT_VIEW(T1.'Your column name', ":")->1 AS 'Providers'
FROM T1

Craig.Harley

hi Aliaksei,

thanks for this, however have tried it and it doesn't work, I get empty cells back

Screenshot 2025-05-16 191134.png

Screenshot 2025-05-16 191346.png

Aliaksei Mikhailau {Stiltsoft}

Hello @Craig_Harley ,

It is difficult to say why the result is not as expected in your case. I noted that you used % instead of : as separator. Was it planned?

Feel free to share how your "Acceptance criteria" column in Jira is displayed to understand your case better. You can create a support ticket here.

Craig.Harley

as requested I have raised TFCS-6988

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

cloud

confluence-cloud

filter

table

table-filter

table-filter-and-charts

table-transformer

table-filter-charts-spreadsheets