DataMapper ORM v1.8.2

[eluser]tarciozemel[/eluser]
[quote author="Davva" date="1333474894"]Counting related objects based on query?
I'm trying to setup a subquery in DataMapper, but I can't really understand how to get it to work.
The situation: I have two models, client and project.

A client can have many projects, a project can have only one client.

I want to list all clients by their names and next to them show the project count for each client.
For example:
Client 1 (8)
Client 2 (4)
and so on…

This I got working fine using

Code:

...
$client->include_related_count('project');
...

The code above will include the project_count for each client. Now to the problem. Each project can be either 'open' or 'closed'. This is set by an enum field named 'status' in the projects table.

So,
How can I access two separate project counters for each project? Perhaps call them 'project_count_open' and 'project_count_closed' for each client?

I have looked into subqueries, but I can't get it to work.

Suggestions greatly appreciated!
[/quote]

And if you make a if...else to check what is the value of "status" in each iteration?