nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

where will the versiontype customfield value be stored in DB ?

Shamith Shankar

I need to get value of VersionType Customfield. I tried node association and Customfield tables.No luck.

Accepted answers

noamdah

select * from customfieldvalue where CUSTOMFIELD = &lt;id&gt;;

To identify the custom field ID:

Go to Administration > Custom Fields
Click on the "Configure" link for the VersionType custom field
In the URL of the Configure Custom Field page, note the number after "customFieldId=" and append it to the query.

All comments

Chander Inguva

Hi Shamith

select * from customfield where CUSTOMFIELDTYPEKEY = 'com.atlassian.jira.plugin.system.customfieldtypes:multiversion'

select * from customfield where CUSTOMFIELDTYPEKEY='com.atlassian.jira.plugin.system.customfieldtypes:version'

Hope this helps

vpcf.PNG

Regards

Chander Inguva

vpcf.PNG

Shamith Shankar

Hi Chander,

Thanks. But i need customfield value for a versiontype field.

Chander Inguva

I think the answer provide by me gives you keys to the door. All you should do is query customfield value table using customfield table. It should be easy

Chander Inguva

SELECT * FROM customfieldvalue WHERE ID = <customfieldID>

noamdah

select * from customfieldvalue where CUSTOMFIELD = &lt;id&gt;;

To identify the custom field ID:

Go to Administration > Custom Fields
Click on the "Configure" link for the VersionType custom field
In the URL of the Configure Custom Field page, note the number after "customFieldId=" and append it to the query.

Shamith Shankar

Argh,

i was trying for ,

select * from customfieldvalue where id = <id>;

Thanks a lot.

noamdah

Glad to help. Cheers!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-core