@Implementable
public interface SearchTaskSQL
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 criteria)
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 criteria)
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. |
java.lang.String getSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getCountSQLStatement(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getSelectClause(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
SELECT
clause of the query.criteria
- The search criteria from which to generate the SQL.SELECT
clause.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getFromClause(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
FROM
clause of the query.criteria
- The search criteria from which to generate the SQL.FROM
clause.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getWhereClause(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
WHERE
clause of the query.criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getOrgObjectSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getStatusSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
status selected by the user.
criteria
- The search criteria from which to generate the SQL.status
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getTaskIDSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
criteria
- The search criteria from which to generate the SQL.curam.util.exception.AppException
curam.util.exception.InformationalException
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.criteria
- The search criteria from which to generate the SQL.reserved by
field.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getPrioritySQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
priority
selected by the user
to be used as a search criteria.criteria
- The search criteria from which to generate the SQL.priority
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getDeadlineSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
deadline
selected by the user
to be used as a search criteria.criteria
- The search criteria from which to generate the SQL.deadline
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getCreationDateSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
creation date
selected by the user
to be used as a search criteria.criteria
- The search criteria from which to generate the SQL.creation date
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getRestartDateSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
restart date
selected by the user
to be used as a search criteria.criteria
- The search criteria from which to generate the SQL.restart date
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getOrderBySQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
order by
clause.criteria
- The search criteria from which to generate the SQL.order by
clause.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getBusinessObjectTypeSQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
business object
selected
by the user to be used as a search criteria.criteria
- The search criteria from which to generate the SQL.business object
.curam.util.exception.AppException
curam.util.exception.InformationalException
java.lang.String getCategorySQL(curam.core.sl.struct.TaskQueryCriteria criteria) throws curam.util.exception.AppException, curam.util.exception.InformationalException
category
selected by the user to
be used as a search criteria.criteria
- The search criteria from which to generate the SQL.category
.curam.util.exception.AppException
curam.util.exception.InformationalException