Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,464,541
Community Members
 
Community Events
176
Community Groups

Table Filter Plugin: "Setting the Cell Value Delimiter" for Status Macros

Edited

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?

4 answers

1 accepted

2 votes
Answer accepted

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.

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

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!

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)

This worked for me, thanks!

Like Stiltsoft support likes this

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.

Like # people like this

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...

Like Martin Zhao likes this

Glad I could help!

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 ?

Hi Christoph,

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

Yes, I did. It doesn't change anything

Like Joanna Weir likes this

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

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?

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

Like # people like this

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events