JIRA Server: Change name of user group / how to change Agile Board Admins using SQL

Dirk Bromberg November 15, 2023

Hello,

to move to cloud we need to change a few user groups on server.

This is working for stuff mentioned here:

How to rename a group in Jira | Jira | Atlassian Documentation

But what is missing:

Usage of groups in agile boards, as administrators. Is there a sql table for this?

Thanks for help!

 

2 answers

1 accepted

0 votes
Answer accepted
Dirk Bromberg November 16, 2023

Okay, found it myself, here is the query to the board admins table:

 

SELECT
ba."KEY" AS "Group",
rv."NAME" AS "Board"
FROM
"AO_60DB71_BOARDADMINS" ba
LEFT JOIN "AO_60DB71_RAPIDVIEW" rv ON ba."RAPID_VIEW_ID" = rv."ID"
WHERE
ba."TYPE" = 'GROUP';

0 votes
Sanjen Bariki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 15, 2023

Hi @Dirk Bromberg ,

 

Welcome to Atlassian community!

Please find the below link to see the usage of group in jira as possible.

In Jira, Currently UI only show when a group is used in:

  • Permission Schemes
  • Notification Schemes
  • Issue Security Schemes
  • Shared filters

Please find the below featuer ticket for this.

From the databse sql to get the list from DB, Please find the same community questions responded by the Atlassian team.

 

Hope it will help you.

Regards,

Sanjen

Don't forget to hit the answer button If it helps you😊.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 15, 2023

@Sanjen Bariki 

Please stop using AI to answer questions.  LLMs do not understand the software, nor the question, and they consistently generate really very poor answers such as this.

If you do not stop, it is likely that the moderators will ban you.

Like # people like this
Sanjen Bariki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 15, 2023

Dear @Nic Brough -Adaptavist- ,

 

Sorry to say.

This is not generated by AI this is what I got from the q.s.

You can't say this answer from AI, why are you always trying to say this is from AI. If you have any problem then you can correct me but I can't accept this is generated by AI.

SORRY FOR THIS

 

Note :- I just noticed the q.s changed now and Before the qns. This q.s was different related to DB.

 

Regards,

Sanjen

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events