You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have a very specific requirement:
For accounting reasons users have been grouped into user groups per department (Jira as well as Confluence). Now there should be a evaluation/list of those groups and users with several more specific data like the following:
department group | userName | fullName | email | createDate | permissions per application (Jira: each project the user has a role, Confluence: each space the user has permission in)
Scriptrunner is available in both applications (Jira & Confluence). Some questions/thougths that came to my mind:
1. I was thinking about getting all these data with scriptrunner natively but I could not figure out how to fetch "createDate" in Confluence (in Jira there is a method for this. unfortunately not in confluence)
2. I´m pretty sure all this information is stored in the DBs. I just don´t know how to figure out the query for that (could at least find a good overview for Jira DB here:
Does anyone know something similar for Confluence?
Furthermore: Could anyone help with the query? I know how to fetch user information but not how to get Space/Project permissions.
3. After fetching all data: what would be the best way to store it an bring it into a table on a confluence page? RestAPI ?
I furthermore have "Advanced tables" plugin in confluence that could create tables from a JSON so I was thinking about a scriptrunner endpoint that can then be called by the plugin. Unfortunatelly I´m not that familiar with creating an endpoint (and also would need point 2 for that).
Hope anyone can help or at least give helpful hints that might lead to a solution.
Thanks in advance.
At least I could figure out point 3 by myself and create an endpoint that delivers a JSON that can be fetched and displayed as a table by "advanced tables" in confluence.
I will try to find out the rest by "try and error" =D