How to use readDistinctValuesByCriteria method of org.cerberus.crud.dao.impl.CountryEnvParam_logDAO class

Best Cerberus-source code snippet using org.cerberus.crud.dao.impl.CountryEnvParam_logDAO.readDistinctValuesByCriteria

Source:CountryEnvParam_logDAO.java

...523        String Creator = resultSet.getString("Creator") == null ? "" : resultSet.getString("Creator");524        return factoryCountryEnvParamLog.create(id, system, country, environment, build, revision, chain, description, datecre, Creator);525    }526    @Override527    public AnswerList<String> readDistinctValuesByCriteria(String system, String searchTerm, Map<String, List<String>> individualSearch, String columnName) {528        AnswerList<String> answer = new AnswerList<>();529        MessageEvent msg = new MessageEvent(MessageEventEnum.DATA_OPERATION_ERROR_UNEXPECTED);530        msg.setDescription(msg.getDescription().replace("%DESCRIPTION%", ""));531        List<String> distinctValues = new ArrayList<>();532        StringBuilder searchSQL = new StringBuilder();533        List<String> individalColumnSearchValues = new ArrayList<>();534        StringBuilder query = new StringBuilder();535        query.append("SELECT distinct ");536        query.append(columnName);537        query.append(" as distinctValues FROM countryenvparam_log ");538        searchSQL.append("WHERE 1=1");539        if (!StringUtil.isNullOrEmpty(system)) {540            searchSQL.append(" and (`System` = ? )");541        }...

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.