i have 3 table+relation, like this
table Provider
ID_PRO
PRO_NAME
table Card
ID_CARD
CARD_NAME
ID_PRO (relation to table Provider)
table History
ID_HISTORY
DESCRIPTION
ID_CARD (relation to table Card)
what i show on admin page History
ID_HISTORY
DESCRIPTION
CARD_NAME
PRO_NAME
i’ve use this on History model
$criteria->compare('card.pro.PRO_NAME',$this->PRO_NAME,true);
but in admin page, i still can’t do filter on PRO_NAME column because table History doesn’t have direct relation to table Provider.
any idea how to do that?
thank you