Search code examples
sortingyiilimit

yii dataprovider sorting

i have a question about sorting in Yii DataProvider. I want to sort it excatly like im doing it now, but starting with 3rd record DESC. Not first, second, but third record. Something like "limit => '3' criteria. Any ideas?

$dataProvider=new CActiveDataProvider('News', array(
        'criteria'=>array(
        'order'=>'create_time DESC',
        ),
        'pagination'=>array(
        'pageSize'=>10,
        ),
    ));
Solution

  • Configure the offset property on the criteria:

    $dataProvider=new CActiveDataProvider('News', array(
    'criteria' => array(
        'order'  => 'create_time DESC',
        'offset' => 2, // zero-based index, third record = 2
    ),
    'pagination' => array(
    'pageSize'   => 10,
    ),
));