query building with custom fields using JqlQueryBuilder

srinivasp
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 19, 2013

I have an existing builder as follows which is working in JIRA retriving issues.

JqlQueryBuilder builder = JqlQueryBuilder.newBuilder();
builder.where().and().assigneeUser(user.getName());
builder.where().or().reporterUser(user.getName());

I have a custom field(id is 10000) that stores user object. Now I want to add this custom field to the builder object which is similar to assignee, reporter using or operator. How can i do that?

1 answer

1 accepted

0 votes
Answer accepted
RambanamP
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 19, 2013

try with this code

CustomField cf = customFieldManager.getCustomFieldObjectByName("CustomField Name");	
User cfValue=(User)issue.getCustomFieldValue(cf );	
JqlClauseBuilder builder = JqlQueryBuilder.newClauseBuilder();
Query query = builder.customField(cf.getIdAsLong()).eq(cfValue.getName()).buildQuery();
SearchProvider searchProvider = ComponentAccessor.getComponentOfType(SearchProvider.class);
SearchResults searchResults = searchProvider.search(query, ComponentAccessor.getJiraAuthenticationContext().getLoggedInUser(),PagerFilter.getUnlimitedFilter());
List<Issue> issues = searchResults.getIssues();

srinivasp
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 20, 2013

Thank you Prasad. With minor changes to your code, I am able to add JqlClauseBuilder to my JqlQueryBuilder object.

Suggest an answer

Log in or Sign up to answer