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; } } }

400 400: {"errorMessages":["Error in the JQL Query: Expecting ')' before the end of the query."],"er

Abhijeet Arewar

Below is my jql query -->

labels in (security, Security, security-automated, Security-automated, security-library, security-external, Security-Library, Security-Sast, security-sast, pentest, Pentest, external-customer, External-Customer, appsec, AppSec, Appsec, security-researcher, security-customer, psg-crypto) AND issuekey not in (1218809, 1207609, DRPVG-596, 1258291) AND project not in ("Delete Me") AND issuetype not in (Test, "Test Execution", "Test Folder", "Test Plan") AND (affectedVersion in releasedVersions() AND status != Closed OR affectedVersion in unreleasedVersions() AND Severity in ("1 - Severe", "2 - High") AND status != Closed) AND issuetype = Bug AND project = DRSMX AND component in (CMDB, "Smart IT", "Service Level Management (SLM)", ITSM, ITSM_RKM, SLM, SRM, Platform) AND labels in (Security-Library, security-library, library-automated) AND Severity in ("1 - Severe", "2 - High") AND labels not in (E-case) ORDER BY Severity ASC

It works on UI but when i do it from API it fails to retrieve.

Comments

Abhijeet Arewar

@Warren Could you please help here?

Warren_mz9b4z

Hi @Abhijeet Arewar

Firstly, your query could be simplified quite a bit - you have a section which states project not in and issuetype not in, but then further down you have project=DRSMX and issuetype=Bug which overrides the earlier statements. You also have 2 sets of labels= with duplicate values.

What would be useful is for you to show the actual API call that you're passing in - this error looks as though you have something wrong with the syntax, probably missing quotes. Let me see the code you're using to build the API call

Abhijeet Arewar

@Warren Actaully i am using maven dependency where i am calling jiraClient.searchIssues(JQLquery) while passing JQLquery to this function then i am getting above error

Warren_mz9b4z

@Abhijeet Arewar

My Jira instance doesn't have many of the fields or parameters that your system does, so I can't even vaguely get it working in my UI

If you're saying that the JQL works in your UI, then the best I can offer is to slowly build the JQL up and see where it goes wrong. So, start with

labels in (security, Security, security-automated, Security-automated, security-library, security-external, Security-Library, Security-Sast, security-sast, pentest, Pentest, external-customer, External-Customer, appsec, AppSec, Appsec, security-researcher, security-customer, psg-crypto)

If it doesn't work, you know there's something wrong with the first bit.

If that works, add AND issuekey not in (1218809, 1207609, DRPVG-596, 1258291) and try again.

Keep adding bits until something goes wrong.

Don't worry about whether what's being returned makes sense or not, it's just to build up the JQL and work out where the error is creeping in.