MANY_MANY Criteria problem

ASK NEW QUESTION

Home Page » Active Record » MANY_MANY Criteria problem

0 Votes

Login to add this Question to favorites!

MANY_MANY Criteria problem

hi.
I have many_many relation.
Categories & Articles.
Just now I want create data provider for CListVeiw Articles where category id =5;(e.g)
But my code gives all the Articles (( Please help!

$criteriaItem = new CDbCriteria();
$criteriaItem->with = array(
'Categories' => array(
'condition' => 'Categories.id = :cat_id',
'params' => array(':cat_id' => $categoryID)
)
);
$articleItems = new CActiveDataProvider('Article', array(
'criteria' => $criteriaItem,
'pagination' => array(
'pageSize' => Y::param('blogItemSize', 5),
'pageVar' => 'page',
),
));

        $criteriaItem = new CDbCriteria();

        $criteriaItem->with = array(
            'Categories' => array(
                'condition' => 'Categories.id = :cat_id',
                'params' => array(':cat_id' => $categoryID)
            )
        );

        $articleItems = new CActiveDataProvider('Article', array(
            'criteria' => $criteriaItem,
            'pagination' => array(
                'pageSize' => Y::param('blogItemSize', 5),
                'pageVar' => 'page',
            ),
        ));

Thanks all.

By eibrahimov in Active Record · Asked 390 days 23 hours 30 mins ago

Questions: 4 Accepted: 0 ( 0% ) | Reputation: 0

Answers (1)

0 votes

You can try add ‘together’=>true

By SpiLLeR · 370 days 19 hours 20 mins ago

Questions: 0 Accepted: 0 ( 0% ) | Reputation: 0

Log in to Reply