Dynamic population of custom-fields on screens / forms based on value of another custom field (Drop down)

[Ramesh Udari1]

Hi ,

We are trying to find out a way to dynamically populate the custome fields based on value of another custom field (Drop down)

Scenario: I have drop down A with two values 1> producer 2> consumer

and two drop down fields 1> B 2> C

I want to populate these drop downs fields(B & C) based on value of first drop down A.

So if user selects "producer" from the dropdown A , we want to populate other dropdowns FIELDS (B & C) with our customized options which are releated to producer and in same way if user selects consumer, we want to populate consumer related options (customized from our custom database) in B and C fields. I know that it is not possible in jira, but we are ready to customize this plugin if it is possible to build in JIRA using JIRA API. Please suggest how to build this use case.

Please also suggest if you know any third party plugins availabe to fulfill our requirment.

[Fabio Racobaldo _Herzum_]

Hello Ramesh,

you could install JIRA Behaviour Plugin that allows you to implement this feature.

This is a useful link https://jamieechlin.atlassian.net/wiki/display/JBHV/JIRA%20Behaviours%20Plugin#JIRABehavioursPlugin-Setonefieldbasedonanotherfieldwithinformationprovidedbytheserver

Hope this helps,

Fabio

[Ramesh Udari1]

Hi Fabio,

Thanks for your response on this. I have checked this and found that it is not fulfilling my requirment. Can you please suggest if you know any other plugin which fulfill our requirment.

[Fabio Racobaldo _Herzum_]

Hello Ramesh,

why this plugin doesn't help you? you need to defines all possible values for B and C select list. After doing that, using behaviour associated to A custom field, you can dinamically define values for B and C. I did it in the past and it worked.

Let me know if you need more help on that.

Regards,

Fabio

[Ramesh Udari1]

Hi Fabio,

Actually i want to show dynamic values in B and C, it means that when ever user make selection in field A , at this time i want to make a quary based on value selection and have to read data from one of customized table and show in B and C. BUT,as per your expalnation, what i observed that we have to predefine (manually create values)the values for B and C.

I am bit consusing here , can you please expalin bit more on these configuration and other stuff to use this plugin.

[Ramesh Udari1]

Hi Fabio,

Any update on this.

[Fabio Racobaldo _Herzum_]

Hello Ramesh,

sorry for the delay, I was thinking about a possible solution for your question. As you said, my proposed solution allows you to hide/show values that you previously added on B and C custom fields.

if you need to read these values from a customized table, I think that you could try to use this plugin https://marketplace.atlassian.com/plugins/com.keplerrominfo.jira.plugins.databasecf

Regards,

Fabio

[Ramesh Udari1]

Hi Fabio,

Thanks for your valuable response on this. I have tried this plugin and able to ready values from external database, but i could not able to read data from tables of JIRA database. How can we do this. For example i have custom table in jira datbase which was created through active objects. Now i want to read values from this database by using this plugin (data base custom field). But i could not.

Please help me on this.

[Fabio Racobaldo _Herzum_]

Hello Ramesh,

if you need this deep customization, I suggest you to create your own custom field type that can access AO tables. Here more information about how-to guide https://developer.atlassian.com/display/JIRADEV/Custom+Fields+in+JIRA

Regards,

Fabio