Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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 Champion
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 Champion
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