Multi Relation Problem

[konapaz]

thats is not level 2 that is just joined tables. you cant sort products on product.category.group you had to join group with category first

I din’t check if the code of softart works but the

$criteria->with = array(‘category’=>array(‘with’=>‘groups’)); works at least for sorting case (I have some problem by search text - is float type)

Does someone know if the above code is tha same with

$criteria->with = array(‘category’, ‘category.groups’) ?

I realy didn’t know this way!

[konapaz]

You are expected to prepend the table alias to ‘group_id’ here. And the table alias for ‘category.groups’ relation is ‘groups’ not ‘category.groups’.

you have right the problem was the double “with”

[le_top (Ext Yiiframework Com)]

Hi all this trouble while using my RelatedSearchBehavior extension makes this really easier!