I'm hoping to transpose a Jira Epic and Issue into google sheets, but having trouble with the syntax translation into Google Sheets. The sample formula gives:
JIRA("project = MYPROJ order by created desc", "issuekey, summary, status, assignee, created", 0, 10)
But I need to import an epic and subtasks as well. When I try using JQL, the spreadsheet throws an error. For Example:
JIRA("project = MYPROJ "Epic Link"=XXXX-4404 OR (issuetype = sub-task AND "parentEpic" IN (XXXX-4404))", "issuekey, summary, status, assignee, created", 0, 10)
Has anyone come across a similar situation? Google sheets doesn't seem to like the quote marks around "Epic Link", but I'm not sure if there's another way to call what I'm looking for. Any help is appreciated, thanks!
Hi Riley,
Wow, thank you so much for the incredibly fast answer! I tried that, and now it's throwing a new error:
"Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'Epic Link'. (line 1, character 18)"
Any thoughts? Thank you so much for your help!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry for my mistake, "project = MYPROJ AND 'Epic Link'=XXXX-4404.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Amazing, that worked! Much appreciated, here's the full query for anyone who needs it:
=JIRA("project = MYPROJ AND 'Epic Link'=XXXX-4404 OR (issuetype = sub-task AND 'parentEpic' IN (XXXX-4404))", "issuekey, summary, status, assignee, created", 0, 10)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.