code: @Override
     protected ResultSet findChildPropertiesByParentIdentifierCQ(String parentCid, List<QPathEntryFilter> pattern)
        throws SQLException
     {
        if (pattern.isEmpty())
        {
           throw new SQLException("Pattern list is empty.");
        }
        else
        {
           if (findPropertiesByParentIdAndComplexPatternCQ == null)
           {
              findPropertiesByParentIdAndComplexPatternCQ = dbConnection.createStatement();
           }
           //create query from list
           StringBuilder query = new StringBuilder(FIND_PROPERTIES_BY_PARENTID_AND_PATTERN_CQ_TEMPLATE);
           query.append(" where I.I_CLASS=2 and I.CONTAINER_NAME='");
           query.append(this.containerConfig.containerName);
           query.append("' and I.PARENT_ID='");
           query.append(parentCid);
           query.append("' and ( ");
           appendPattern(query, pattern.get(0).getQPathEntry(), false);
           for (int i = 1; i < pattern.size(); i++)
           {
              query.append(" or ");
              appendPattern(query, pattern.get(i).getQPathEntry(), false);
           }
           query.append(" ) order by I.NAME");
  
           return findPropertiesByParentIdAndComplexPatternCQ.executeQuery(query.toString());
        }
     }
docs: {@inheritDoc}