Create, modify, delete and query the configured Issue Custom Field Options in Jira.

Table Specific Information

Cloud

In Jira Cloud, this object is exposed as a table and supports CREATE, UPDATE, AND DELETE (CUD) operations.

Server

In Jira Server, this object is exposed as a view instead of a table, and CUD operations are not supported.

Select

Cloud

To execute a query in Jira Cloud, you must specify both the CustomFieldId and the Context.

SELECT * FROM IssueCustomFieldOptions WHERE CustomFieldId='customfield_10107' AND context=10307

Alternatively, you can also provide the OptionId.

SELECT * from IssueCustomFieldOptions WHERE OptionId = 10000

Server

To execute a query in Jira Server, you must specify the CustomFieldId if you are not using the OAuth 2.0 AuthScheme.

SELECT * FROM IssueCustomFieldOptions WHERE CustomFieldId='10104'

Alternatively, you can also provide the OptionId.

SELECT * from IssueCustomFieldOptions WHERE OptionId = 10000

Insert

Cloud

To add a new custom field option, you must specify the option Name along with the CustomFieldId and the Context.

INSERT INTO IssueCustomFieldOptions (CustomFieldId, Context, Name ) VALUES ('customfield_10107', '10307', 'NewAddedOption')

Update

Cloud

To update a custom field option, you must specify the OptionId along with the CustomFieldId and Context in the WHERE clause criteria.

UPDATE [IssueCustomFieldOptions] SET Name = 'NewUpdatedOption123', OptionId='10866' WHERE CustomFieldId='customfield_10107' AND Context='10307' AND OptionId='10866'

Delete

Cloud

To delete a custom field option, you must specify the OptionId along with the CustomFieldId and Context in the WHERE clause criteria.

DELETE FROM [IssueCustomFieldOptions] WHERE CustomFieldId='customfield_10107' AND Context='10307' AND OptionId='10866'

Columns

Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
OptionId [KEY]	String	False		=	Common	The ID of the custom field option.
Name	String	False			Common	The Name of the custom field option.
CustomFieldId	String	False	IssueCustomFields.Id	=	Common	The ID of the custom field.
Context	String	False	CustomFieldContext.Id	=	Cloud	The context of the custom field option.
Disabled	Boolean	False			Common	Whether the option is disabled.