01: package de.webman.content.workflow.db.queries;
02:
03: import com.teamkonzept.db.*;
04: import java.sql.*;
05:
06: /**
07: * @author $Author: doehling $
08: * @version $Revision: 1.2 $
09: */
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: public final static boolean[] SET_RELEVANTS = { true };
19:
20: public final static String SQL_STRING = "SELECT FR.STATUS_ID, FR.RULE_TYPE, SF.* FROM VERSION_STATUS_FILTER_RULE FR, VERSION_STATUS_FILTER SF "
21: + "WHERE "
22: + DBStringFactory.rightOuterJoin("FR.FILTER_ID",
23: "SF.FILTER_ID") + " ORDER BY FR.FILTER_ID";
24:
25: public void initQuery(Connection con) {
26: super.initQuery(con, IS_PREPARED, PARAM_ORDER, PARAM_TYPES,
27: SET_RELEVANTS, SQL_STRING);
28: }
29: }
|