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

JQL query with and or condition

Subhajit Bhuiya

I want to create jql query inside my java jira plugin. Query is something like this

Give me all issue where project is "x" and(

title is "y" or

summary is "y" or

key is "y" or

id is "y"

)

So, 1st 1 and condition and then all or condition.

Accepted answers

Nir Haimov

Hi @Subhajit Bhuiya

title and summary are the same fields...

key and id are the same fields...

Summary is a free text field, in all free text field you can search only by ~

for example: summary ~ "test"

will find you all the tasks that their summary include the word "test"

So, for you question,

project = x AND (summary ~ "something" OR issuekey = XX-123)

All comments

Subhajit Bhuiya

@Nir Haimov any suggestion from your side?

Nir Haimov

Hi @Subhajit Bhuiya

title and summary are the same fields...

key and id are the same fields...

Summary is a free text field, in all free text field you can search only by ~

for example: summary ~ "test"

will find you all the tasks that their summary include the word "test"

So, for you question,

project = x AND (summary ~ "something" OR issuekey = XX-123)

Subhajit Bhuiya

@Nir Haimov I am trying to do it from java code. I have done this ->

JqlQueryBuilder queryBuilder = JqlQueryBuilder.newBuilder();
Query query = queryBuilder.where().project(Long.parseLong(projectKeyString)).and().summary(searchText).buildQuery();

But I need to put an or condition for summary, id, name and description. How to do it I am not find. it should project(). and(summery.or( title).or(id).or(name). Something like that

Nir Haimov

I use jql in java differently:

import com.atlassian.jira.bc.issue.search.SearchService;
import com.atlassian.jira.issue.Issue;
import com.atlassian.jira.issue.search.SearchException;
import com.atlassian.jira.issue.search.SearchResults;
import com.atlassian.jira.security.JiraAuthenticationContext;
import com.atlassian.jira.user.ApplicationUser;
import com.atlassian.jira.web.bean.PagerFilter;
import com.atlassian.plugin.spring.scanner.annotation.imports.ComponentImport;
import com.google.common.base.Throwables;
import com.wikistrat.jira.logic.PsProjectService;
import org.apache.log4j.Logger;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;

import java.util.List;

@Component
public class MyClass {
private static final Logger logger = Logger.getLogger(PsProjectService.class);
private final SearchService searchService;
private final JiraAuthenticationContext authenticationContext;

@Autowired
    public MyClass(@ComponentImport SearchService searchService,
@ComponentImport JiraAuthenticationContext authenticationContext) {
this.searchService = searchService;
this.authenticationContext = authenticationContext;
    }

    String query = String.format("project = %s and resolution is EMPTY and issuetype in (Epic)", projectKey);

    List<Issue> issues = findByJql(query);

public List<Issue> findByJql(String jql) {
        ApplicationUser applicationUser = authenticationContext.getLoggedInUser();
return getSelectedIssues(applicationUser, jql);
    }

public List<Issue> getSelectedIssues(ApplicationUser applicationUser, String jql) {
        SearchService.ParseResult parseResult = searchService.parseQuery(applicationUser, jql);

        SearchResults searchResults;

try {
            searchResults = searchService.search(applicationUser, parseResult.getQuery(), PagerFilter.getUnlimitedFilter());
        } catch (SearchException ex) {
throw Throwables.propagate(ex);
        }

return searchResults.getIssues();
    }
}

Look at my "query", it looks exactly like regular jql.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira