Distribution key definition ( variable number of values for a custom-field )

[Murat BALKAS]

Hi experts, 

I'm trying to implement project & request management process for a holding company. There're more than 100 companies and thousands of cost-centers. One of the requirements is to implement distribution of costs among various companies and cost-centers of the holding. 

The main requirement is : for each issue, they want to select the companies and and cost-centers ( sometimes more than one cost-center for one company ) and provide a cost distribution percentage for each cost-center selected. Possible values for percentage can not be pre-defined, has to be an input field accepting any type of ( ##.## ) number values. 

They basically want an "Add Another" button, select the company, select cost-centers and input the cost distribution percentage. If they press the "add another" button again, they will select another company and related cost-centers and percentages, etc... 

Is there any way to implement this in JIRA? 

is there any plugin providing this functionality?

Thank you in advance for your help,

Murat

P.S. : JIRA version : 6.3.15. 

[Radu Dumitriu · Accepted solution]

Basically you will only need Blitz-Actions (paid) and DBCF (free).

1. Create a table in the database of your own, and configure it (JNDI). See below its structure. Don't forget the indexes!
2. Blitz-Actions will implement the custom dialog, such:

• Creates the dialog with the inputs (cost centers - select list, percentage)
• inserts the values in the database (key of the issue, cost center, percentage)

https://confluence.kepler-rominfo.com/display/KBA/Home

1. DBCF will appear on view (data-table). The select must refer the key of the issue (dynamic query)

https://confluence.kepler-rominfo.com/pages/viewpage.action?pageId=4161561

Of course, you may need validation on the issue (i.e. sum == 100%) That can be done with JJUPIN, which has native support for the above, but you can use whatever.

[Renjith Pillai]

Mostly you need write an own plugin that provides this functionality.