Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Custom JQL query for multiple Reporters in Smartsheet connector

Tanika Z
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
May 7, 2024

Hi, I am trying to set up a Smartsheet connecter with my org's Jira to list any tickets created by my team members. The Reporter format would either be an email address or by last name, first name. I am trying to set it up but any time I try to enter more than 1 Reporter I get an error similar to: Invalid JQL. {"errorMessages":["Error in the JQL Query: Expecting ')' but got '('. (line 1, character 102)"],"errors":{}}

 

I am not at all familiar with JQL and have tried with my basic understanding to apply the same rules and principles I'm seeing to enter more than 1 name. I also counted to the character specified in the error above and changed to ( "as expected" but this didn't work and I don't see the logic in it anyways.

 

Full JQL:
project in ('PROJ1', 'PROJ2', 'PROJ3') and (reporter = 'last name, first name1') order by id

 

This works:

(reporter = 'last name, first name1')

(reporter = 'name@test.com')

 

Anything more than 1 doesn't:

(reporter = 'last name, first name1', 'last name, first name2')

(reporter = 'last name, first name1' OR 'last name, first name2')

(reporter = 'name1@test.com', 'name2@test.com', 'name3@test.com')

 

Is it even possible to do this? 

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
atlassian, team '25, conference, certifications, bootcamps, training experience, anaheim ca,

Want to make the most of Team ‘25?

Spend the day sharpening your skills in Atlassian Cloud Organization Admin or Jira Administration, then take the exam onsite. Already ready? Take one - or more - of 12 different certification exams while you’re in Anaheim at Team' 25.

Learn more
AUG Leaders

Upcoming Jira Events