一个简单的查询示例var colTaskID = new TWSearchColumn;colTaskID.type = TWSearchColumn.Types.Task;colTaskID.name = TWSearchColumn.TaskColumns.ID;var colTaskSubject = new TWSearchColumn;colTaskSubject.type = TWSearchColumn.Types.Task;colTaskSubject.name...
显示全部
一个简单的查询示例
var colTaskID = new TWSearchColumn;
colTaskID.type = TWSearchColumn.Types.Task;
colTaskID.name = TWSearchColumn.TaskColumns.ID;
var colTaskSubject = new TWSearchColumn;
colTaskSubject.type = TWSearchColumn.Types.Task;
colTaskSubject.name = TWSearchColumn.TaskColumns.Subject;
var colTaskStatus = new TWSearchColumn;
colTaskStatus.type = TWSearchColumn.Types.Task;
colTaskStatus.name = TWSearchColumn.TaskColumns.Status;
var colTaskAssignedToRole = new TWSearchColumn;
colTaskAssignedToRole.type = TWSearchColumn.Types.Task;
colTaskAssignedToRole.name = TWSearchColumn.TaskColumns.AssignedToRole;
var colTaskAssignedToUser = new TWSearchColumn;
colTaskAssignedToUser.type = TWSearchColumn.Types.Task;
colTaskAssignedToUser.name = TWSearchColumn.TaskColumns.AssignedToUser;
var condFilterRole = new TWSearchCondition;
condFilterRole.column = colTaskAssignedToUser;
condFilterRole.operator = TWSearchCondition.Operations.Contains;
condFilterRole.value = "user";
var search = new TWSearch();
//Set the columns, noting that ORDER MATTERS when you retrieve results
search.columns = new Array(colTaskID, colTaskSubject, colTaskStatus, colTaskAssignedToRole, colTaskAssignedToUser);
search.conditions = new Array(condFilterRole);
search.organizedBy = TWSearch.OrganizeByTypes.Task;
///////////////////Execute search and retrieve results/////////////////
var results;//This line is not required bu keeps autocorrect errors from appearing
//Checks if there is a userName, so that the results are only for the given user
//if(tw.local.queryThisUserName.length >0){
// var results = search.execute(tw.local.queryThisUserName);
//}
//Otherwise ALL USER's results are returned
var results = search.execute();
//Loop through the results variable and set your taskInfoList output object
for(var i = 0; i < results.rows.length; i++) {
var row = results.rows[i];
if(row.values[0]){log.info(row.values[0].toString())};
if(row.values[1]){log.info(row.values[1].toString())};
if(row.values[2]){log.info(row.values[2].toString())};
if(row.values[3]){log.info(row.values[3].toString())};
if(row.values[4]){log.info(row.values[4].toString())};
}
收起