Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Why can't I query a worklog field in Jira Cloud for Sheet ?


Hi there,

I am trying to query a worklog fields using Jira Cloud for sheet JIRA formula in google sheet and I'm facing an internal error.

I tried simple query like this :

=Jira("worklogDate >= 2020-04-24 AND worklogDate <= 2020-05-21";"Project,customfield_10008,issuetype,customfield_11852";0;5000)

and it worked like a charm but when I add any of this fields : "worklog.authorDisplayName,worklog.authorEmail,worklog.started,worklog.timeSpentSeconds" it crashed with an #ERROR "internal error preventing the function execution"

Anyone have any clue on why it doesn't worked ?

1 comment

I may add additional informations on why I am using a JIRA() google sheet formula and not the JQL with "Get issue from Jira" in the addon, because that way I can het all the data I need and it work as attended.

I am using JIRA() to be able to define the dates in a single place in my google sheets so I can do a single opération to refresh all my sheets based on the data collected from Jira.
I can't put any explanation on why worklog.authorDisplayName can be gathered through a JQL query but not with a JIRA() function.

I hope someone can help me on this.


Log in or Sign up to comment

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you