JQL Clause Builder API

[Batuhan Kandiran]

Hi everyone,

I want to fetch issue results of JQL below by using JIRA API

status was Open DURING ("2013/12/11","2013/12/16")

I tried

JqlQueryBuilder builder 	= JqlQueryBuilder.newBuilder();
	JqlClauseBuilder clauseBuilder 	= builder.where().status("Open").dueBetween("2013/12/11", "2013/12/16");
	Query query = clauseBuilder.buildQuery();
	List<Issue> query_returned_issues	= new ArrayList<Issue>();
	User user 				= ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser();
	SearchService searchService 		= ComponentAccessor.getComponentOfType(SearchService.class);
	try {
		SearchResults searchResults	= searchService.search(user, query, PagerFilter.getUnlimitedFilter());
		query_returned_issues		= searchResults.getIssues();
	} catch (SearchException e) {	e.printStackTrace();	}

but there is no luck :(

Could you help me, please ?

[rambabu patina · Accepted solution]

Hi Kandiran,

Try with this code below:

First in your class constructer initilize searchProvider as:

searchProvider = componentManager.getSearchProvider(); and

then,

SearchService searchService = ComponentAccessor.getComponentOfType(SearchService.class);

String jqlargument = "project = <project name> and issuetype = \"<Issue type>\"";

SearchService.ParseResult parseResult = searchService.parseQuery(user,jqlargument);

Query query = parseResult.getQuery();

try{

issues = searchProvider.search(query, user, PagerFilter.getUnlimitedFilter()).getIssues();

}catch(SearchException e){

System.out.println("Exception occured:"+e);

}

Hope this helps you,

Patina

[uuuu]

Hi, I'm trying to do something similar. Can you point me in the direction where I can get some examples of how to search issues using raw JQL?

[Batuhan Kandiran]

Thank you Patina,

I used your method by using raw JQL operation and it resolved my problem.