@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(); }
public void testSearchAndSortForPagerConstraints() throws SearchException, IOException { final LuceneSearchProvider luceneSearchProvider = getSearchProvider(); // Create a search request Query jqlQuery = JqlQueryBuilder.newBuilder() .where() .resolution(resolutionId) .and() .summary(SUMMARY_BODY) .buildQuery(); final MyDocumentHitCollector hitCollector = new MyDocumentHitCollector(null); // Test that we limit the results with a max on the filter luceneSearchProvider.searchAndSort(jqlQuery, bob, hitCollector, new PagerFilter(1)); assertEquals(1, hitCollector.count); hitCollector.clearCount(); // Test that we bring them all back with a max of 2 luceneSearchProvider.searchAndSort(jqlQuery, bob, hitCollector, new PagerFilter(2)); assertEquals(2, hitCollector.count); hitCollector.clearCount(); // Test the start and end final PagerFilter filter = new PagerFilter(2); filter.setStart(1); luceneSearchProvider.searchAndSort(jqlQuery, bob, hitCollector, filter); assertEquals(1, hitCollector.count); hitCollector.clearCount(); // Bring them all back luceneSearchProvider.searchAndSort( jqlQuery, bob, hitCollector, PagerFilter.getUnlimitedFilter()); assertEquals(2, hitCollector.count); }
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; }
@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; }