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 Plugin: "Setting the Cell Value Delimiter" for Status Macros

Matthias Born

Hello Stilsoft,

we are using multiple status-macros within one cell. If we set the filter for this column to "Dropdown filter columns", the status values are concatinated. A dropdown option is generated for each status value combination.

Is there a way to separate them?

Perhaps with line-breaks, but in that case i have no idea what value i have to add to "Setting the Cell Value Delimiter"

Regards!

Matthias

And, as an afterthougth: What's the delemiter for a simple confluence list?

Accepted answers

Andrey Khaneev _StiltSoft_

Hello Matthias,

There are no line-breaks in html, only block tags that look like line-breaks.

You can use either a white space character (enter \u0020 code) if statuses do not contain spaces, or separate statuses with commas for example.

Also there are no delimiters for lists or any other html tags.

All comments

Andrey Khaneev _StiltSoft_

Hello Matthias,

There are no line-breaks in html, only block tags that look like line-breaks.

You can use either a white space character (enter \u0020 code) if statuses do not contain spaces, or separate statuses with commas for example.

Also there are no delimiters for lists or any other html tags.

Matthias Born

Hello Andrey!

I can't agree with your linebreak statement since there's an <br/> element. That's what i ment. Try Shift+Enter in Confluence Editor and you will see the difference.

To my initial question: Thank you, \u0020 works fine: My status macros are recognized in the dropdown filter even if there are more than one status-macro in one cell.

I have to replace spaces with "-" in the status text, but i can live with that.

Perhaps you may consider extending the options for "Setting the Cell Value Delimiter"?
It would be nice if the drowdown would recognize <br>, paragraphs and lists.
That would make the dropdown filter very powerfull.

Thank u!

Matthias

Andrey Khaneev _StiltSoft_

I meant there are no line-break characters in html, but tags only. And Table Filter works with text and not html, that's why it is not possible to use line-breaks as delimiters.

I've added your feature request to our backlog, thank you!

Christoph Spuhler

Hi,

we're have a table with multiple values in a cell as well, separated by spaces as seems to be the standard for jira issue filter macro. I tried the \u0020, but it doesn't work. Any suggestions ?

Is there a way to have the jira issue filter separate values by commas ?

Andrey Khaneev _StiltSoft_

Hi Christoph,

Did you set \u0020 in the "Cell value delimiter" parameter of Table Filter macro?

Christoph Spuhler

Yes, I did. It doesn't change anything

Andrey Khaneev _StiltSoft_

It should work... Please, contact StiltSoft support to resolve the issue.

floflo

when my cells to be filtered contains several 'status macros' it won't work either (impossible to insert a blank sbetween 2 'status macros', so \u0020 is useless in this case).

I solved the problem with a comma between 2 'status macros' in my cells+ filter option : 'Cell value delimiter' = , (comma)

Joanna Weir

frustrating. I have the same problem. Mutiple sprints come in to confluence via macro as "TCAT 22-2.S12 06/15-06/29/22 TCAT 22-3.S13 06/29-07/13/22". \u0020 doesn't work ,nor does a comma in the "set cell value delimiters". Any other alternatives?

Aliaksei Mikhailau {Stiltsoft}

Hello Joanna,

There are many spaces in your sprint names, this is why \u0020 will not work as you expect. For a comma to work as a cell value delimiter you need to separate different sprints with a comma first, like "TCAT 22-2.S12 06/15-06/29/22, TCAT 22-3.S13 06/29-07/13/22".

You can also refer to Aggregating Tasks when One Task is Included in Multiple Sprints use case to learn more about another option to split sprints.

Best regards,

Alexey

Martin Zhao

This worked for me, thanks!

Martin Zhao

Just a detail to add that helped me is that the column filter must be saved/added to the macro first. Then, edit the macro, go to the column filter and alter the "Cell Delimiter Value" from the individual filter's settings.

Markus Kuslap

Thank you Martin for the input!
I was playing around with the Cell Delimiter Value for days and couldn't understand why it doesn't work...

Matt Kentala

If you want to use a line break (aka carriage return) you may use \n as the delimiter. This allowed me to use a dropdown filter based on child pages.

Welcome!

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

Quick Links

Find more posts tagged with

confluence

filter

confluence-app

table

table-filter

table-filter-and-charts

addon-com.stiltsoft.confluence.plugin.tablefilter.tablefilter