Hi Jeff,
In the UI you could create a relation summary field for that.
I'll let Ophir give his input on how to do so via the API.
Comment actions
Post
Follow
Is there a way to return the count of overdue Tasks on a Project via the API (PHP/SOAP)?
I don't want the actual Tasks, just a count of them, per Project. I'd like to get all Active Projects and their count of Overdue Tasks. Thanks!
Jeff
Please sign in to leave a comment.
2 comments
Date
Votes
Hi Jeff.
I'd suggest you implement a relation summary field as Jonathan suggested, and add that field to your query.
The API does have a CountQuery which gives you only the count of a query you specify in the message parameter, but what you need is a count for each (Project) result, which cannot be achieved directly (you'd have to issue a CountQuery per project).
Hope this helps,
Ophir
Comment actions