@Override @RequiresXsrfCheck protected String doExecute() throws Exception { // Find all possibly affected issues. final List<GenericValue> associatedProjects = getConfigScheme().getAssociatedProjects(); if ((associatedProjects != null) && !associatedProjects.isEmpty()) { final List<Long> projectIds = GenericValueUtils.transformToLongIdsList(associatedProjects); final Collection<Option> obseleteOptions = CollectionUtils.subtract(getOriginalOptions(), getNewOptions()); if ((obseleteOptions != null) && !obseleteOptions.isEmpty()) { final List<String> obseleteOptionIds = new ArrayList<String>(obseleteOptions.size()); for (final Option option : obseleteOptions) { obseleteOptionIds.add(option.getId()); } final Query query = getQuery(projectIds, obseleteOptionIds); final SearchResults searchResults = searchProvider.search(query, getLoggedInUser(), PagerFilter.getUnlimitedFilter()); final List affectedIssues = searchResults.getIssues(); if ((affectedIssues != null) && !affectedIssues.isEmpty()) { // Prepare for Update configScheme = new FieldConfigScheme.Builder(getConfigScheme()) .setName(getName()) .setDescription(getDescription()) .toFieldConfigScheme(); final List<String> optionIds = new ArrayList<String>(Arrays.asList(getSelectedOptions())); return migrateIssues(this, affectedIssues, optionIds); } } } return super.doExecute(); }
private void _runSearch( final String query, final QueryType type, final User searcher, final int numberOfIssues, final String resolutionId) throws SearchException { final LuceneSearchProvider luceneSearchProvider = getSearchProvider(); // Create a search request final JqlClauseBuilder jqlQuery = JqlQueryBuilder.newBuilder().where().defaultAnd().resolution(resolutionId); switch (type) { case COMMENT: jqlQuery.comment(query); break; case ISSUE: jqlQuery.summary(query); break; } final SearchResults issues = luceneSearchProvider.search(jqlQuery.buildQuery(), searcher, new PagerFilter(-1)); assertNotNull(issues); assertEquals(query, numberOfIssues, issues.getTotal()); }
public void testNullQuery() throws SearchException { final LuceneSearchProvider luceneSearchProvider = getSearchProvider(); // Create a search request final SearchResults issues = luceneSearchProvider.search(null, bob, new PagerFilter(-1)); assertNotNull(issues); assertEquals(0, issues.getTotal()); }
public void testStandardQuery() throws SearchException { final LuceneSearchProvider luceneSearchProvider = getSearchProvider(); // Create a search request final QueryImpl query = new QueryImpl( new TerminalClauseImpl( "resolution", Operator.EQUALS, new SingleValueOperand(resolutionId))); final SearchResults issues = luceneSearchProvider.search(query, bob, new PagerFilter(-1)); assertNotNull(issues); assertEquals(3, issues.getTotal()); }
public static List<Issue> executeJQLQuery(String jqlQuery) { List<Issue> result = null; User user = ComponentManager.getInstance().getJiraAuthenticationContext().getLoggedInUser(); SearchService.ParseResult parseResult = searchService.parseQuery(user, jqlQuery); if (parseResult.isValid()) { Query query = parseResult.getQuery(); try { SearchResults results = searchService.search(user, query, PagerFilter.getUnlimitedFilter()); result = results.getIssues(); } catch (SearchException e) { log.error("Utils::search exception during executing JQL", e); } } return result; }
public void testComplexQueryWithSummaryAndComments() throws SearchException { final LuceneSearchProvider luceneSearchProvider = getSearchProvider(); // Create a search request JqlClauseBuilder jqlQuery = JqlQueryBuilder.newBuilder() .where() .resolution(resolutionId) .and() .sub() .comment(SUMMARY_BODY) .or() .summary(SUMMARY_BODY) .endsub(); final SearchResults issues = luceneSearchProvider.search(jqlQuery.buildQuery(), bob, new PagerFilter(-1)); assertNotNull(issues); assertEquals(2, issues.getTotal()); }
public static SearchResults newSearchResults(List<Issue> issues) { SearchResults searchResults = mock(SearchResults.class); when(searchResults.getIssues()).thenReturn(issues); return searchResults; }
@Override public Map<String, Object> getVelocityParameters( Issue issue, CustomField field, FieldLayoutItem fieldLayoutItem) { Map<String, Object> params = super.getVelocityParameters(issue, field, fieldLayoutItem); params.put("i18n", getI18nBean()); params.put("baseUrl", applicationProperties.getBaseUrl()); Long prId; if (field.isAllProjects()) { prId = Consts.PROJECT_ID_FOR_GLOBAL_CF; } else { if (issue == null) { return params; } prId = issue.getProjectObject().getId(); } String jqlData = qfMgr.getQueryFieldData(field.getIdAsLong(), prId); boolean addNull = qfMgr.getAddNull(field.getIdAsLong(), prId); boolean isAutocompleteView = qfMgr.isAutocompleteView(field.getIdAsLong(), prId); List<String> options = qfMgr.getLinkeFieldsOptions(field.getIdAsLong(), prId); params.put("isAutocompleteView", isAutocompleteView); params.put("prId", prId.toString()); String cfValue = field.getValueFromIssue(issue); if (Utils.isValidStr(cfValue)) { MutableIssue mi = issueMgr.getIssueObject(cfValue); if (mi != null && Utils.isValidStr(mi.getSummary())) { StringBuilder sb = new StringBuilder(); if (options.contains("status")) { sb.append(getI18nBean().getText("queryfields.opt.status")) .append(": ") .append(mi.getStatusObject().getName()); } if (options.contains("assignee") && mi.getAssigneeUser() != null) { if (sb.length() > 0) { sb.append(", "); } User aUser = mi.getAssigneeUser(); String encodedUser; try { encodedUser = URLEncoder.encode(aUser.getName(), "UTF-8"); } catch (UnsupportedEncodingException e) { // --> impossible encodedUser = aUser.getName(); } sb.append(getI18nBean().getText("queryfields.opt.assignee")) .append(": ") .append("<a class='user-hover' rel='") .append(aUser.getName()) .append("' id='issue_summary_assignee_'") .append(aUser.getName()) .append("' href='/secure/ViewProfile.jspa?name='") .append(encodedUser) .append("'>") .append(aUser.getDisplayName()) .append("</a>"); } if (options.contains("priority") && mi.getPriorityObject() != null) { if (sb.length() > 0) { sb.append(", "); } sb.append(getI18nBean().getText("queryfields.opt.priority")) .append(": ") .append(mi.getPriorityObject().getName()); } if (options.contains("due") && mi.getDueDate() != null) { if (sb.length() > 0) { sb.append(", "); } sb.append(getI18nBean().getText("queryfields.opt.due")) .append(": ") .append( ComponentAccessor.getJiraAuthenticationContext() .getOutlookDate() .format(mi.getDueDate())); } if (sb.length() > 0) { sb.insert(0, " ("); sb.append(")"); } IssueData issueData; if (options.contains("justDesc")) { String descr = mi.getDescription(); if (Utils.isValidStr(descr)) { issueData = new IssueData(descr, sb.toString()); } else { issueData = new IssueData(mi.getSummary(), sb.toString()); } } else if (options.contains("key")) { issueData = new IssueData(mi.getKey().concat(":").concat(mi.getSummary()), sb.toString()); } else { issueData = new IssueData(mi.getSummary(), sb.toString()); } params.put("fullValue", issueData); } } if (!Utils.isValidStr(jqlData)) { params.put("jqlNotSet", Boolean.TRUE); return params; } params.put("jqlNotSet", Boolean.FALSE); params.put("options", options); if (options.contains("editKey")) { params.put("hasKey", Boolean.TRUE); } User user = ComponentManager.getInstance().getJiraAuthenticationContext().getLoggedInUser(); SearchService.ParseResult parseResult = searchService.parseQuery(user, jqlData); if (parseResult.isValid()) { params.put("jqlNotValid", Boolean.FALSE); Query query = parseResult.getQuery(); try { Map<String, String> cfVals = new LinkedHashMap<String, String>(); SearchResults results = searchService.search(user, query, PagerFilter.getUnlimitedFilter()); List<Issue> issues = results.getIssues(); for (Issue i : issues) { String summary; if (options.contains("justDesc")) { String descr = i.getDescription(); if (Utils.isValidStr(descr)) { summary = descr; } else { summary = i.getSummary(); } } else if (options.contains("editKey")) { summary = i.getKey().concat(":").concat(i.getSummary()); } else { summary = i.getSummary(); } cfVals.put(i.getKey(), summary); } if (addNull) { cfVals.put("Empty", Consts.EMPTY_VALUE); } String selected = Consts.EMPTY_VALUE; String value = (String) issue.getCustomFieldValue(field); for (Map.Entry<String, String> cf : cfVals.entrySet()) { if (value != null && cf.getKey().equals(value)) { selected = value; break; } } if (isAutocompleteView) { Issue selectedIssue = issueMgr.getIssueObject(selected); if (selectedIssue != null) { params.put("selIssue", selectedIssue); } } else { if (selected.equals("")) { String defaultValue = (String) field.getDefaultValue(issue); if (defaultValue != null && defaultValue.length() > 0 && cfVals.keySet().contains(defaultValue)) { selected = defaultValue; } } if (cfVals != null && !cfVals.isEmpty() && selected.equals("")) { selected = cfVals.keySet().iterator().next(); } } params.put("selected", selected); params.put("isError", Boolean.FALSE); params.put("cfVals", cfVals); } catch (SearchException e) { params.put("isError", Boolean.TRUE); } } else { params.put("jqlNotValid", Boolean.TRUE); return params; } return params; }