How to use getReferencedTable()

Hello folks!
I came across a problem with \Nette\Database which is probably caused by my misunderstanding of how to use it properly.

I've got table client_action_product which points at tables client_action and product using foreign keys named product_id and client_action_id. I am trying to access the product table using this query:

foreach ($this->getActions()->where('cancelled IS NULL') as $action) {
	if ($action->related('client_action_product')->getReferencedTable('product','product_id')->where('type LIKE ?','%whatever%')->count() > 0) {
		return true;
	}

There is no problem getting to the client_action_product table but I am not able to get past the getReferencedTable call. It does not return anything and I don't know why.

I tried to change the column parameter of that method to id but the result is the same. I expected to have Selection which I could further work with but I still get nothing.

Getting a single row from product using

$action->related('client_action_product')->fetch()->ref('product','product_id')->toArray()

works without problems but this way I would have to iterate over the related products using another foreach and check the condition everytime which looks to me as less elegant and slower (not that the speed matters much in this particular case).

If anyone could give me some advice I would be thankful.

Last edited by dfx413 (2012-04-08 01:00)