1 package de.webman.content.workflow.db.queries.postgresql; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 6 10 public class VersionStatusFiltersGetAll extends TKPrepQuery { 11 12 public final static boolean IS_PREPARED = true; 13 14 public final static String [] PARAM_ORDER = null; 15 16 public final static Object [][] PARAM_TYPES = null; 17 18 21 public final static boolean[] SET_RELEVANTS = { true }; 22 23 26 public final static String SQL_STRING = 27 "SELECT FR.STATUS_ID, FR.RULE_TYPE, SF.* FROM VERSION_STATUS_FILTER_RULE FR RIGHT JOIN VERSION_STATUS_FILTER SF " + 28 "ON (FR.FILTER_ID = SF.FILTER_ID) " + 29 " ORDER BY FR.FILTER_ID"; 30 31 public void initQuery(Connection con) { 32 super.initQuery( 33 con, 34 IS_PREPARED, 35 PARAM_ORDER, 36 PARAM_TYPES, 37 SET_RELEVANTS, 38 SQL_STRING ); 39 } 40 } 41 | Popular Tags |