how to get the option count for a select list in jira 4.4.5

[srikanth Asoori maringanti]

how to get the option count for a select list in jira 4.4.5

[Janet Albion · Accepted solution]

Hi srinath,

I don't really understand the requirement. Just guessing the requirement here.

the following might help you in a way:

1. identify the custom field id:

select * from customfield where customfieldtypekey='com.atlassian.jira.plugin.system.customfieldtypes:select';

2. check how many option in the customfield has and what is the option id:

select * from customfieldoption where customfield=<customfield_id>;

3. find how many time the option is selected

select  count(*) from customfieldvalue where customfield=<customfield_id> and stringvalue=<option_id>;

4. list down all the value and it's corresponding issues that has the value selected:

select * from customfieldvalue where customfield=<customfield_id>;

Generally, 3 main table is related:

* customfield, customfieldoption and customfieldvalue table

Good luck

[srikanth Asoori maringanti]

Thanks all,

My requirment is when configuring the default value for my custom field ,my custom field must select one of the statuses as default value.It worked fine in jira 4.1.2. But when I tried the same in 4.4.5. it is unable to set the default value eventhough my select list is populated with the statuses.

So I am trying to modify the code and Iam first populating the options and from the options I am trying to get the default value.

Is there any alternative way ,so that I can populate the Default value from the select list which contains all the statuses.

Thanks in advance.

[Nic Brough -Adaptavist-]

See https://answers.atlassian.com/questions/117052/what-is-the-problem-with-this-code-in-jira-4-4-5-for-select-list-why-the-list-is-always-returning-null-value where the code that is going wrong is posted and being debugged.

[Nic Brough -Adaptavist-]

See https://answers.atlassian.com/questions/117052/what-is-the-problem-with-this-code-in-jira-4-4-5-for-select-list-why-the-list-is-always-returning-null-value where the code that is going wrong is posted and being debugged.

[Nic Brough -Adaptavist-]

I'm sorry, that doesn't make a lot of sense. The best I can make out is that you want to "take a copy of a list of status and put it into a select list, using the status names as the option names?" After that, I'm lost. I'm also curious as to the business reason for doing this (I can think of one, but it's not a lot of use, and the best answer is actually "talk to the users")

Could you explain what you want the user to see and do?

[srikanth Asoori maringanti]

I want to add all the statuses to options programatically. For that i am using getAllStatuses().And also only I want the statuses to be act as options and user cannot be able to add the option directly unless it is added as status. For that I want to compare the number of options and no of statuses every time if they are diffrent then I need to erase all the options I want to populate my statuses.

If there is any alternate way please suggest me.

Thanks in advance.

[Bhushan Nagaraj]

What exactly are you trying to do?