Need help with an Intersect type query

Project has a custom field

I need to retrieve all tasks in a project where the custom field value is "Live"

I can get all projects with the correct value for the custom field and I can get all the tasks, but cannot structure the query to get all the tasks for the projects with the correct custom field value.

Any example would help,

Thanks

Bill Caughron December 15, 2014 20:00 Answered

Please sign in to leave a comment.

1 comment
Date Votes

Hi Bill,

You can do just that, by using EntityQuery with TypeName = Task specifying a condition on the Project field with the In operator and a QueryExpression _for that Project field in the _RightExpression.

You can find a sample for the use of In operator in this post:

https://success.clarizen.com/entries/38249296-Query-ResourceLinks-for-All-WorkItems-of-type-Task

Hope this helps,

Ophir

Ophir Kenig December 16, 2014 11:56 0 votes

Need help with an Intersect type query

1 comment Date Votes

1 comment
Date Votes