Untitled

 avatar
unknown
plain_text
2 months ago
1.0 kB
2
Indexable
for (final String filterTableName : FILTER_TABLE_NAMES) {
    final String query = "SELECT ID AS id, REQCONTENT AS jql, FILTERNAME as filterName, USERNAME as userKey FROM " + filterTableName;
    final Statement statement = connection.createStatement();
    final ResultSet rset = statement.executeQuery(query);
    while (rset.next()) {
        final String jql = rset.getString("jql");
        if (isJqlValid(jql)) {
            if (isJqlHasErrors(jql)) {
                final int filterId = rset.getInt("id");
                final JqlInfosModel model = new JqlInfosModel(filterId, FILTER, rset.getString("filterName"), jql, rset.getString("userKey"), getFilterUrl(filterId));
                result.add(model);
            }
        } else {
            final int filterId = rset.getInt("id");
            final JqlInfosModel model = new JqlInfosModel(filterId, FILTER, rset.getString("filterName"), jql, rset.getString("userKey"), getFilterUrl(filterId));
            result.add(model);
        }
    }
}
Editor is loading...
Leave a Comment