most of peoples use arrayDataprovider.So when we show data in grid,it fines but when we implement filter and sorting then they dont works,Even no documentation from yii developer team.
Yii has no feature so we can add extra filters on activedataProvider and we can implement same on arraydataProvider.
I don’t say that you should not use ArrayDataProvider, it’s true that you sometimes have to use it unwillingly. I would avoid using it if I could. From my own experience, it is very hard to write a simple and elegant code using ArrayDataProvider when you want a good performance.
Filtering on ArrayDataProvider is basically very simple.
What you have to do is just make an array of items that match your filtering condition, and give it to the ArrayDataProvider as “allModels”. That’s all. Then the sorting and the paginating will be handled automatically by the data provider.
In real life, it may not be that easy to create "allModels" array that satisfy the filtering condition, especially when you want a good performance.
The issue regarding “groupby” is another thing. It’s not related directly to ArrayDataProvider.