ProcessFilterBuilderDODS.java :  » Workflow-Engines » shark » org » enhydra » shark » Java Open Source

Java Open Source » Workflow Engines » shark 
shark » org » enhydra » shark » ProcessFilterBuilderDODS.java
package org.enhydra.shark;

import java.util.Properties;

import org.enhydra.shark.api.client.wfmc.wapi.WMFilter;
import org.enhydra.shark.api.client.wfmc.wapi.WMSessionHandle;
import org.enhydra.shark.api.client.wfservice.NotConnected;
import org.enhydra.shark.api.common.ProcessFilterBuilder;
import org.enhydra.shark.api.common.SharkConstants;
import org.enhydra.shark.utilities.MiscUtilities;

/**
 * @author V.Puskas
 * @version 0.21
 */
public class ProcessFilterBuilderDODS extends BasicFilterBuilder implements
                                                                ProcessFilterBuilder {

   private static final String sqlProcDefName = " PDefName ";

   private static final String sqlId = " Id ";

   private static final String sqlName = " Name ";

   private static final String sqlState = " State ";

   private static final String sqlPriority = " Priority ";

   private static final String sqlCreated = " Created ";

   private static final String sqlStarted = " Started ";

   private static final String sqlLastStateTime = " LastStateTime ";

   private static final String sqlLimitTime = " LimitTime ";

   private static final String sqlResourceRequesterId = " ResourceRequesterId ";

   private static final String sqlPackageId = " PackageId ";

   private static final String sqlProcessDefinitionId = " ProcessDefinitionId ";

   private static final String sqlProcessDefinitionVersion = " ProcessDefinitionVersion ";

   private static final String sqlUsername = " Username ";

   private static final String sqlDescription = " Description ";

   private static ProcessFilterBuilder anInstance;

   private ProcessFilterBuilderDODS(Properties p) {
      super(p);
   }

   public static ProcessFilterBuilder getInstance() {
      if (null == anInstance) {
         synchronized (ProcessFilterBuilderDODS.class) {
            if (null == anInstance) {
               Properties props = new Properties();
               try {
                  props = MiscUtilities.convertNameValueArrayToProperties(Shark.getInstance()
                     .getProperties());
               } catch (Exception ex) {
               }

               anInstance = new ProcessFilterBuilderDODS(props);
            }
         }
      }
      return anInstance;
   }

   public WMFilter addPackageIdEquals(WMSessionHandle shandle, String exp)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addPackageIdEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addPackageIdEquals", null);

         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_MGR_PACKAGE_ID,
                                      " ProcessDefinition ",
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessDefinitions WHERE "+getSQLUpperCaseIfNeccessary(sqlPackageId)+ " = ",
                                      exp,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addPackageIdEquals",
                       this);
      }
   }

   public WMFilter addProcessDefIdEquals(WMSessionHandle shandle, String exp)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addProcessDefIdEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addProcessDefIdEquals", null);
         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_MGR_PROCESS_DEFINITION_ID,
                                      " ProcessDefinition ",
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessDefinitions WHERE "+getSQLUpperCaseIfNeccessary(sqlProcessDefinitionId)+" = ",
                                      exp,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addProcessDefIdEquals",
                       this);
      }
   }

   public WMFilter addMgrNameEquals(WMSessionHandle shandle, String exp) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addMgrNameEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addMgrNameEquals", null);
         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_MGR_NAME,
                                      " ProcessDefinition ",
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessDefinitions WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" = ",
                                      exp,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addMgrNameEquals", this);
      }
   }

   public WMFilter addVersionEquals(WMSessionHandle shandle, String exp) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVersionEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVersionEquals", null);
         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_MGR_VERSION,
                                      " ProcessDefinition ",
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessDefinitions WHERE "+sqlProcessDefinitionVersion+" = ",
                                      exp,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addVersionEquals", this);
      }
   }

   public WMFilter addIsMgrEnabled(WMSessionHandle shandle) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addIsMgrEnabled");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addIsMgrEnabled", null);
         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_MGR_ENABLED,
                                      " ProcessDefinition ",
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessDefinitions WHERE "+sqlState+" = ",
                                      "0",
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addIsMgrEnabled", this);
      }
   }

   public WMFilter addStateEquals(WMSessionHandle shandle, String arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addStateEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addStateEquals", null);
         return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_STATE,
                                      sqlState,
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessStates WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" = ",
                                      arg,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addStateEquals", this);
      }
   }

   public WMFilter addStateStartsWith(WMSessionHandle shandle, String arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addStateStartsWith");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addStateStartsWith", null);
         return addStartsWithSubQuery(SQL_TYPE_PROCESS,
                                      SharkConstants.PROC_STATE,
                                      sqlState,
                                      "IN (SELECT "
                                            + objectid_column_name
                                            + " FROM SHKProcessStates WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" LIKE ",
                                      arg,
                                      ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addStateStartsWith",
                       this);
      }
   }

   public WMFilter addIdEquals(WMSessionHandle shandle, String arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addIdEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addIdEquals", null);
         return addEquals(SQL_TYPE_PROCESS, SharkConstants.PROC_KEY, sqlId, arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addIdEquals", this);
      }
   }

   public WMFilter addNameEquals(WMSessionHandle shandle, String arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addNameEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addNameEquals", null);
         return addEquals(SQL_TYPE_PROCESS, SharkConstants.PROC_NAME, sqlName, arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addNameEquals", this);
      }
   }

   public WMFilter addNameContains(WMSessionHandle shandle, String arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addNameContains");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addNameContains", null);
         return addContains(SQL_TYPE_PROCESS, SharkConstants.PROC_NAME, sqlName, arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addNameContains", this);
      }
   }

   public WMFilter addPriorityEquals(WMSessionHandle shandle, int arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addPriorityEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addPriorityEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_PRIORITY,
                          sqlPriority,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addPriorityEquals",
                       this);
      }
   }

   public WMFilter addPriorityLessThan(WMSessionHandle shandle, int arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addPriorityLessThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addPriorityLessThan", null);
         return addLessThan(SQL_TYPE_PROCESS,
                            SharkConstants.PROC_PRIORITY,
                            sqlPriority,
                            arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addPriorityLessThan",
                       this);
      }
   }

   public WMFilter addPriorityGreaterThan(WMSessionHandle shandle, int arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addPriorityGreaterThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addPriorityGreaterThan", null);
         return addGreaterThan(SQL_TYPE_PROCESS,
                               SharkConstants.PROC_PRIORITY,
                               sqlPriority,
                               arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.addGreaterThan", this);
      }
   }

   public WMFilter addDescriptionEquals(WMSessionHandle shandle, String arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addDescriptionEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addDescriptionEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_DESCRIPTION,
                          sqlDescription,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addDescriptionEquals",
                       this);
      }
   }

   public WMFilter addDescriptionContains(WMSessionHandle shandle, String arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addDescriptionContains");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addDescriptionContains", null);
         return addContains(SQL_TYPE_PROCESS,
                            SharkConstants.PROC_DESCRIPTION,
                            sqlDescription,
                            arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addDescriptionContains",
                       this);
      }
   }

   public WMFilter addRequesterIdEquals(WMSessionHandle shandle, String arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addRequesterIdEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addRequesterIdEquals", null);
         return addEqualsWithSubQueryTwice(SQL_TYPE_PROCESS,
                                           SharkConstants.PROC_REQUESTER_ID,
                                           sqlId,
                                           "IN (SELECT Id FROM SHKProcessRequesters WHERE ActivityRequester IN (SELECT "
                                                 + objectid_column_name
                                                 + "FROM SHKActivities WHERE "+getSQLUpperCaseIfNeccessary(sqlId)+" = ",
                                           arg,
                                           ") OR ResourceRequester IN (SELECT "
                                                 + objectid_column_name
                                                 + "FROM SHKResourcesTable WHERE "+getSQLUpperCaseIfNeccessary(sqlUsername)+" = ",
                                           ")) ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addRequesterIdEquals",
                       this);
      }
   }

   public WMFilter addRequesterUsernameEquals(WMSessionHandle shandle, String arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addRequesterUsernameEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addRequesterUsernameEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_REQUESTER_RESOURCE,
                          sqlResourceRequesterId,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addRequesterUsernameEquals",
                       this);
      }
   }

   public WMFilter addCreatedTimeEquals(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addCreatedTimeEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addCreatedTimeEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_CREATED_TIME_MS,
                          sqlCreated,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addCreatedTimeEquals",
                       this);
      }
   }

   public WMFilter addCreatedTimeBefore(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addCreatedTimeBefore");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addCreatedTimeBefore", null);
         return addLessThan(SQL_TYPE_PROCESS,
                            SharkConstants.PROC_CREATED_TIME_MS,
                            sqlCreated,
                            arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addCreatedTimeBefore",
                       this);
      }
   }

   public WMFilter addCreatedTimeAfter(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addCreatedTimeAfter");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addCreatedTimeAfter", null);
         return addGreaterThan(SQL_TYPE_PROCESS,
                               SharkConstants.PROC_START_TIME_MS,
                               sqlCreated,
                               arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addCreatedTimeAfter",
                       this);
      }
   }

   public WMFilter addStartTimeEquals(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addStartTimeEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addStartTimeEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_START_TIME_MS,
                          sqlStarted,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addStartTimeEquals",
                       this);
      }
   }

   public WMFilter addStartTimeBefore(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addStartTimeBefore");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addStartTimeBefore", null);
         WMFilter f = addLessThan(SQL_TYPE_PROCESS,
                                  SharkConstants.PROC_START_TIME_MS,
                                  sqlStarted,
                                  arg);
         WMFilter f2 = addEquals(SQL_TYPE_PROCESS,
                                 SharkConstants.PROC_START_TIME_MS,
                                 sqlStarted,
                                 SharkConstants.UNDEFINED_TIME);
         f2 = not(shandle, f2);
         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addStartTimeBefore",
                       this);
      }
   }

   public WMFilter addStartTimeAfter(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addStartTimeAfter");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addStartTimeAfter", null);
         WMFilter f = addGreaterThan(SQL_TYPE_PROCESS,
                                     SharkConstants.PROC_START_TIME_MS,
                                     sqlStarted,
                                     arg);
         WMFilter f2 = addEquals(SQL_TYPE_PROCESS,
                                 SharkConstants.PROC_START_TIME_MS,
                                 sqlStarted,
                                 SharkConstants.UNDEFINED_TIME);
         f2 = not(shandle, f2);
         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addStartTimeAfter",
                       this);
      }
   }

   public WMFilter addLastStateTimeEquals(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLastStateTimeEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLastStateTimeEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_LAST_STATE_TIME_MS,
                          sqlLastStateTime,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLastStateTimeEquals",
                       this);
      }
   }

   public WMFilter addLastStateTimeBefore(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLastStateTimeBefore");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLastStateTimeBefore", null);
         return addLessThan(SQL_TYPE_PROCESS,
                            SharkConstants.PROC_LAST_STATE_TIME_MS,
                            sqlLastStateTime,
                            arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLastStateTimeBefore",
                       this);
      }
   }

   public WMFilter addLastStateTimeAfter(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLastStateTimeAfter");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLastStateTimeAfter", null);
         return addGreaterThan(SQL_TYPE_PROCESS,
                               SharkConstants.PROC_LAST_STATE_TIME_MS,
                               sqlLastStateTime,
                               arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLastStateTimeAfter",
                       this);
      }
   }

   public WMFilter addFinishTimeEquals(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addFinishTimeEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addFinishTimeEquals", null);
         WMFilter f = addEquals(SQL_TYPE_PROCESS,
                                SharkConstants.PROC_LAST_STATE_TIME_MS,
                                sqlLastStateTime,
                                arg);
         WMFilter f2 = addStartsWithSubQuery(SQL_TYPE_PROCESS,
                                             SharkConstants.PROC_STATE,
                                             sqlState,
                                             "IN (SELECT "
                                                   + objectid_column_name
                                                   + " FROM SHKProcessStates WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" LIKE ",
                                             SharkConstants.STATEPREFIX_CLOSED,
                                             ") ");

         f = and(shandle, f, f2);
         return f;

      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLastStateTimeEquals",
                       this);
      }
   }

   public WMFilter addFinishTimeBefore(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addFinishTimeBefore");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addFinishTimeBefore", null);
         WMFilter f = addLessThan(SQL_TYPE_PROCESS,
                                  SharkConstants.PROC_LAST_STATE_TIME_MS,
                                  sqlLastStateTime,
                                  arg);
         WMFilter f2 = addStartsWithSubQuery(SQL_TYPE_PROCESS,
                                             SharkConstants.PROC_STATE,
                                             sqlState,
                                             "IN (SELECT "
                                                   + objectid_column_name
                                                   + " FROM SHKProcessStates WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" LIKE ",
                                             SharkConstants.STATEPREFIX_CLOSED,
                                             ") ");

         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addFinishTimeBefore",
                       this);
      }
   }

   public WMFilter addFinishTimeAfter(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addFinishTimeAfter");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addFinishTimeAfter", null);
         WMFilter f = addGreaterThan(SQL_TYPE_PROCESS,
                                     SharkConstants.PROC_LAST_STATE_TIME_MS,
                                     sqlLastStateTime,
                                     arg);
         WMFilter f2 = addStartsWithSubQuery(SQL_TYPE_PROCESS,
                                             SharkConstants.PROC_STATE,
                                             sqlState,
                                             "IN (SELECT "
                                                   + objectid_column_name
                                                   + " FROM SHKProcessStates WHERE "+getSQLUpperCaseIfNeccessary(sqlName)+" LIKE ",
                                             SharkConstants.STATEPREFIX_CLOSED,
                                             ") ");

         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addFinishTimeAfter",
                       this);
      }
   }

   public WMFilter addLimitTimeEquals(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLimitTimeEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLimitTimeEquals", null);
         return addEquals(SQL_TYPE_PROCESS,
                          SharkConstants.PROC_LIMIT_TIME_MS,
                          sqlLimitTime,
                          arg);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLimitTimeEquals",
                       this);
      }
   }

   public WMFilter addLimitTimeBefore(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLimitTimeBefore");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLimitTimeBefore", null);
         WMFilter f = addLessThan(SQL_TYPE_PROCESS,
                                  SharkConstants.PROC_LIMIT_TIME_MS,
                                  sqlLimitTime,
                                  arg);
         WMFilter f2 = addEquals(SQL_TYPE_PROCESS,
                                 SharkConstants.PROC_LIMIT_TIME_MS,
                                 sqlLimitTime,
                                 SharkConstants.UNDEFINED_TIME);
         f2 = not(shandle, f2);
         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLimitTimeBefore",
                       this);
      }
   }

   public WMFilter addLimitTimeAfter(WMSessionHandle shandle, long arg) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addLimitTimeAfter");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addLimitTimeAfter", null);
         WMFilter f = addGreaterThan(SQL_TYPE_PROCESS,
                                     SharkConstants.PROC_LIMIT_TIME_MS,
                                     sqlLimitTime,
                                     arg);
         WMFilter f2 = addEquals(SQL_TYPE_PROCESS,
                                 SharkConstants.PROC_LIMIT_TIME_MS,
                                 sqlLimitTime,
                                 SharkConstants.UNDEFINED_TIME);
         f2 = not(shandle, f2);
         f = and(shandle, f, f2);
         return f;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addLimitTimeAfter",
                       this);
      }
   }

   public WMFilter addActiveActivitiesCountEquals(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addActiveActivitiesCountEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addActiveActivitiesCountEquals", null);
         String javaName = SharkConstants.PROC_ACTIVE_ACTIVITIES_NO;

         WMFilter filter = new WMFilter(SQL_TYPE_PROCESS);
         filter.setBshExpression(javaName + ".longValue()==" + arg);
         filter.setSQLWhereExpression("1 = 1");
         filter.setSqlWhereComplete(false);
         addNewPropertyUsed(filter, javaName, String.valueOf(arg));

         return filter;
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addActiveActivitiesCountEquals",
                       this);
      }
   }

   public WMFilter addActiveActivitiesCountGreaterThan(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle,
                      "ProcessFilterBuilderDODS.addActiveActivitiesCountGreaterThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addActiveActivitiesCountGreaterThan", null);
         String javaName = SharkConstants.PROC_ACTIVE_ACTIVITIES_NO;

         WMFilter filter = new WMFilter(SQL_TYPE_PROCESS);
         filter.setBshExpression(javaName + ".longValue()>" + arg);
         filter.setSQLWhereExpression("1 = 1");
         filter.setSqlWhereComplete(false);
         addNewPropertyUsed(filter, javaName, String.valueOf(arg));

         return filter;

      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addActiveActivitiesCountGreaterThan",
                       this);
      }
   }

   public WMFilter addActiveActivitiesCountLessThan(WMSessionHandle shandle, long arg)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle,
                      "ProcessFilterBuilderDODS.addActiveActivitiesCountLessThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addActiveActivitiesCountLessThan", null);
         String javaName = SharkConstants.PROC_ACTIVE_ACTIVITIES_NO;

         WMFilter filter = new WMFilter(SQL_TYPE_PROCESS);
         filter.setBshExpression(javaName + ".longValue()<" + arg);
         filter.setSQLWhereExpression("1 = 1");
         filter.setSqlWhereComplete(false);
         addNewPropertyUsed(filter, javaName, String.valueOf(arg));

         return filter;

      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addActiveActivitiesCountLessThan",
                       this);
      }
   }

   public WMFilter addVariableEquals(WMSessionHandle shandle, String vName, Object vValue)
      throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableEquals", null);
         if (vValue instanceof String) {
            return addVariableStringEquals(shandle, vName, (String) vValue);
         } else if (vValue instanceof Long) {
            return addVariableLongEquals(shandle, vName, ((Long) vValue).longValue());
         } else if (vValue instanceof Double) {
            return addVariableDoubleEquals(shandle,
                                           vName,
                                           ((Double) vValue).doubleValue());
         } else if (vValue instanceof Boolean) {
            return addEqualsWithSubQuery(SQL_TYPE_PROCESS,
                                         SharkConstants.PROC_CONTEXT_ + vName,
                                         objectid_column_name,
                                         "IN (SELECT Process FROM SHKProcessData"
                                               + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                               : "WOB")
                                               + " WHERE VariableDefinitionId = "
                                               + getDelimiter() + vName + getDelimiter()
                                               + " AND VariableValueBOOL = ",
                                         ((Boolean) vValue).booleanValue() ? 1L : 0L,
                                         ") ");
         } else {
            throw new Exception("Class " + vValue.getClass().getName() + " not supported");
         }
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableEquals",
                       this);
      }
   }

   public WMFilter addVariableStringEquals(WMSessionHandle shandle,
                                           String vName,
                                           String vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableStringEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableStringEquals", null);
         return addEqualsWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                  SharkConstants.PROC_CONTEXT_ + vName,
                                                  objectid_column_name,
                                                  "IN (SELECT Process FROM SHKProcessData"
                                                        + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                        : "WOB")
                                                        + " WHERE "+getSQLUpperCaseIfNeccessary("VariableDefinitionId")+ " = ",
                                                  " AND "+getSQLUpperCaseIfNeccessary("VariableValueVCHAR")+" = ",
                                                  vName,
                                                  vValue,
                                                  ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableStringEquals",
                       this);
      }
   }

   public WMFilter addVariableLongEquals(WMSessionHandle shandle,
                                         String vName,
                                         long vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableLongEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableLongEquals", null);
         return addEqualsWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                  SharkConstants.PROC_CONTEXT_ + vName,
                                                  objectid_column_name,
                                                  "IN (SELECT Process FROM SHKProcessData"
                                                        + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                        : "WOB")
                                                        + " WHERE VariableDefinitionId = ",
                                                  " AND VariableValueLONG = ",
                                                  vName,
                                                  vValue,
                                                  ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableLongEquals",
                       this);
      }
   }

   public WMFilter addVariableLongGreaterThan(WMSessionHandle shandle,
                                              String vName,
                                              long vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableLongGreaterThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableLongGreaterThan", null);
         return addGreaterThanWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                       SharkConstants.PROC_CONTEXT_
                                                             + vName,
                                                       objectid_column_name,
                                                       "IN (SELECT Process FROM SHKProcessData"
                                                             + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                             : "WOB")
                                                             + " WHERE VariableDefinitionId = ",
                                                       " AND VariableValueLONG ",
                                                       vName,
                                                       vValue,
                                                       ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableLongGreaterThan",
                       this);
      }
   }

   public WMFilter addVariableLongLessThan(WMSessionHandle shandle,
                                           String vName,
                                           long vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableLongLessThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableLongLessThan", null);
         return addLessThanWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                    SharkConstants.PROC_CONTEXT_ + vName,
                                                    objectid_column_name,
                                                    "IN (SELECT Process FROM SHKProcessData"
                                                          + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                          : "WOB")
                                                          + " WHERE VariableDefinitionId = ",
                                                    " AND VariableValueLONG ",
                                                    vName,
                                                    vValue,
                                                    ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableLongLessThan",
                       this);
      }
   }

   public WMFilter addVariableDoubleEquals(WMSessionHandle shandle,
                                           String vName,
                                           double vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableDoubleEquals");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableDoubleEquals", null);
         return addEqualsWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                  SharkConstants.PROC_CONTEXT_ + vName,
                                                  objectid_column_name,
                                                  "IN (SELECT Process FROM SHKProcessData"
                                                        + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                        : "WOB")
                                                        + " WHERE VariableDefinitionId = ",
                                                  " AND VariableValueDBL = ",
                                                  vName,
                                                  vValue,
                                                  ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableDoubleEquals",
                       this);
      }
   }

   public WMFilter addVariableDoubleGreaterThan(WMSessionHandle shandle,
                                                String vName,
                                                double vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableDoubleGreaterThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableDoubleGreaterThan", null);
         return addGreaterThanWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                       SharkConstants.PROC_CONTEXT_
                                                             + vName,
                                                       objectid_column_name,
                                                       "IN (SELECT Process FROM SHKProcessData"
                                                             + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                             : "WOB")
                                                             + " WHERE VariableDefinitionId = ",
                                                       " AND VariableValueDBL ",
                                                       vName,
                                                       vValue,
                                                       ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableDoubleGreaterThan",
                       this);
      }
   }

   public WMFilter addVariableDoubleLessThan(WMSessionHandle shandle,
                                             String vName,
                                             double vValue) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.addVariableDoubleLessThan");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "addVariableDoubleLessThan", null);
         return addLessThanWithSubQueryForVariables(SQL_TYPE_PROCESS,
                                                    SharkConstants.PROC_CONTEXT_ + vName,
                                                    objectid_column_name,
                                                    "IN (SELECT Process FROM SHKProcessData"
                                                          + (BasicFilterBuilder.usingStandardVariableModel ? ""
                                                                                                          : "WOB")
                                                          + " WHERE VariableDefinitionId = ",
                                                    " AND VariableValueDBL ",
                                                    vName,
                                                    vValue,
                                                    ") ");
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.addVariableDoubleLessThan",
                       this);
      }
   }

   public WMFilter setOrderByMgrName(WMSessionHandle shandle,
                                     WMFilter filter,
                                     boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByMgrName");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByMgrName", null);
         return super.setOrderBy(filter, sqlProcDefName, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByMgrName",
                       this);
      }
   }

   public WMFilter setOrderById(WMSessionHandle shandle,
                                WMFilter filter,
                                boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderById");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderById", null);
         return super.setOrderBy(filter, sqlId, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.setOrderById", this);
      }
   }

   public WMFilter setOrderByName(WMSessionHandle shandle,
                                  WMFilter filter,
                                  boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByName");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByName", null);
         return super.setOrderBy(filter, sqlName, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.setOrderByName", this);
      }
   }

   public WMFilter setOrderByState(WMSessionHandle shandle,
                                   WMFilter filter,
                                   boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByState");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByState", null);
         return super.setOrderBy(filter, sqlState, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle, tStamp, "ProcessFilterBuilderDODS.setOrderByState", this);
      }
   }

   public WMFilter setOrderByPriority(WMSessionHandle shandle,
                                      WMFilter filter,
                                      boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByPriority");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByPriority", null);
         return super.setOrderBy(filter, sqlPriority, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByPriority",
                       this);
      }
   }

   public WMFilter setOrderByCreatedTime(WMSessionHandle shandle,
                                         WMFilter filter,
                                         boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByCreatedTime");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByCreatedTime", null);
         return super.setOrderBy(filter, sqlCreated, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByCreatedTime",
                       this);
      }
   }

   public WMFilter setOrderByStartTime(WMSessionHandle shandle,
                                       WMFilter filter,
                                       boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByStartTime");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByStartTime", null);
         return super.setOrderBy(filter, sqlStarted, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByStartTime",
                       this);
      }
   }

   public WMFilter setOrderByLastStateTime(WMSessionHandle shandle,
                                           WMFilter filter,
                                           boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByLastStateTime");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByLastStateTime", null);
         return super.setOrderBy(filter, sqlLastStateTime, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByLastStateTime",
                       this);
      }
   }

   public WMFilter setOrderByResourceRequesterId(WMSessionHandle shandle,
                                                 WMFilter filter,
                                                 boolean ascending) throws Exception {
      long tStamp = SharkEngineManager.getInstance()
         .getCallbackUtilities()
         .methodStart(shandle, "ProcessFilterBuilderDODS.setOrderByResourceRequesterId");
      try {
         if (!SharkUtilities.checkSession(shandle)) {
            throw new NotConnected("The session handle is not valid!");
         }
         checkSecurity(shandle, "setOrderByResourceRequesterId", null);
         return super.setOrderBy(filter, sqlResourceRequesterId, ascending);
      } finally {
         SharkEngineManager.getInstance()
            .getCallbackUtilities()
            .methodEnd(shandle,
                       tStamp,
                       "ProcessFilterBuilderDODS.setOrderByResourceRequesterId",
                       this);
      }
   }

}
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.