silvershop / silverstripe-sqlquerylist

Wraps a SilverStripe SQLQuery in a SS_List

Maintainers

Details

github.com/silvershop/silverstripe-sqlquerylist

Source

Issues

Installs: 31 728

Dependents: 3

Suggesters: 0

Security: 0

Stars: 4

Watchers: 7

Forks: 4

Open Issues: 0

Type:silverstripe-vendormodule

3.0.0 2023-09-14 06:12 UTC

Requires

silverstripe/framework: ^5

Requires (Dev)

None

Suggests

None

Provides

None

Conflicts

None

Replaces

None

BSD-3-Clause 224a4693278a06cd824be23c65b511c24904ef8c

query list silverstripe

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

This package is auto-updated.

Last update: 2024-11-27 16:30:40 UTC

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.