silvershop / silverstripe-sqlquerylist

Wraps a SilverStripe SQLQuery in a SS_List

Maintainers

Details

github.com/silvershop/silverstripe-sqlquerylist

Installs: 21 381

Type:silverstripe-vendormodule

2.0.0 2022-07-19 08:17 UTC

Requires

silverstripe/framework: ^4.0

Requires (Dev)

None

Suggests

None

Provides

None

Conflicts

None

Replaces

None

BSD-3-Clause 3d828e57da6a8c3dcb6cd36192598df5e9367285

query list silverstripe

dev-main / 2.x-dev
2.0.0
1.x-dev
1.0.1
1.0.0

This package is auto-updated.

Last update: 2023-03-27 02:41:27 UTC

README

Create DB-driven SS_Lists based directly off a SQLQuery. Particularly useful for reporting.

For the SilverStripe 3.x compatible version of this module, use the 1.x release.

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.