Brief
As a developers I would like to have the ability to insert a custom dataset to the grid component in a way that would preserve its filter and pagination functionality if possible.
There are three situations in which this is very handy:
1. Entity centric grids but with some additional calculated columns
For example the orders colummn in: http://wiki.qcadoo.org/display/QCDMESBLP/Order+groups
We could use an non-persistent field for this. But it would have to do n-queries where n is the number of orders shown in the grid. There are also more complex examples that can follow this with sub-queries and other aggregations.
2. Fully calculated girds
Like the inventory table in: http://wiki.qcadoo.org/display/QCDMESBLP/Inventory+Module
This is a fully calculated view not related with any.
3. Grids with complex filters
4. Grids with datasets calculated in Java
5. Fully with unspecified columns (week requirement)
Like in the module: http://wiki.qcadoo.org/display/QCDMESBLP/Custom+query+module