how do I access rank and rank(obsolete) customfield via SQL

Question

I want to get values of Rank and Rank (Obsolete) for a particular project. Please help...

For Rank:

com.pyxis.greenhopper.jira:gh-lexo-rank

For "Rank (Obsolete)"

"com.atlassian.jira.plugin.system.customfieldtypes:float";

"Rank (Obsolete)"
"com.pyxis.greenhopper.jira:gh-global-rank";

cgauterio · Answer

Hi Tushar,

For the Rank (Obsolete) "com.atlassian.jira.plugin.system.customfieldtypes:float" the values are still stored in the customfieldvalue table. For the Rank(Obsolete) "com.pyxis.greenhopper.jira:gh-global-rank" custom field, the rank uses the AO_60DB71_ISSUERANKING table, where the first issue points to the next one, and so on. It doesn't have an absolute value.

Hope this helps!

Cheers,

Clarissa.