Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
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

We have Confluence Server with the following installed:

  • Adadtavist scriptrunner for confluence
  • Oomposition
  • Confluence source editor
  • Viewtracker – analytics for confluence

We use Confluence for a Wiki type system for information on our products. Most of the pages have tables and I want to have a column to indicate whether a particular product is under warranty or not based on a separate spreadsheet.  Can I do this with these products or would I need something else?



2 answers

5 votes

Hi @Craig Beaubien,

It sounds a bit to me like this is more of a manual process for you, but do you have this data available in a database or via a REST API? If yes, you could use our app PocketQuery to dynamically pull in the data for a given product.

For example, you could create a Query called "warranty_check" which has a "product_id" parameter. You can then insert the PocketQuery macro into your pages and have it render the warranty status of your products, based on the product_id (which you can specify in each macro). Going further, you could even use PocketQuery to pull in the whole table containing your product information from an external datasource - given that it's available in a database or REST API of yours.


Hi @Craig Beaubien,

We can recommend our app - Table Filter and Charts for Confluence.

If I've got your case right, you have the following situation: there are many small tables related to the special types of products on different pages in your Wiki.


The Product name (the first column) is a unique value.

Then you have one big table with all the products listed that you use to display the warranty status.


The case is to lookup the warranty statuses with the products in your small tables automatically.

The first step is to reuse your big table with the Warranty Status column on the every page containing a small table. It is very convenient - all the changes made to the source table will be automatically reflected in the reused tables. Let's use the Table Excerpt/Table Excerpt Include macros for this purpose.


The second step is to lookup every small table with the reused big one. Let's use the Table Tranformer macro and its default Lookup preset.

 3.png4.png5.pngThe third step is to hide extra table rows that we don't need to show - we'll use the Table Filter macro for this task.

6.png7.pngNow, as you see in the macro preview, your case is fully accomplished.

Feel free to try out the app - there is one month of free usage. You'll see that the app is very flexible and allows you to nest macros in different combinations so that to filter tables, modify them, perform calculations, create pivots and different charts.

Suggest an answer

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

You’re invited: Confluence for MS Teams Live demo + Q&A

This past summer, we joined forces with Microsoft Teams as a part of our mission to help your team collaborate better, starting with more effective meetings. We released a new and improved Confluence...

95 views 0 1
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