We’ve multiple grids on a page. All the grids retrieve the information from same table, but are shown in each grid according to ‘idState’ column in the db table. Each grid can have hundreds of data, but only 20 are shown in each one. All grids use CActiveDataProvider. The question is, is there any way/tip/trick to only do one query for all instead of one per grid?