How do I select on project.projectTypeKey in Jira or Jira Cloud for Sheets?

[Derek Boutang]

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'"
, "Summary,issuekey"
,0
,10)

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:

=jira("updated>=2023-09-01"
, "Summary,issuekey,project.projectTypeKey"
,0
,10)

So I know it's not a permissions issue. 

Can someone help me with the syntax for this?

[Alisa Zamaraeva · Accepted solution]

Hi @Derek Boutang 

Try using this: 

projectType = software

It worked for me in a JQL search. Hope this helps!

[Derek Boutang]

Yes, that worked for me. Thanks!