It's possible to insert nested group directly through database?

[Dany Valdivia]

Hi,

We have make a PostgreSQL query that asociate nested groups:

INSERT INTO jira.cwd_membership (parent_id, child_id, membership_type, group_type, parent_name, lower_parent_name, child_name, lower_child_name, directory_id) values
(30631,"30191","GROUP_GROUP",NULL,"CG_Admin_Welded_Pipes","cg_admin_welded_pipes","TNS_P_PDP_QA_Admin_Welded_Pipes","tns_p_pdp_qa_admin_welded_pipes","10103")

this could work or there are extra considerations, because for example, this is not possible by rest api.

Many thanks.

[Joe Pitt · Accepted solution]

DO NOT directly update the database except through the UI or API. You will break your JIRA instance.