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 = '')


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 = '', '', '')


Is it even possible to do this? 

0 answers

Suggest an answer

Log in or Sign up to answer