Please help me to write JQLQuery

Question

Hello!
Please help me to write JQLQuery which will be equivalent to real-query :

project="PROJECT" AND issuetype = Bug AND status was in ("RESOLVED") before 2012-03-06

At this time I build JQLQuery

queryBuilder.where().project(PROJECT_ID).and().issueType("Bug").and().status(RESOLVED)

How I can realize part: before 2012-03-06 ?
Thanks!

2fcf0815-8d6d-48ae-8007-2d9a2c46401e · Answer

Thanks a lot for your answers!

MatthewC · Answer

Here's some sample code for a plugin I've just written that takes JQL string.  Easier than working our the train-carriage approach of building the query.

final UserUtil userUtil = ComponentManager.getInstance().getUserUtil(); 
            String serviceAccountName = "SERVICE_ACC_NAME";
            User serviceAccount = userUtil.getUser(serviceAccountName);

String jqlQuery ="projec;t="PROJECT" AND issuetype = Bug AND status was in ("RESOLVED") before 2012-03-06"

SearchService.ParseResult parseResult =  searchService.parseQuery(serviceAccount, jqlQuery);              
            assert parseResult.isValid() : "Invalid JQL, can't parse: " + jqlQuery;

final SearchResults results = searchService.search(serviceAccount, parseResult.getQuery(), PagerFilter.getUnlimitedFilter());
            List<Issue> issueList = results.getIssues();

Jobin Kuruvilla [Adaptavist] · Answer

Try lt (less than) operator for before.

http://docs.atlassian.com/jira/latest/com/atlassian/jira/jql/builder/ConditionBuilder.html#lt(java.lang.String)

Alternatively, you can write the query as a String a parse it to a Query object.