How can I query a list of Work Items based on Process Template Name?
The information in this article applies to:
- AgilePoint Suite
- AgilePoint Enterprise Manager
- AgilePoint Envision
- AgilePoint Developer
- AgilePoint Server
| GOAL(S) |
| |
To query a list of work items based on Process Template Name. |
| |
|
| SUMMARY |
| |
API such as QueryWorkList and QueryWorkListEx can be used to query a list of Work Items based on the process template name even though the WF_MANUAL_WORKITEMS table does not have a column for Process Template name (which is kept in a separate table). |
| |
|
| SOLUTION |
| |
The following is an example of query a list of work items with a specific process template name.
string where = "";
SQLExprBuilder eb = SQLExprBuilder.GetBuilder( Global.DataBaseVendor );
if( criteria.processTemplateName != null && criteria.processTemplateName.Length > 0 )
{
// To query the work item list belong to the specified process template name
if( where.Length > 0 ) where += " and ";
where += eb.GetExpr("WF_PROC_DEFS.DEF_NAME", Constants.EQ, criteria.processTemplateName );
}
wks = api.QueryWorkListEx( where );
Or
public WFManualWorkItem[] GetProcessInstanceWorkItems( string ProcessInstanceID )
{
string _searchClause = "";
try
{
if ( ProcessInstanceID.Length > 0 )
_searchClause += "WF_PROC_DEFS.DEF_NAME = '" + ProcessTemplateName + "'";
WFManualWorkItem[] wks = api.QueryWorkListEx( _searchClause );
return wks;
}
catch ( Exception e )
{
throw new Exception( "Error with GetProcessInstanceWorkItems", e );
}
} |
| |
|