how to port fields from Jira to Table View in ConfiForms using field type:Jira Field?

[Omar Contreras]

Hi,

I created a ConfiForm to pull some fields from Jira into a TableView in Confluence. I am then using the following configuration in the Field Name of ConfiForms Field macros: 

nameoffield.fields.fixVersions.description

This is working fine with fixVersions, however, I am trying to do the same using the Jira Issue field type and pull names and values of 2 Custom Fields.

I have tried these two configurations suggested by other tickets, but none of it work:

nameoffield.fields.customfield_#####.greenhopperAsJSON.name

nameoffield.fields.customfield_#####.name

nameoffield.fields.customfield_#####-val.name

[Alex Medved _ConfiForms_]

Take a look at this tutorial - https://wiki.vertuna.com/spaces/CONFIFORMS/pages/42926274/Accessing+Jira+issue+fields+directly+from+ConfiForms+using+Jira+issue+field

[Omar Contreras]

Thank you @Alex Medved _ConfiForms_ , yes, I have been looking at that tutorial, and also this one: https://wiki.vertuna.com/spaces/CONFIFORMS/pages/5341277/Accessing+field+values+and+properties

Based on both, I have tried all of the following configurations in the Field name of the ConfiForm Field macro inside TableView, but none are working for me (I am trying to pull the value of the parent of a Jira Field Type: Cascaded Field:

NameField1.[entry.customfield_#####]

NameField1.[entry.customfield_#####.parentLabel]

NameField1.[entry.customfield_#####.parent.label]

Any help with this configuration will be greatly appreciated, 

Thank you

[Alex Medved _ConfiForms_]

What JSON structure is returned for the field you want to show in a TableView?

[Omar Contreras]

I am only creating a record in Confluence, not creating or updating any Jira IssueType. Forgot to add to the ticket, that this configuration is INDEED working in TableView for other CustomFields I need in TableView, it is not working only for the Cascading field type.

[Alex Medved _ConfiForms_]

I am not talking about updating Jira issue here. You want to show the data from the Jira issue using the ConfiForms Field of a Jira type, right?

So, WHAT JSON gets returned for the Jira issue and for the field of interest in particular, as per advice in the https://wiki.vertuna.com/spaces/CONFIFORMS/pages/42926274/Accessing+Jira+issue+fields+directly+from+ConfiForms+using+Jira+issue+field ?

[Omar Contreras]

I understand, but I am not sure how to get the JSON returned, are you taking about the TableView specific format? or how can I send you this? I do see this instruction: 

"And anything you se here can be accessed through the ConfiForms Field macro, setting field name parameter to a "navigational expression"", but this is the first time I deal with this use case, and I am not familiar with how to set the field name parameter to a navigational expression. 

Any help will be great,

[Alex Medved _ConfiForms_]

Well, there is a very clear instruction of HOW to get the JSON structure that is getting returned for the Jira issue

[Omar Contreras]

well, I did follow those instructions, but I am not getting any data similar to what you have in the article. If I search for my custom field in reference, yes, I find it, but I don't see any JSON like structure. Is there another way you can help me here? again, my TableView field configurations are working correctly with other Custom Fields, the only one not working is this Cascading field type. 

[Alex Medved _ConfiForms_]

OK, what have you "followed"? have opened the URL in a browser (the format you can see above and on the earlier linked page)?

[Omar Contreras]

yes, that is what I did, but with my server, and my issuetype Jira Key

[Alex Medved _ConfiForms_]

And? Have you got a result?

[Omar Contreras]

I did, but nothing in the format of the article. So, I don't know what to send you regarding this specific Cascading Jira Custom Field

[Alex Medved _ConfiForms_]

What do yo mean nothing? No response?

[Omar Contreras]

I do get a response, but the data is not like what you have in the article:

[Alex Medved _ConfiForms_]

What do you get in a response? a JSON?

[Omar Contreras]

I am not sure what to send you, so you can help me. Also, you do have information about Cascading fields in a Venture article, but I have tried many combinations and none is working: 

---

---

---

[Alex Medved _ConfiForms_]

This is a public formu, if you are not secure to share the response of the request here then opena support ticket with us and SEND the result of the request that you get

[Omar Contreras]

yes, I can't share the response here. Would you mind sending me the link to open a support ticket with you?

[Omar Contreras]

@Alex Medved _ConfiForms_ I think I got something working:

I used the following configuration in the name field:

MyJiraField.fields.customfield_#####

but I got this in TableView:

{"self":"https://myServer/rest/api/2/customFieldOption/82402","disabled":false,"id":"82402","value":"Percent"}

how can I transform the above to actually display ONLY the value?

[Alex Medved _ConfiForms_]

MyJiraField.fields.customfield_#####.value

[Omar Contreras]

that did it!! thank you so much Alex

[Omar Contreras]

@Alex Medved _ConfiForms_ , one more quick question, what would I need to add to the configuration that is working to see the value of the second drowpdown?, this is how it is shown in Jira: Time - Hours, where Time is the value selected in the Parent drowpdown, and Hours the value selected in the Child drowpdown.