gt:             ret.append("=" + startUpdateDate);
context: package com.autentia.intra.dao.search;
  
  import com.autentia.intra.businessobject.*;
  import com.autentia.intra.dao.SearchCriteria;
  
  import java.util.ArrayList;
  import java.util.Date;
  
  /**
   * Class to search for Interaction objects
   *
   * @author stajanov code generator
   */
  public class InteractionSearch extends SearchCriteria {
  /* generated by stajanov (do not edit/delete) */
  
  
      @Override
      public String getHQL() {
          StringBuilder ret = new StringBuilder();
          int iArgNum = 0;
  
          if (isStartCreationDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (startCreationDate == null) {
                  ret.append("creationDate=:arg" + (iArgNum++));
              } else {
                  ret.append("creationDate>=:arg" + (iArgNum++));
              }
          }
          if (isEndCreationDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (endCreationDate == null) {
                  ret.append("creationDate=:arg" + (iArgNum++));
              } else {
                  ret.append("creationDate<=:arg" + (iArgNum++));
              }
          }
  
  
          if (isInterestSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getInterest() == null) {
                  ret.append("interest is NULL");
              } else {
                  ret.append("interest = :arg" + (iArgNum++));
              }
          }
  
  
          if (isMedioSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getMedio() == null) {
                  ret.append("medio is NULL");
              } else {
                  ret.append("medio = :arg" + (iArgNum++));
              }
          }
  
  
          if (isWhySet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getWhy() == null) {
                  ret.append("why is NULL");
              } else {
                  ret.append("why = :arg" + (iArgNum++));
              }
          }
  
  
          if (isDescriptionSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getDescription() == null) {
                  ret.append("description is NULL");
              } else {
                  ret.append("description = :arg" + (iArgNum++));
              }
          }
  
  
          if (isFileSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getFile() == null) {
                  ret.append("file is NULL");
              } else {
                  ret.append("file = :arg" + (iArgNum++));
              }
          }
  
  
          if (isFileMimeSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getFileMime() == null) {
                  ret.append("fileMime is NULL");
              } else {
                  ret.append("fileMime = :arg" + (iArgNum++));
              }
          }
  
  
          if (isObservationsSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getObservations() == null) {
                  ret.append("observations is NULL");
              } else {
                  ret.append("observations = :arg" + (iArgNum++));
              }
          }
  
  
          if (isDepartmentIdSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getDepartmentId() == null) {
                  ret.append("departmentId is NULL");
              } else {
                  ret.append("departmentId = :arg" + (iArgNum++));
              }
          }
  
  
          if (isStartInsertDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (startInsertDate == null) {
                  ret.append("insertDate=:arg" + (iArgNum++));
              } else {
                  ret.append("insertDate>=:arg" + (iArgNum++));
              }
          }
          if (isEndInsertDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (endInsertDate == null) {
                  ret.append("insertDate=:arg" + (iArgNum++));
              } else {
                  ret.append("insertDate<=:arg" + (iArgNum++));
              }
          }
  
  
          if (isStartUpdateDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (startUpdateDate == null) {
                  ret.append("updateDate=:arg" + (iArgNum++));
              } else {
                  ret.append("updateDate>=:arg" + (iArgNum++));
              }
          }
          if (isEndUpdateDateSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (endUpdateDate == null) {
                  ret.append("updateDate=:arg" + (iArgNum++));
              } else {
                  ret.append("updateDate<=:arg" + (iArgNum++));
              }
          }
  
  
          if (isProjectSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getProject() == null) {
                  ret.append("project is NULL");
              } else {
                  ret.append("project = :arg" + (iArgNum++));
              }
          }
  
  
          if (isClientSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getClient() == null) {
                  ret.append("client is NULL");
              } else {
                  ret.append("client = :arg" + (iArgNum++));
              }
          }
  
  
          if (isTypeSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getType() == null) {
                  ret.append("type is NULL");
              } else {
                  ret.append("type = :arg" + (iArgNum++));
              }
          }
  
  
          if (isUserSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getUser() == null) {
                  ret.append("user is NULL");
              } else {
                  ret.append("user = :arg" + (iArgNum++));
              }
          }
  
  
          if (isOfferSet()) {
              ret.append((ret.length() == 0) ? "WHERE " : " AND ");
              if (getOffer() == null) {
                  ret.append("offer is NULL");
              } else {
                  ret.append("offer = :arg" + (iArgNum++));
              }
          }
  
          customGetHQL(ret, iArgNum);
          return ret.toString();
      }
  
      @Override
      public Object[] getArguments() {
          ArrayList<Object> ret = new ArrayList<Object>();
  
          if (isStartCreationDateSet()) {
              ret.add(startCreationDate);
          }
          if (isEndCreationDateSet()) {
              ret.add(endCreationDate);
          }
  
  
          if (isInterestSet() && getInterest() != null) {
              ret.add(interest);
          }
  
  
          if (isMedioSet() && getMedio() != null) {
              ret.add(medio);
          }
  
  
          if (isWhySet() && getWhy() != null) {
              ret.add(why);
          }
  
  
          if (isDescriptionSet() && getDescription() != null) {
              ret.add(description);
          }
  
  
          if (isFileSet() && getFile() != null) {
              ret.add(file);
          }
  
  
          if (isFileMimeSet() && getFileMime() != null) {
              ret.add(fileMime);
          }
  
  
          if (isObservationsSet() && getObservations() != null) {
              ret.add(observations);
          }
  
  
          if (isDepartmentIdSet() && getDepartmentId() != null) {
              ret.add(departmentId);
          }
  
  
          if (isStartInsertDateSet()) {
              ret.add(startInsertDate);
          }
          if (isEndInsertDateSet()) {
              ret.add(endInsertDate);
          }
  
  
          if (isStartUpdateDateSet()) {
              ret.add(startUpdateDate);
          }
          if (isEndUpdateDateSet()) {
              ret.add(endUpdateDate);
          }
  
  
          if (isProjectSet() && getProject() != null) {
              ret.add(project);
          }
  
  
          if (isClientSet() && getClient() != null) {
              ret.add(client);
          }
  
  
          if (isTypeSet() && getType() != null) {
              ret.add(type);
          }
  
  
          if (isUserSet() && getUser() != null) {
              ret.add(user);
          }
  
  
          if (isOfferSet() && getOffer() != null) {
              ret.add(offer);
          }
  
          customGetArguments(ret);
          return ret.toArray();
      }
  
      @Override
      public void reset() {
  
          unsetStartCreationDate();
          unsetEndCreationDate();
  
  
          unsetInterest();
  
  
          unsetMedio();
  
  
          unsetWhy();
  
  
          unsetDescription();
  
  
          unsetFile();
  
  
          unsetFileMime();
  
  
          unsetObservations();
  
  
          unsetDepartmentId();
  
  
          unsetStartInsertDate();
          unsetEndInsertDate();
  
  
          unsetStartUpdateDate();
          unsetEndUpdateDate();
  
  
          unsetProject();
  
  
          unsetClient();
  
  
          unsetType();
  
  
          unsetUser();
  
  
          unsetOffer();
  
          customReset();
      }
  
      @Override
      public String toString() {
          StringBuilder ret = new StringBuilder();
          ret.append("InteractionSearch{");
  
  
          if (isStartCreationDateSet()) {
              ret.append("(startCreationDate");
              ret.append("=" + startCreationDate);
              ret.append(")");
          }
          if (isEndCreationDateSet()) {
              ret.append("(endCreationDate");
              ret.append("=" + endCreationDate);
              ret.append(")");
          }
  
  
          if (isInterestSet()) {
              ret.append("(interest");
              ret.append("=" + interest);
              ret.append(")");
          }
  
  
          if (isMedioSet()) {
              ret.append("(medio");
              ret.append("=" + medio);
              ret.append(")");
          }
  
  
          if (isWhySet()) {
              ret.append("(why");
              ret.append("=" + why);
              ret.append(")");
          }
  
  
          if (isDescriptionSet()) {
              ret.append("(description");
              ret.append("=" + description);
              ret.append(")");
          }
  
  
          if (isFileSet()) {
              ret.append("(file");
              ret.append("=" + file);
              ret.append(")");
          }
  
  
          if (isFileMimeSet()) {
              ret.append("(fileMime");
              ret.append("=" + fileMime);
              ret.append(")");
          }
  
  
          if (isObservationsSet()) {
              ret.append("(observations");
              ret.append("=" + observations);
              ret.append(")");
          }
  
  
          if (isDepartmentIdSet()) {
              ret.append("(departmentId");
              ret.append("=" + departmentId);
              ret.append(")");
          }
  
  
          if (isStartInsertDateSet()) {
              ret.append("(startInsertDate");
              ret.append("=" + startInsertDate);
              ret.append(")");
          }
          if (isEndInsertDateSet()) {
              ret.append("(endInsertDate");
              ret.append("=" + endInsertDate);
              ret.append(")");
          }
  
  
          if (isStartUpdateDateSet()) {
              ret.append("(startUpdateDate");
  