Greetings,
I'm working on a data extract from Clarizen for our task management system. I need all projects with active tasks and their associated resources. It looks like the most efficient (or at least fewest calls) way to get at all of the tasks, assignments and their associated projects is using the RegularResourceLink query, but I'm trying to limit the WorkItem Types to be just of the Type task. Ideally I'd also like to limit it to tasks with a status of "Active" but it doesn't look like drilling into Entities is supported with Conditions and maybe that part of why I don't get any results?
Here is a trimmed down version what I came up with for the query object in my attempt to limit the workitem types returned by the query. It doesn't return an error which makes me think I've got the right idea, but it also doesn't return any results so there is something off:
VB:
Dim QueryConditions As New List(Of com.clarizen.api.Compare)
QueryConditions.Add(New com.clarizen.api.Compare With {
.LeftExpression = New com.clarizen.api.FieldExpression With {.FieldName = "WorkItem"},
.RightExpression = New com.clarizen.api.ConstantExpression With {.Value = New com.clarizen.api.EntityId With {.TypeName = "Task"}},
.Operator = com.clarizen.api.Operator.Equal})
Dim query As com.clarizen.api.EntityQuery = New com.clarizen.api.EntityQuery()
With query
.TypeName = "RegularResourceLink"
.Fields = QueryFields.ToArray
.Paging = New com.clarizen.api.Paging With { .PageSize = 200, .PageSizeSpecified = True}
.Where = New com.clarizen.api.And With { .Conditions = QueryConditions.ToArray}
End With
So my questions are: Am I on the right track and if so any suggestions? Is there a better method of retrieving all projects with active tasks and the assignments? I haven't really played with RetrieveMultipleMessage yet which seems like another plausible route?
