Create
cancel
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

Tool for documenting data model and filters

Hello community,

The company I work for has a data model with a few hundred properties, we also have the option to create filters where customers can indicate which property needs to be returned. (this is a manual job) I am looking for a Confluence tool where the team and document two things:

1. Per property (element) indicate in which filter it's used

2. Per filter see which properties are used

3, Version and change management would be nice, but since it's within Confluence I expect this to be handled already

Do you have any recommendations on which tool we can use? Or sent me in the right direction to start our search.

3 answers

Hi @Sander ,

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

It provides the Table Excerpt/Table Excerpt Include macros that work somewhat similar to the Page Properties Report macro but allow you to collect multiple-row tables and create one big combined report.

This report can be further filtered with the help of the Table Filter macro by one or several columns (you'll get various filter' types: free text, dropdown, free text, etc.).

Seems that it will simplify your case: each department/person maintains his/her own table, all the changes are immediately passed to the combined report and your customers use filters to find whatever they need.

Hello Katerina,

 

Thank you for sharing the app, it looks interesting. I will read the documentation and see if it's what we are looking for.

Cheers,

Sander

Hi @Sander,

Could you maybe give an example of what that would look like exactly? I have a bit of trouble understanding what you'd want the workflow to look like (i.e. who do you want to create what Confluence page at what point, etc.) but it sounds a lot like to me that our app Orderly Databases for Confluence could be a good solution for what you're trying to achieve.

To me it sounds like you'd want to create an Orderly Database that with two columns:

  • Filter (Type: Text)
  • Properties (Type: Enum, Multi-select)

You could then put all of your available properties into the enum of the properties column. This would allow customers to create new entries in the database and define for a given Filter what Properties belong to it.

To report on it, you could then later filter by single values such as: "Give me all filters which contains properties X, Y, and Z" or even "Give me properties which are used in at least one filter".

Hope this is helpful to you!

Cheers,
Sven

Hello Sven,

The app you link looks promising, I will look into it. Thank you for linking it.

Cheers,

Sander

Like Sven Schatter _K15t_ likes this
0 votes
Pramodh M Community Leader Dec 31, 2021

Hi @Sander 

The details depend on what data you are expecting

Here's the link that may help you

https://community.atlassian.com/t5/Confluence-questions/How-can-I-search-for-pages-that-have-the-Pages-Properties-macro/qaq-p/1032988

We can also extract data from API where we can check whether the properties are used

To do this, get the list of pages from the filter and then check for the properties on each page

https://developer.atlassian.com/cloud/confluence/rest/api-group-search

Thanks,
Pramodh

Suggest an answer

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

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

42,334 views 29 133
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