public class SearchTaskSQLImpl extends java.lang.Object implements SearchTaskSQL
SearchTaskSQL
. The default algorithms used
for the various hook points points are defined here.
By default there are three types of task search functionality:
Constructor and Description |
---|
SearchTaskSQLImpl() |
Modifier and Type | Method and Description |
---|---|
java.lang.String |
getBusinessObjectTypeSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the associated
business object selected
by the user to be used as a search criteria. |
java.lang.String |
getCategorySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the
category selected by the user to
be used as a search criteria. |
java.lang.String |
getCountSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria)
Returns the SQL select query used to count the number of tasks satisfying
the specified criteria.
|
java.lang.String |
getCreationDateSQL(curam.core.sl.struct.TaskQueryCriteria key)
Generates the SQL for the
creation date selected by the user
to be used as a search criteria. |
java.lang.String |
getDeadlineSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the task
deadline selected by the user
to be used as a search criteria. |
java.lang.String |
getFromClause(curam.core.sl.struct.TaskQueryCriteria criteria)
Returns the SQL
FROM clause of the query. |
java.lang.String |
getOrderBySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL
order by clause. |
java.lang.String |
getOrgObjectSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the organization objects that tasks may be assigned
to and selected by the user as search criteria.
|
java.lang.String |
getPrioritySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the task
priority selected by the user
to be used as a search criteria. |
java.lang.String |
getReservedBySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the
reserved by SQL selected by the user. |
java.lang.String |
getRestartDateSQL(curam.core.sl.struct.TaskQueryCriteria key)
Generates the SQL for the
restart date selected by the user
to be used as a search criteria. |
java.lang.String |
getSelectClause(curam.core.sl.struct.TaskQueryCriteria criteria)
Returns the SQL
SELECT clause of the query. |
java.lang.String |
getSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria)
Returns the SQL select query used to return tasks satisfying the
specified criteria.
|
java.lang.String |
getStatusSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the task
status |
java.lang.String |
getTaskIDSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
Generates the SQL for the task identifier selected by the user to be used
as a search criteria.
|
java.lang.String |
getWhereClause(curam.core.sl.struct.TaskQueryCriteria criteria)
Returns the SQL
WHERE clause of the query. |
public java.lang.String getSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
getSQLStatement
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
public java.lang.String getSelectClause(curam.core.sl.struct.TaskQueryCriteria criteria)
SELECT
clause of the query.getSelectClause
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.SELECT
clause.public java.lang.String getFromClause(curam.core.sl.struct.TaskQueryCriteria criteria)
FROM
clause of the query.getFromClause
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.FROM
clause.public java.lang.String getWhereClause(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
WHERE
clause of the query.getWhereClause
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
public java.lang.String getOrderBySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
order by
clause.getOrderBySQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.order by
clause.public java.lang.String getCountSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
getCountSQLStatement
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
public java.lang.String getBusinessObjectTypeSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
business object
selected
by the user to be used as a search criteria.getBusinessObjectTypeSQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.business object
.public java.lang.String getCategorySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
category
selected by the user to
be used as a search criteria.getCategorySQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.category
.public java.lang.String getOrgObjectSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
getOrgObjectSQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.public java.lang.String getStatusSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
status selected by the user.
getStatusSQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.status
.public java.lang.String getTaskIDSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
getTaskIDSQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.public java.lang.String getReservedBySQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
reserved by
SQL selected by the user.getReservedBySQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.reserved by
field.curam.util.exception.AppException
curam.util.exception.InformationalException
public java.lang.String getPrioritySQL(curam.core.sl.struct.TaskQueryCriteria criteria)
priority
selected by the user
to be used as a search criteria.getPrioritySQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.priority
.public java.lang.String getDeadlineSQL(curam.core.sl.struct.TaskQueryCriteria criteria)
deadline
selected by the user
to be used as a search criteria.getDeadlineSQL
in interface SearchTaskSQL
criteria
- The search criteria from which to generate the SQL.deadline
.public java.lang.String getCreationDateSQL(curam.core.sl.struct.TaskQueryCriteria key)
creation date
selected by the user
to be used as a search criteria.getCreationDateSQL
in interface SearchTaskSQL
key
- The search criteria from which to generate the SQL.creation date
.public java.lang.String getRestartDateSQL(curam.core.sl.struct.TaskQueryCriteria key)
restart date
selected by the user
to be used as a search criteria.getRestartDateSQL
in interface SearchTaskSQL
key
- The search criteria from which to generate the SQL.restart date
.