Google Spreadsheets Add-On: Query Epic and Obtain Custom Fields

[Nadir Garouche]

Hi

I would like to list all tickets attached to an Epic and have custom fields displayed in the report. How can I achieve this?

I cannot use Project search because tickets are in different projects and I don't have the list.

Thank you

[Earl McCutcheon]

Hi Nadir,

Are you using "Jira Cloud for Sheets" add-on in google to pull the data into your google spreadsheet or some other add-on?

If you're using Jira cloud for sheets, you can specify which fields and subfields you want to pull in using the =JIRA() function, with  examples in the expandable section "How do I specify which columns are populated in the spreadsheet?" in the documentation for "Jira Cloud for Sheets" 

an exe call for all issues linked to a specific epic named EXE-1 would be Either this for a spiciffic list of fields:

=jira("project = EXE AND cf[10008] = EXE-1 OR parent in (EXE-1)","coma,seperated,list,of,fieldnames",0,100 )

 OR if you leave the Comma seperated list blank like the following it will pull in your user default lcolum settings:

=jira("project = EXE AND cf[10008] = EXE-1 OR parent in (EXE-1)",,0,100 )

so if you run the query in jira first select all desired columns under your column settings then run the query the desired result set will populate over.

Regards,
Earl

[Nadir Garouche]

Thank you, Earl. Yes, it's with the Jira Cloud for sheets add-on. I tried with your query and it gives an error:

Error: Value 'ASO-31' for the 'cf[10008]' field is not a valid number. (line 239).

Note: the Epic is not part of the same project but from another one. 

[Nadir Garouche]

In Jira, I have this search query and it runs fine. I want the same results but called from Google Spreadsheets

project = XX AND "Epic Link" = YYY-31