Include count of nested associated object as virtual field.

Hi,

I have the following model relationships

Question belongs to Chapter

Chapter belongs to Unit

I want to add a virtual field in the Unit model that counts how many questions a unit has.  I tried this:

public $virtualFields = array(

"questionCount" => 'SELECT COUNT(*) FROM questions as Question JOIN chapters as Chapter ON (Question.chapter_id = Chapter.id) JOIN units as Unit ON (Chapter.unit_id = Unit.id)'

);

The problem here is that it returns the same value for all untis.  The issue here is that I want the count for each Unit instance.  In other words, I would like to add a where clause so that the query becomes something similar to:

public $virtualFields = array(

"questionCount" => 'SELECT COUNT(*) FROM questions as Question JOIN chapters as Chapter ON (Question.chapter_id = Chapter.id) JOIN units as Unit ON (Chapter.unit_id = Unit.id)  WHERE Unit.id = CAKE_REPLACE_WITH_CURRENT_ID'

);

How do I get cake to CAKE_REPLACE_WITH_CURRENT_ID to be the ID of the current Unit instance that is being retrieved?

I hope I have made my question clear.  Thanks in advance.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.