how to limit query for ActiveDataProvider?

Question

I am trying to make a query to get the first 10 records for example, and pass it to the ActiveDataProvider.

The query is working fine and returning the required number of records only, while the ActiveDataProvider is printing all the records, here is my code:

    $query = new \yii\db\Query;
    $query->select('*')
            ->from('customers')
            ->limit(10);
    $query->createCommand();

    $dataProvider = new ActiveDataProvider([
        'query' => $query,
    ]);

i think this question was already asked you should search first. — Amitesh Kumar, Dec 16 '15 at 04:50

score 7 · Accepted Answer · edited May 23 '17 at 12:31

7

Set Pagination to false :

$dataProvider = new ActiveDataProvider([
'pagination' => false
]);

Reference

edited May 23 '17 at 12:31

Community

1
1

answered Dec 15 '15 at 09:01

Insane Skull

8,810
9
38
59

I don't want to use pagination, the data provided must not exceed the specified limit. – Mohammad Dec 15 '15 at 09:03
@Mohammad. See Updated answer. – Insane Skull Dec 15 '15 at 09:05
@Mohammad mark as accepted. – Insane Skull Dec 15 '15 at 09:07
3

@InsaneSkull i think you should use false and not 'false' (in this case the result is the same, but the concept is different ) – scaisEdge Dec 15 '15 at 09:09
@scaisEdge Thanks, typo error. – Insane Skull Dec 15 '15 at 09:10
@scaisEdge good catch, I tried false from the beginning because 'false' didn't work. – Mohammad Dec 15 '15 at 09:10
@InsaneSkull : hi, how can setting pagination false get the intended result ? what is the relation between pagination and query limit? – Bloodhound Dec 16 '15 at 03:58
1

@Bloodhound. see **Reference** link of my answer. – Insane Skull Dec 16 '15 at 04:11
@InsaneSkull i have commented on that answer. I forgot sorry – Bloodhound Dec 16 '15 at 06:43

how to limit query for ActiveDataProvider?

1 Answers1