@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;
  }