How to create custom field on OrganizationMembers or Organization_10002 table

[Tayo Adetoyi]

I would like to know if it is possible to create a custom field on OrganizationMembers table that contains the following fields: Organization_ID, Organization_Name, User_Name, Email, Is_Active etc. OR on the Organization_10002 table that contains the following fields: Organization_ID, Organization, Issue_Key and Issue_ID?

[Kai Becker]

Hi @Tayo Adetoyi 

welcome to the community and thanks for your question.

By default, such a special custom field config is not possible, as you can't create or modify system fields.

What might work though is using a 3rd party app, for example Elements Connect and gather this custom data via Jira Cloud API.

But I actually do not have an example for that.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Fortunately, you have no access to the database on Cloud, so no, there's no way to do this. 

If you were on Server/DC, you could do this, but it would render you unsupported, the backups might fail, and you would need to re-code several chunks of Jira to enable the use of the new columns.

Atlassian only support adding custom fields to issues at the moment, but there are a couple of apps that add fields in other places.  Project fields, I've used a few times, but I have not seen anything that can do it with organisations yet.