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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Extracting a row of a confluence table based status column (same confluence page)

Hello 

Bottom section of my confluence page have a table with detail data with column such as, Team, scope, project name, dates, status, comments etc. 

I want to look through the status column and want to pull only that row(s) which have the  status column = Red (confluence status macros Grey, Red, Yellow, Green & Blue)

And if above is not possible, can I extract only that portion of comment section (its free format) that have dates. As an example in the comment section I have below 3 comments from previous days. It will keep increasing until project completed.  Can I extract only the latest comments (1/27:) from the comment section.     

1/27: Project was green until blocked by external team 

1/25: all blocked resolved 

1/15: Team is planning to review the project scope       

2 answers

Hi @Bobby Boruah ,

At the moment Confluence doesn't support table filtering, so you'll need to use additional apps to implement the case.

For example, you may try the Table Filter and Charts for Confluence app and its Table Filter macro:

Mon 1-1.png

Mon 1-2.png

If you keep your dates in a separate column, you may use the Date Range filter. But for your example you can use the Global filter and search the whole table for the "/" separator:

Mon 1-3.png

Hope this will help your case.

well I was looking to extract a portion of comment col (as this gonna increase with all short of updates), based on another col (ex: status col) if the this col is red or green.

Seems confluence can't handle this. The table filter is not an option as I want end-user just to view the confluence as a reports and not indulge any filtering activities.    

The Table Filter macro can be used in a hidden state - you are able to filter, for example, the Red status, save the filter and hide the filtering panel from other users.

So your colleagues will see only specific rows that were predefined by you. Additional filtering icons won't be visible in the page view mode at all.

But if you need to show comments from Jira issues (if I've got you right), this option is not provided by the Jira Issues macro. You should try to browse the Marketplace - there should be some apps that will help you to pull your Jira comments to Confluence pages.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

146 views 0 5
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