burnbright / silverstripe-sqlquerylist
Wraps a SilverStripe SQLQuery in a SS_List
Installs: 23 094
Dependents: 1
Suggesters: 0
Security: 0
Stars: 4
Watchers: 6
Forks: 4
Open Issues: 1
Type:silverstripe-vendormodule
Requires
README
Create DB-driven SS_Lists based directly off a SQLQuery
. Particularly useful for reporting.
composer require silvershop/silverstripe-sqlquerylist
But why?
The SilverStripe ORM doesn't allow you to work with advanced SQLQueries. You could pass the output of a SQLQuery to an ArrayList, but this approach will always retrieve all records, which can mean memory gets used up.
Records can only be displayed, ordered and filtered. Adding / removing and manipulating records does not work.