1 package com.teamkonzept.webman.mainint.db.queries.oracle; 2 3 import com.teamkonzept.db.*; 4 import java.sql.*; 5 import com.teamkonzept.lib.templates.*; 6 7 21 public class TKDBGetAllNodeContentVersions extends TKUnprepQuery 22 { 23 24 public final static Object [][] PARAMTYPES = 25 { {"SEARCH", new Integer (Types.VARCHAR)}, 26 {"SEARCH_UNC", new Integer (Types.VARCHAR)} }; 27 28 public final static boolean[] SET_RELEVANTS = 29 { true }; 30 31 32 public final static String SQL_STRING = 33 "SELECT " + 34 " CV.VERSION_ID, CV.INSTANCE_ID, CI.CONTENT_NODE_ID, CV.CONTENT_ID, CV.STATUS_ID, CV.VERSION_DATE, CV.AUTHOR, CV.INFO, VS.STATUS, " + 35 " CT.CONTENT_NODE_NAME, CT2.CONTENT_NODE_TYPE AS PARENT_TYPE,CT.CONTENT_NODE_PARENT, CT.CONTENT_NODE_SHORTNAME, CT.CONTENT_FORM, CT.CONTENT_NODE_TYPE, CI.NAME " + 36 "FROM " + 37 " CONTENT C,<TK_CASE:KENNUNG> CONTENT_VALUE CVALUE,</TK_CASE> CONTENT_TREE CT, CONTENT_TREE CT2, CONTENT_VERSION CV, VERSION_STATUS VS, CONTENT_INSTANCE CI " + 38 "WHERE " + 39 " ( CT.CONTENT_NODE_PARENT = <TK_CONTENT_NODE_ID> OR " + 40 " CT.CONTENT_NODE_ID = <TK_CONTENT_NODE_ID> " + 41 " ) AND " + 42 43 " CI.CONTENT_NODE_ID = CT.CONTENT_NODE_ID AND " + 44 " CV.INSTANCE_ID = CI.INSTANCE_ID AND " + 45 " C.CONTENT_ID = CV.CONTENT_ID AND " + 46 " CV.STATUS_ID = VS.STATUS_ID AND " + 47 " CT2.CONTENT_NODE_ID = CT.CONTENT_NODE_PARENT " + 48 49 " <TK_CASE:KENNUNG> AND " + 50 " CVALUE.CONTENT_ID = CV.CONTENT_ID " + 51 " <TK_IF:KENNUNG=0> " + 52 " AND (<TK_LIST:SEARCH_STRING>(DBMS_LOB.INSTR(CVALUE.VALUE, <TK:SEARCH_UNC>) > 0) <TK:CONN> </TK_LIST>) " + 53 " </TK_IF:KENNUNG=0> " + 54 " <TK_IF:KENNUNG=1> " + 55 " AND " + 56 " ((<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_NAME LIKE <TK:SEARCH> ESCAPE '\\' ) <TK:CONN> </TK_LIST>) " + 57 " OR " + 58 " (<TK_LIST:SEARCH_STRING>(CT.CONTENT_NODE_SHORTNAME LIKE <TK:SEARCH> ESCAPE '\\' ) <TK:CONN> </TK_LIST>)) " + 59 " </TK_IF> " + 60 " </TK_CASE> " + 61 62 "ORDER BY " + 63 "CV.INSTANCE_ID, CV.CONTENT_ID, CV.VERSION_ID "; 64 65 66 public static TKTemplateSyntax sqlTmplSyntax; 67 68 public void initQuery(Connection con) 69 { 70 try 71 { 72 sqlTmplSyntax = new TKTemplateSyntax(SQL_STRING,""); 73 } 74 catch(com.teamkonzept.lib.TKTemplateSyntaxException e) 75 { 76 sqlString = SQL_STRING; } 78 79 super.initQuery( 80 con, 81 PARAMTYPES, 82 SET_RELEVANTS, 83 sqlTmplSyntax ); 84 } 85 } 86 | Popular Tags |