query building with custom fields using JqlQueryBuilder

Question

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?

RambanamP · Accepted Answer

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();