You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I'm pulling data from our Jira cloud instance and would like to filter my results to software project types only (i.e., not 'business' or 'service_desk').
Using Jira Cloud for Sheets, the following returns an error:
=jira("updated>=2023-09-01 AND project.projectTypeKey='software'"
Error: "Field 'projectTypeKey' does not exist or you do not have permission to view it."
(I get the same error in Jira proper when I use a JQL search.)
BUT, the following returns happily:
So I know it's not a permissions issue.
Can someone help me with the syntax for this?