nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Jira Google Sheets Plugin - how to handle spaces in JQL of JIRA() function

Edwin Meijer

I want to run this JQL query using a JIRA() function in a Google Sheet:

project=JEDI AND issuetype="technical task"

I have tried unsuccessfully:

JIRA("project=JEDI and issuetype=technical task", "story points", 0,100)

JIRA("project=JEDI and issuetype=\"technical task\"", "story points", 0,100)

Question: what is the grammar when you have spaces in the JQL ?

Note: the JIRA() function is able to handle spaces in column names like "story points"!

Accepted answers

Dario B

Hello @Edwin Meijer ,

In order to be able to use composed properties names (multiple words separated by spaces) in the =JIRA() function you have to surround them with single quotes as shown in below screenshot:

So, in your case:

=JIRA("project=JEDI AND issuetype='technical task'")

Cheers,
Dario

All comments

Dario B

Hello @Edwin Meijer ,

In order to be able to use composed properties names (multiple words separated by spaces) in the =JIRA() function you have to surround them with single quotes as shown in below screenshot:

So, in your case:

=JIRA("project=JEDI AND issuetype='technical task'")

Cheers,
Dario

Edwin Meijer

Awesome - thanks for the quick response

Dario B

You are very welcome @Edwin Meijer !

I will ask to have this documented in the page: Use Jira Cloud for Sheets

Have a nice weekend!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

cloud

jira-software

jira-software-cloud

jql

google