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

Need a help with a JQL query

Anmol Srivastava
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!
October 18, 2023

Hello,

can someone help me with a query in JSM to find all service requests where the “VCS SLA AdviseETA target” value is <24 hours from the issue creation date please?

 

Regards

1 answer

1 accepted

3 votes
Answer accepted
Deepak Jain
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 18, 2023

Hi @Anmol Srivastava ,

Thank you for connecting on community !!

For your case you can try below JQL:

project = ABC and issuetype = XYZ and "VCS SLA AdviseETA target" <= 24H

 

Regards,

Deepak

Anmol Srivastava
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!
October 18, 2023

Hello @Deepak Jain , thank you for the above.

Getting below error in the syntax when I have entered this:
project = VPS and issuetype = Service request and "VCS SLA AdviseETA target" <= 24H

 

ERROR: "Error in the JQL Query: Expecting either 'OR' or 'AND' but got 'request'. (line 1, character 63)"

What am I doing wrong here?

Deepak Jain
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 18, 2023

Hi @Anmol Srivastava ,

Can you try with below:

project = VPS and issuetype = "Service request" and "VCS SLA AdviseETA target" <= 24H

 

Regards,

Deepak

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events