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.

[noamdah · Accepted solution]

select * from customfieldvalue where CUSTOMFIELD = <id>;

To identify the custom field ID:

1. Go to Administration > Custom Fields
2. Click on the "Configure" link for the VersionType custom field 
3. 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!

[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

[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>

[Shamith Shankar]

I already did that. and i didn't find it in customfieldvalue table.