How to retrieve child ticket values through ConfiForm

[Hanyu Huang]

Hello,

@Alex Medved _ConfiForms_ 

I was asked to created a ConfiForm where the user only has to enter the Jira ticket number of a parent ticket (e.g., Feature) and ConfiForm can get certain values from certain child tickets. For example, by entering the ticket number of a parent Feature NKCWPF2SB-59, the form can identify the child Epic with "Application Onboarding" in its summary (NKCWPF2SB-722), and get the MAL Code (TD-03), and that MAL Code is then used in the creation of other child Epics. Is this something that is feasible?

Thank you for your help and understanding.

Yours Sincerely,

Hanyu Huang

[Alex Medved _ConfiForms_]

Hi @Hanyu Huang 

ConfiForms is not a viewer for your Jira data, but you may have something like what is shown here https://wiki.vertuna.com/display/TEST/Mixing+up+ConfiForms+ListView+and+Content+by+Label+macro but utilizing the Jira issues macro from Confluence 

Here I have a JQL field, but for your use case this might be a Jira issue field holding a key to the parent issue and for the "Jira issues" macro you create a dynamically constructed JQL expression that takes "child issues"

 

Alex

[Hanyu Huang]

Thank you Alex. Although I don't think we have access to the storage format editor either. Is there a way to pass in the JQL into the Jira macro without using the storage format editor?

Also, the request was for the user to only enter the parent Feature ID (NKCWPF2SB-59), and ConfiForms would take care of identifying the Application Onboarding epic among the Feature's child Epics and get the value in the MAL Code field. Is this doable with velocity functions or JavaScript? Thank you.

[Alex Medved _ConfiForms_]

It is certainly doable with the approach i have shared. If you don’t have the storage format editor then probably you can craft a user macro for that

[Hanyu Huang]

It is not just seeing the Jira issues for the user though. Finding the Application Onboarding epic and getting the MAL Code value has to be automated. The idea is for the user is to enter the Feature ID, and ConfiForm would take care of retrieving the values from the relevant tickets and create 4 additional epics using the retrieved values all automatically. So NKCWPG2SB-727 to NKCWPG2SB-724 in the example should all be created with a single click of the button, with the only input being NKCWPF2SB-59.