abstract class RelationList extends DataList implements Relation (View source)

A DataList that represents a relation.

Adds the notion of a foreign ID that can be optionally set.

Traits

Allows an object to have extensions applied to it.

A class that can be instantiated or replaced via DI

Provides extensions to this object to integrate it with standard config API methods.

Allows an object to declare a set of custom methods

Config options

extensions array

An array of extension names and parameters to be applied to this object upon construction.

from  Extensible
unextendable_classes array

Classes that cannot be extended

from  Extensible
casting array

An array of objects to cast certain fields to. This is set up as an array in the format:

from  ViewableData
default_cast string

The default object to cast scalar fields to if casting information is not specified, and casting to an object is required.

from  ViewableData
casting_cache array from  ViewableData
use_placeholders_for_integer_ids bool

Whether to use placeholders for integer IDs on Primary and Foriegn keys during a WHERE IN query It is significantly faster to not use placeholders

from  DataList

Properties

protected static array $extra_methods

Custom method sources

from  CustomMethods
protected array $extra_method_registers

Name of methods to invoke by defineMethods for this instance

from  CustomMethods
protected static array $built_in_methods

Non-custom public methods.

from  CustomMethods
protected Extension[] $extension_instances from  Extensible
protected callable[][] $beforeExtendCallbacks

List of callbacks to call prior to extensions having extend called on them, each grouped by methodName.

from  Extensible
protected callable[][] $afterExtendCallbacks

List of callbacks to call after extensions having extend called on them, each grouped by methodName.

from  Extensible
protected ViewableData $failover

A failover object to attempt to get data from if it is not present on this object.

from  ViewableData
protected ViewableData $customisedObject from  ViewableData
protected string $dataClass

The DataObject class name that this data list is querying

from  DataList
protected DataQuery $dataQuery

The DataQuery object responsible for getting this DataList's records

from  DataList
protected Query $finalisedQuery

A cached Query to save repeated database calls. {DataList::getTemplateIteratorCount()}

from  DataList
protected bool $inAlterDataQueryCall from  DataList
protected CallbackList|null $addCallbacks
protected CallbackList|null $removeCallbacks

Methods

public
mixed
__call(string $method, array $arguments)

Attempts to locate and call a method dynamically added to a class at runtime if a default cannot be located

protected
defineMethods()

Adds any methods from Extension instances attached to this object.

protected
registerExtraMethodCallback(string $name, callable $callback)

Register an callback to invoke that defines extra methods

public
bool
hasMethod(string $method)

Return TRUE if a method exists on this object

protected
bool
hasCustomMethod($method)

Determines if a custom method with this name is defined.

protected
array
getExtraMethodConfig(string $method)

Get meta-data details on a named method

public
array
allMethodNames(bool $custom = false)

Return the names of all the methods available on this object

protected static 
array
findBuiltInMethods(string|object $class = null)

Get all public built in methods for this class

protected
array
findMethodsFrom(object $object)

Find all methods on the given object.

protected
addMethodsFrom(string $property, string|int $index = null)

Add all the methods from an object property.

protected
removeMethodsFrom(string $property, string|int $index = null)

Add all the methods from an object property (which is an Extension) to this object.

protected
addWrapperMethod(string $method, string $wrap)

Add a wrapper method - a method which points to another method with a different name. For example, Thumbnail(x) can be wrapped to generateThumbnail(x)

protected
addCallbackMethod(string $method, callable $callback)

Add callback as a method.

protected
beforeExtending(string $method, callable $callback)

Allows user code to hook into Object::extend prior to control being delegated to extensions. Each callback will be reset once called.

protected
afterExtending(string $method, callable $callback)

Allows user code to hook into Object::extend after control being delegated to extensions. Each callback will be reset once called.

protected
defineExtensionMethods()

Adds any methods from Extension instances attached to this object.

public static 
bool
add_extension(string $classOrExtension, string $extension = null)

Add an extension to a specific class.

public static 
remove_extension(string $extension)

Remove an extension from a class.

public static 
array
get_extensions(string $class = null, bool $includeArgumentString = false)

No description

public static 
array|null
get_extra_config_sources(string $class = null)

Get extra config sources for this class

public static 
bool
has_extension(string $classOrExtension, string $requiredExtension = null, bool $strict = false)

Return TRUE if a class has a specified extension.

public
array
invokeWithExtensions(string $method, mixed ...$arguments)

Calls a method if available on both this object and all applied Extensions, and then attempts to merge all results into an array

public
array
extend(string $method, mixed ...$arguments)

Run the given function on all of this object's extensions. Note that this method originally returned void, so if you wanted to return results, you're hosed

public
Extension|null
getExtensionInstance(string $extension)

Get an extension instance attached to this object by name.

public
bool
hasExtension(string $extension)

Returns TRUE if this object instance has a specific extension applied in $extension_instances. Extension instances are initialized at constructor time, meaning if you use add_extension() afterwards, the added extension will just be added to new instances of the extended class. Use the static method has_extension() to check if a class (not an instance) has a specific extension.

public
getExtensionInstances()

Get all extension instances for this specific object instance.

public static 
create(mixed ...$args)

An implementation of the factory method, allows you to create an instance of a class

public static 
singleton(string $class = null)

Creates a class instance by the "singleton" design pattern.

public static 
config()

Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).

public
mixed
uninherited(string $name)

Gets the uninherited value for the given config option

public
__construct(string $dataClass)

Create a new DataList.

from  DataList
public
bool
__isset(string $property)

Check if a field exists on this object or its failover.

public
mixed
__get(string $property)

Get the value of a property/field on this object. This will check if a method called get{$property} exists, then check if a field is available using ViewableData::getField(), then fall back on a failover object.

public
__set(string $property, mixed $value)

Set a property/field on this object. This will check for the existence of a method called set{$property}, then use the ViewableData::setField() method.

public
setFailover(ViewableData $failover)

Set a failover object to attempt to get data from if it is not present on this object.

public
getFailover()

Get the current failover object if set

public
bool
hasField(string $field)

Check if a field exists on this object. This should be overloaded in child classes.

public
mixed
getField(string $field)

Get the value of a field on this object. This should be overloaded in child classes.

public
$this
setField(string $field, mixed $value)

Set a field on this object. This should be overloaded in child classes.

public
mixed
getDynamicData(string $field)

No description

public
setDynamicData(string $field, mixed $value)

No description

public
bool
hasDynamicData(string $field)

No description

public
customise(array|ViewableData $data)

Merge some arbitrary data in with this object. This method returns a ViewableData_Customised instance with references to both this and the new custom data.

public
bool
exists()

Returns true if this DataList has items

from  DataList
public
string
__toString()

No description

public
getCustomisedObj()

No description

public
setCustomisedObj(ViewableData $object)

No description

public
string
castingHelper(string $field)

Return the "casting helper" (a piece of PHP code that when evaluated creates a casted value object) for a field on this object. This helper will be a subclass of DBField.

public
string
castingClass(string $field)

Get the class name a field on this object will be casted to.

public
string
escapeTypeForField(string $field)

Return the string-format type for the given field.

public
renderWith(string|array|SSViewer $template, array $customFields = null)

Render this object into the template, and get the result as a string. You can pass one of the following as the $template parameter:

  • a template name (e.g. Page)
  • an array of possible template names - the first valid one will be used
  • an SSViewer instance

protected
string
objCacheName(string $fieldName, array $arguments)

Generate the cache name for a field

protected
mixed
objCacheGet(string $key)

Get a cached value from the field cache

protected
$this
objCacheSet(string $key, mixed $value)

Store a value in the field cache

protected
$this
objCacheClear()

Clear object cache

public
object|DBField
obj(string $fieldName, array $arguments = [], bool $cache = false, string $cacheName = null)

Get the value of a field on this object, automatically inserting the value into any available casting objects that have been specified.

public
object|DBField
cachedCall(string $fieldName, array $arguments = [], string $identifier = null)

A simple wrapper around ViewableData::obj() that automatically caches the result so it can be used again without re-running the method.

public
bool
hasValue(string $field, array $arguments = [], bool $cache = true)

Checks if a given method/field has a valid value. If the result is an object, this will return the result of the exists method, otherwise will check if the result is not just an empty paragraph tag.

public
string
XML_val(string $field, array $arguments = [], bool $cache = false)

Get the string value of a field on this object that has been suitable escaped to be inserted directly into a template.

public
array
getXMLValues(array $fields)

Get an array of XML-escaped values by field name

public
getIterator()

Returns an Iterator for this DataList.

from  DataList
public
array
getViewerTemplates(string $suffix = '')

Find appropriate templates for SSViewer to use to render this object

public
Me()

When rendering some objects it is necessary to iterate over the object being rendered, to do this, you need access to itself.

public
string
CSSClasses(string $stopAtClass = self::class)

Get part of the current classes ancestry to be used as a CSS class.

public
Debug()

Return debug information about this object that can be rendered into a template

protected
createSearchFilter(string $filter, mixed $value)

Given a filter expression and value construct a {SearchFilter} instance

public
string
dataClass()

Get the dataClass name for this DataList, ie the DataObject ClassName

from  DataList
public
__clone()

When cloning this object, clone the dataQuery object as well

from  DataList
public
dataQuery()

Return a copy of the internal DataQuery object

from  DataList
public
alterDataQuery(callable $callback)

Return a new DataList instance with the underlying DataQuery object altered

from  DataList
public
setDataQuery(DataQuery $dataQuery)

Return a new DataList instance with the underlying DataQuery object changed

from  DataList
public
setDataQueryParam(string|array $keyOrArray, mixed $val = null)

Returns a new DataList instance with the specified query parameter assigned

from  DataList
public
string
sql(array $parameters = [])

Returns the SQL query that will be used to get this DataList's records. Good for debugging. :-)

from  DataList
public
where(string|array|SQLConditionGroup $filter)

Return a new DataList instance with a WHERE clause added to this list's query.

from  DataList
public
whereAny(string|array|SQLConditionGroup $filter)

Return a new DataList instance with a WHERE clause added to this list's query.

from  DataList
public
bool
canSortBy(string $fieldName)

Returns true if this DataList can be sorted by the given field.

from  DataList
public
bool
canFilterBy(string $fieldName)

Returns true if this DataList can be filtered by the given field.

from  DataList
public
limit(int|null $length, int $offset = 0)

Return a new DataList instance with the records returned in this query restricted by a limit clause.

from  DataList
public
distinct(bool $value)

Return a new DataList instance with distinct records or not

from  DataList
public
sort(string|array ...$args)

Return a new DataList instance as a copy of this data list with the sort order set

from  DataList
public
orderBy(string $orderBy)

Set an explicit ORDER BY statement using raw SQL

from  DataList
public
filter()

Return a copy of this list which only includes items with these characteristics

from  DataList
public
$this
addFilter(array $filterArray)

Return a new instance of the list with an added filter

from  DataList
public
filterAny()

Return a copy of this list which contains items matching any of these characteristics.

from  DataList
public
filterByCallback(callable $callback)

Note that, in the current implementation, the filtered list will be an ArrayList, but this may change in a future implementation.

from  DataList
public
$this
applyRelation(string $field, string $columnName = null, bool $linearOnly = false)

Given a field or relation name, apply it safely to this datalist.

from  DataList
protected
bool
isValidRelationName(string $field)

Check if the given field specification could be interpreted as an unquoted relation name

from  DataList
public
exclude()

Return a copy of this list which does not contain any items that match all params

from  DataList
public
$this
excludeAny()

Return a copy of this list which does not contain any items with any of these params

from  DataList
public
subtract(DataList $list)

This method returns a copy of this list that does not contain any DataObjects that exists in $list

from  DataList
public
innerJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with an inner join clause added to this list's query.

from  DataList
public
leftJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with a left join clause added to this list's query.

from  DataList
public
rightJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with a right join clause added to this list's query.

from  DataList
public
array
toArray()

Return an array of the actual items that this DataList contains at this stage.

from  DataList
public
array
toNestedArray()

Return this list as an array and every object it as an sub array as well

from  DataList
public
$this
each(callable $callback)

Walks the list using the specified callback

from  DataList
public
debug()

No description

from  DataList
public
Map
map(string $keyField = 'ID', string $titleField = 'Title')

Returns a map of this list

from  DataList
public
createDataObject(array $row)

Create a DataObject from the given SQL row If called without $row['ID'] set, then a new object will be created rather than rehydrated.

from  DataList
public
array
getQueryParams()

Get query parameters for this list.

public
eagerLoad(...$relationChains)

Eager load relations for DataObjects in this DataList including nested relations

from  DataList
public
int
count()

Return the number of items in this DataList

from  DataList
public
mixed
max(string $fieldName)

Return the maximum value of the given field in this DataList

from  DataList
public
mixed
min(string $fieldName)

Return the minimum value of the given field in this DataList

from  DataList
public
mixed
avg(string $fieldName)

Return the average value of the given field in this DataList

from  DataList
public
mixed
sum(string $fieldName)

Return the sum of the values of the given field in this DataList

from  DataList
public
mixed
first()

Returns the first item in this DataList (instanceof DataObject)

from  DataList
public
mixed
last()

Returns the last item in this DataList (instanceof DataObject)

from  DataList
public
mixed
find(string $key, mixed $value)

Find the first DataObject of this DataList where the given key = value

from  DataList
public
setQueriedColumns(array $queriedColumns)

Restrict the columns to fetch into this DataList

from  DataList
public
byIDs(array $ids)

Filter this list to only contain the given Primary IDs

from  DataList
public
mixed
byID(int $id)

Return the first DataObject with the given ID

from  DataList
public
array
column(string $colName = "ID")

Returns an array of a single field value for all items in the list.

from  DataList
public
array
columnUnique(string $colName = "ID")

Returns a unique array of a single field value for all items in the list.

from  DataList
public
setByIDList(array $idList)

Sets the ComponentSet to be the given ID list.

from  DataList
public
array
getIDList()

Returns an array with both the keys and values set to the IDs of the records in this list.

from  DataList
public
relation(string $relationName)

Returns a HasManyList or ManyMany list representing the querying of a relation across all objects in this data list. For it to work, the relation must be defined on the data class that you used to create this DataList.

from  DataList
public
dbObject($fieldName)

No description

from  DataList
public
$this
addMany(array $items)

Add a number of items to the component set.

from  DataList
public
$this
removeMany(array $idList)

Remove the items from this list with the given IDs

from  DataList
public
$this
removeByFilter(string|array $filter)

Remove every element in this DataList matching the given $filter.

from  DataList
public
$this
shuffle()

Shuffle the datalist using a random function provided by the SQL engine

from  DataList
public
$this
removeAll()

Remove every element in this DataList.

from  DataList
public
add(mixed $item)

This method are overloaded by HasManyList and ManyMany list to perform more sophisticated list manipulation

from  DataList
public
newObject(array $initialFields = null)

Return a new item to add to this DataList.

from  DataList
public
remove(mixed $item)

Remove this item by deleting it

from  DataList
public
removeByID(int $itemID)

Remove an item from this DataList by ID

from  DataList
public
reverse()

Reverses a list of items.

from  DataList
public
bool
offsetExists(mixed $key)

Returns whether an item with $key exists

from  DataList
public
DataObject|null
offsetGet(mixed $key)

Returns item stored in list with index $key

from  DataList
public
void
offsetSet(mixed $key, mixed $value)

Set an item with the key in $key

from  DataList
public
void
offsetUnset(mixed $key)

Unset an item with the key in $key

from  DataList
public
iterable
chunkedFetch(int $chunkSize = 1000)

Iterate over this DataList in "chunks". This will break the query in smaller subsets and avoid loading the entire result set in memory at once. Beware not to perform any operations on the results that might alter the return order. Otherwise, you might break subsequent chunks.

from  DataList
public
CallbackList
addCallbacks()

Manage callbacks which are called after the add() action is completed.

public
CallbackList
removeCallbacks()

Manage callbacks which are called after the remove() action is completed.

public
string|array|null
getForeignID()

Any number of foreign keys to apply to this list

public
forForeignID(mixed $id)

Returns a copy of this list with the ManyMany relationship linked to the given foreign ID.

protected
array
foreignIDFilter(array|int $id = null)

Returns a where clause that filters the members of this relationship to just the related items.

protected
string
prepareForeignIDsForWhereInClause(array $ids)

Prepare an array of IDs for a 'WHERE IN` clause deciding if we should use placeholders Current rules are to use not use placeholders, unless:

  • SilverStripe\ORM\DataList.use_placeholders_for_integer_ids is set to false, or
  • Any of the IDs values being filtered are not integers or valid integer strings

Details

mixed __call(string $method, array $arguments)

Attempts to locate and call a method dynamically added to a class at runtime if a default cannot be located

You can add extra methods to a class using Extensions}, {@link Object::createMethod() or Object::addWrapperMethod()

Parameters

string $method
array $arguments

Return Value

mixed

Exceptions

BadMethodCallException

protected defineMethods()

Adds any methods from Extension instances attached to this object.

All these methods can then be called directly on the instance (transparently mapped through __call()}), or called explicitly through {@link extend().

protected registerExtraMethodCallback(string $name, callable $callback)

Register an callback to invoke that defines extra methods

Parameters

string $name
callable $callback

bool hasMethod(string $method)

Return TRUE if a method exists on this object

This should be used rather than PHP's inbuild method_exists() as it takes into account methods added via extensions

Parameters

string $method

Return Value

bool

protected bool hasCustomMethod($method)

Determines if a custom method with this name is defined.

Parameters

$method

Return Value

bool

protected array getExtraMethodConfig(string $method)

Get meta-data details on a named method

Parameters

string $method

Return Value

array

List of custom method details, if defined for this method

array allMethodNames(bool $custom = false)

Return the names of all the methods available on this object

Parameters

bool $custom

include methods added dynamically at runtime

Return Value

array

Map of method names with lowercase keys

static protected array findBuiltInMethods(string|object $class = null)

Get all public built in methods for this class

Parameters

string|object $class

Class or instance to query methods from (defaults to static::class)

Return Value

array

Map of methods with lowercase key name

protected array findMethodsFrom(object $object)

Find all methods on the given object.

Parameters

object $object

Return Value

array

protected addMethodsFrom(string $property, string|int $index = null)

Add all the methods from an object property.

Parameters

string $property

the property name

string|int $index

an index to use if the property is an array

Exceptions

InvalidArgumentException

protected removeMethodsFrom(string $property, string|int $index = null)

Add all the methods from an object property (which is an Extension) to this object.

Parameters

string $property

the property name

string|int $index

an index to use if the property is an array

protected addWrapperMethod(string $method, string $wrap)

Add a wrapper method - a method which points to another method with a different name. For example, Thumbnail(x) can be wrapped to generateThumbnail(x)

Parameters

string $method

the method name to wrap

string $wrap

the method name to wrap to

protected addCallbackMethod(string $method, callable $callback)

Add callback as a method.

Parameters

string $method

Name of method

callable $callback

Callback to invoke. Note: $this is passed as first parameter to this callback and then $args as array

protected beforeExtending(string $method, callable $callback)

Allows user code to hook into Object::extend prior to control being delegated to extensions. Each callback will be reset once called.

Parameters

string $method

The name of the method to hook into

callable $callback

The callback to execute

protected afterExtending(string $method, callable $callback)

Allows user code to hook into Object::extend after control being delegated to extensions. Each callback will be reset once called.

Parameters

string $method

The name of the method to hook into

callable $callback

The callback to execute

protected defineExtensionMethods()

Adds any methods from Extension instances attached to this object.

All these methods can then be called directly on the instance (transparently mapped through __call()}), or called explicitly through {@link extend().

static bool add_extension(string $classOrExtension, string $extension = null)

Add an extension to a specific class.

The preferred method for adding extensions is through YAML config, since it avoids autoloading the class, and is easier to override in more specific configurations.

As an alternative, extensions can be added to a specific class directly in the Object::$extensions array. See SiteTree::$extensions for examples. Keep in mind that the extension will only be applied to new instances, not existing ones (including all instances created through singleton()).

Parameters

string $classOrExtension

Class that should be extended - has to be a subclass of Object

string $extension

Subclass of Extension with optional parameters as a string, e.g. "Versioned"

Return Value

bool

Flag if the extension was added

See also

http://doc.silverstripe.org/framework/en/trunk/reference/dataextension

static remove_extension(string $extension)

Remove an extension from a class.

Note: This will not remove extensions from parent classes, and must be called directly on the class assigned the extension.

Keep in mind that this won't revert any datamodel additions of the extension at runtime, unless its used before the schema building kicks in (in your _config.php). Doesn't remove the extension from any Object instances which are already created, but will have an effect on new extensions. Clears any previously created singletons through singleton() to avoid side-effects from stale extension information.

Parameters

string $extension

class name of an Extension subclass, without parameters

static array get_extensions(string $class = null, bool $includeArgumentString = false)

No description

Parameters

string $class

If omitted, will get extensions for the current class

bool $includeArgumentString

Include the argument string in the return array, FALSE would return array("Versioned"), TRUE returns array("Versioned('Stage','Live')").

Return Value

array

Numeric array of either DataExtension class names, or eval'ed class name strings with constructor arguments.

static array|null get_extra_config_sources(string $class = null)

Get extra config sources for this class

Parameters

string $class

Name of class. If left null will return for the current class

Return Value

array|null

static bool has_extension(string $classOrExtension, string $requiredExtension = null, bool $strict = false)

Return TRUE if a class has a specified extension.

This supports backwards-compatible format (static Object::has_extension($requiredExtension)) and new format ($object->has_extension($class, $requiredExtension))

Parameters

string $classOrExtension

Class to check extension for, or the extension name to check if the second argument is null.

string $requiredExtension

If the first argument is the parent class, this is the extension to check. If left null, the first parameter will be treated as the extension.

bool $strict

if the extension has to match the required extension and not be a subclass

Return Value

bool

Flag if the extension exists

array invokeWithExtensions(string $method, mixed ...$arguments)

Calls a method if available on both this object and all applied Extensions, and then attempts to merge all results into an array

Parameters

string $method

the method name to call

mixed ...$arguments

List of arguments

Return Value

array

List of results with nulls filtered out

array extend(string $method, mixed ...$arguments)

Run the given function on all of this object's extensions. Note that this method originally returned void, so if you wanted to return results, you're hosed

Currently returns an array, with an index resulting every time the function is called. Only adds returns if they're not NULL, to avoid bogus results from methods just defined on the parent extension. This is important for permission-checks through extend, as they use min() to determine if any of the returns is FALSE. As min() doesn't do type checking, an included NULL return would fail the permission checks.

The extension methods are defined during __construct()} in {@link defineMethods().

Parameters

string $method

the name of the method to call on each extension

mixed ...$arguments

Return Value

array

Extension|null getExtensionInstance(string $extension)

Get an extension instance attached to this object by name.

Parameters

string $extension

Return Value

Extension|null

bool hasExtension(string $extension)

Returns TRUE if this object instance has a specific extension applied in $extension_instances. Extension instances are initialized at constructor time, meaning if you use add_extension() afterwards, the added extension will just be added to new instances of the extended class. Use the static method has_extension() to check if a class (not an instance) has a specific extension.

Caution: Don't use singleton()->hasExtension() as it will give you inconsistent results based on when the singleton was first accessed.

Parameters

string $extension

Classname of an Extension subclass without parameters

Return Value

bool

Extension[] getExtensionInstances()

Get all extension instances for this specific object instance.

See get_extensions() to get all applied extension classes for this class (not the instance).

This method also provides lazy-population of the extension_instances property.

Return Value

Extension[]

Map of DataExtension instances, keyed by classname.

static Injectable create(mixed ...$args)

An implementation of the factory method, allows you to create an instance of a class

This method will defer class substitution to the Injector API, which can be customised via the Config API to declare substitution classes.

This can be called in one of two ways - either calling via the class directly, or calling on Object and passing the class name as the first parameter. The following are equivalent: $list = DataList::create(SiteTree::class); $list = SiteTree::get();

Parameters

mixed ...$args

Return Value

Injectable

static Injectable singleton(string $class = null)

Creates a class instance by the "singleton" design pattern.

It will always return the same instance for this class, which can be used for performance reasons and as a simple way to access instance methods which don't rely on instance data (e.g. the custom SilverStripe static handling).

Parameters

string $class

Optional classname to create, if the called class should not be used

Return Value

Injectable

The singleton instance

static Config_ForClass config()

Get a configuration accessor for this class. Short hand for Config::inst()->get($this->class, .....).

Return Value

Config_ForClass

mixed uninherited(string $name)

Gets the uninherited value for the given config option

Parameters

string $name

Return Value

mixed

__construct(string $dataClass)

Create a new DataList.

No querying is done on construction, but the initial query schema is set up.

Parameters

string $dataClass
  • The DataObject class to query.

bool __isset(string $property)

Check if a field exists on this object or its failover.

Note that, unlike the core isset() implementation, this will return true if the property is defined and set to null.

Parameters

string $property

Return Value

bool

mixed __get(string $property)

Get the value of a property/field on this object. This will check if a method called get{$property} exists, then check if a field is available using ViewableData::getField(), then fall back on a failover object.

Parameters

string $property

Return Value

mixed

__set(string $property, mixed $value)

Set a property/field on this object. This will check for the existence of a method called set{$property}, then use the ViewableData::setField() method.

Parameters

string $property
mixed $value

setFailover(ViewableData $failover)

Set a failover object to attempt to get data from if it is not present on this object.

Parameters

ViewableData $failover

ViewableData|null getFailover()

Get the current failover object if set

Return Value

ViewableData|null

bool hasField(string $field)

Check if a field exists on this object. This should be overloaded in child classes.

Parameters

string $field

Return Value

bool

mixed getField(string $field)

Get the value of a field on this object. This should be overloaded in child classes.

Parameters

string $field

Return Value

mixed

$this setField(string $field, mixed $value)

Set a field on this object. This should be overloaded in child classes.

Parameters

string $field
mixed $value

Return Value

$this

mixed getDynamicData(string $field)

No description

Parameters

string $field

Return Value

mixed

ViewableData setDynamicData(string $field, mixed $value)

No description

Parameters

string $field
mixed $value

Return Value

ViewableData

bool hasDynamicData(string $field)

No description

Parameters

string $field

Return Value

bool

ViewableData_Customised customise(array|ViewableData $data)

Merge some arbitrary data in with this object. This method returns a ViewableData_Customised instance with references to both this and the new custom data.

Note that any fields you specify will take precedence over the fields on this object.

Parameters

array|ViewableData $data

Return Value

ViewableData_Customised

bool exists()

Returns true if this DataList has items

Return Value

bool

string __toString()

No description

Return Value

string

the class name

ViewableData getCustomisedObj()

No description

Return Value

ViewableData

setCustomisedObj(ViewableData $object)

No description

Parameters

ViewableData $object

string castingHelper(string $field)

Return the "casting helper" (a piece of PHP code that when evaluated creates a casted value object) for a field on this object. This helper will be a subclass of DBField.

Parameters

string $field

Return Value

string

Casting helper As a constructor pattern, and may include arguments.

Exceptions

Exception

string castingClass(string $field)

Get the class name a field on this object will be casted to.

Parameters

string $field

Return Value

string

string escapeTypeForField(string $field)

Return the string-format type for the given field.

Parameters

string $field

Return Value

string 'xml'|'raw'

DBHTMLText renderWith(string|array|SSViewer $template, array $customFields = null)

Render this object into the template, and get the result as a string. You can pass one of the following as the $template parameter:

  • a template name (e.g. Page)
  • an array of possible template names - the first valid one will be used
  • an SSViewer instance

Parameters

string|array|SSViewer $template

the template to render into

array $customFields

fields to customise() the object with before rendering

Return Value

DBHTMLText

protected string objCacheName(string $fieldName, array $arguments)

Generate the cache name for a field

Parameters

string $fieldName

Name of field

array $arguments

List of optional arguments given

Return Value

string

protected mixed objCacheGet(string $key)

Get a cached value from the field cache

Parameters

string $key

Cache key

Return Value

mixed

protected $this objCacheSet(string $key, mixed $value)

Store a value in the field cache

Parameters

string $key

Cache key

mixed $value

Return Value

$this

protected $this objCacheClear()

Clear object cache

Return Value

$this

object|DBField obj(string $fieldName, array $arguments = [], bool $cache = false, string $cacheName = null)

Get the value of a field on this object, automatically inserting the value into any available casting objects that have been specified.

Parameters

string $fieldName
array $arguments
bool $cache

Cache this object

string $cacheName

a custom cache name

Return Value

object|DBField

object|DBField cachedCall(string $fieldName, array $arguments = [], string $identifier = null)

A simple wrapper around ViewableData::obj() that automatically caches the result so it can be used again without re-running the method.

Parameters

string $fieldName
array $arguments
string $identifier

an optional custom cache identifier

Return Value

object|DBField

bool hasValue(string $field, array $arguments = [], bool $cache = true)

Checks if a given method/field has a valid value. If the result is an object, this will return the result of the exists method, otherwise will check if the result is not just an empty paragraph tag.

Parameters

string $field
array $arguments
bool $cache

Return Value

bool

string XML_val(string $field, array $arguments = [], bool $cache = false)

Get the string value of a field on this object that has been suitable escaped to be inserted directly into a template.

Parameters

string $field
array $arguments
bool $cache

Return Value

string

array getXMLValues(array $fields)

Get an array of XML-escaped values by field name

Parameters

array $fields

an array of field names

Return Value

array

Traversable getIterator()

Returns an Iterator for this DataList.

This function allows you to use DataLists in foreach loops

Return Value

Traversable

array getViewerTemplates(string $suffix = '')

Find appropriate templates for SSViewer to use to render this object

Parameters

string $suffix

Return Value

array

ViewableData Me()

When rendering some objects it is necessary to iterate over the object being rendered, to do this, you need access to itself.

Return Value

ViewableData

string CSSClasses(string $stopAtClass = self::class)

Get part of the current classes ancestry to be used as a CSS class.

This method returns an escaped string of CSS classes representing the current classes ancestry until it hits a stop point - e.g. "Page DataObject ViewableData".

Parameters

string $stopAtClass

the class to stop at (default: ViewableData)

Return Value

string

ViewableData_Debugger Debug()

Return debug information about this object that can be rendered into a template

Return Value

ViewableData_Debugger

protected SearchFilter createSearchFilter(string $filter, mixed $value)

Given a filter expression and value construct a {SearchFilter} instance

Parameters

string $filter

E.g. Name:ExactMatch:not, Name:ExactMatch, Name:not, Name

mixed $value

Value of the filter

Return Value

SearchFilter

string dataClass()

Get the dataClass name for this DataList, ie the DataObject ClassName

Return Value

string

__clone()

When cloning this object, clone the dataQuery object as well

DataQuery dataQuery()

Return a copy of the internal DataQuery object

Because the returned value is a copy, modifying it won't affect this list's contents. If you want to alter the data query directly, use the alterDataQuery method

Return Value

DataQuery

DataList alterDataQuery(callable $callback)

Return a new DataList instance with the underlying DataQuery object altered

If you want to alter the underlying dataQuery for this list, this wrapper method will ensure that you can do so without mutating the existing List object.

It clones this list, calls the passed callback function with the dataQuery of the new list as it's first parameter (and the list as it's second), then returns the list

Note that this function is re-entrant - it's safe to call this inside a callback passed to alterDataQuery

Parameters

callable $callback

Return Value

DataList

Exceptions

Exception

DataList setDataQuery(DataQuery $dataQuery)

Return a new DataList instance with the underlying DataQuery object changed

Parameters

DataQuery $dataQuery

Return Value

DataList

DataList setDataQueryParam(string|array $keyOrArray, mixed $val = null)

Returns a new DataList instance with the specified query parameter assigned

Parameters

string|array $keyOrArray

Either the single key to set, or an array of key value pairs to set

mixed $val

If $keyOrArray is not an array, this is the value to set

Return Value

DataList

string sql(array $parameters = [])

Returns the SQL query that will be used to get this DataList's records. Good for debugging. :-)

Parameters

array $parameters

Out variable for parameters required for this query

Return Value

string

The resulting SQL query (may be parameterised)

DataList where(string|array|SQLConditionGroup $filter)

Return a new DataList instance with a WHERE clause added to this list's query.

This method accepts raw SQL so could be vulnerable to SQL injection attacks if used incorrectly, it's preferable to use filter() instead which does not allow raw SQL.

Supports parameterised queries. See SQLSelect::addWhere() for syntax examples, although DataList won't expand multiple method arguments as SQLSelect does.

Parameters

string|array|SQLConditionGroup $filter

Predicate(s) to set, as escaped SQL statements or paramaterised queries

Return Value

DataList

DataList whereAny(string|array|SQLConditionGroup $filter)

Return a new DataList instance with a WHERE clause added to this list's query.

All conditions provided in the filter will be joined with an OR

This method accepts raw SQL so could be vulnerable to SQL injection attacks if used incorrectly, it's preferable to use filterAny() instead which does not allow raw SQL

Supports parameterised queries. See SQLSelect::addWhere() for syntax examples, although DataList won't expand multiple method arguments as SQLSelect does.

Parameters

string|array|SQLConditionGroup $filter

Predicate(s) to set, as escaped SQL statements or paramaterised queries

Return Value

DataList

bool canSortBy(string $fieldName)

Returns true if this DataList can be sorted by the given field.

Parameters

string $fieldName

Return Value

bool

bool canFilterBy(string $fieldName)

Returns true if this DataList can be filtered by the given field.

Parameters

string $fieldName

(May be a related field in dot notation like Member.FirstName)

Return Value

bool

Limitable limit(int|null $length, int $offset = 0)

Return a new DataList instance with the records returned in this query restricted by a limit clause.

Parameters

int|null $length
int $offset

Return Value

Limitable

DataList distinct(bool $value)

Return a new DataList instance with distinct records or not

Parameters

bool $value

Return Value

DataList

Sortable sort(string|array ...$args)

Return a new DataList instance as a copy of this data list with the sort order set

Raw SQL is not accepted, only actual field names can be passed

Parameters

string|array ...$args

Return Value

Sortable

Examples

$list = $list->sort('Name'); // default ASC sorting
$list = $list->sort('"Name"'); // field names can have double quotes around them
$list = $list->sort('Name ASC, Age DESC');
$list = $list->sort('Name', 'ASC');
$list = $list->sort(['Name' => 'ASC', 'Age' => 'DESC']);
$list = $list->sort('MyRelation.MyColumn ASC')
$list->sort(null); // wipe any existing sort

DataList orderBy(string $orderBy)

Set an explicit ORDER BY statement using raw SQL

This method accepts raw SQL so could be vulnerable to SQL injection attacks if used incorrectly, it's preferable to use sort() instead which does not allow raw SQL

Parameters

string $orderBy

Return Value

DataList

Filterable filter()

Return a copy of this list which only includes items with these characteristics

Raw SQL is not accepted, only actual field names can be passed

Return Value

Filterable

See also

Filterable::filter

Examples

$list = $list->filter('Name', 'bob'); // only bob in the list
$list = $list->filter('Name', array('aziz', 'bob'); // aziz and bob in list
$list = $list->filter(array('Name'=>'bob', 'Age'=>21)); // bob with the age 21
$list = $list->filter(array('Name'=>'bob', 'Age'=>array(21, 43))); // bob with the Age 21 or 43
$list = $list->filter(array('Name'=>array('aziz','bob'), 'Age'=>array(21, 43)));
         // aziz with the age 21 or 43 and bob with the Age 21 or 43

Note: When filtering on nullable columns, null checks will be automatically added.
E.g. ->filter('Field:not', 'value) will generate '... OR "Field" IS NULL', and
->filter('Field:not', null) will generate '"Field" IS NOT NULL'

$this addFilter(array $filterArray)

Return a new instance of the list with an added filter

Parameters

array $filterArray

Return Value

$this

Filterable filterAny()

Return a copy of this list which contains items matching any of these characteristics.

Raw SQL is not accepted, only actual field names can be passed

Return Value

Filterable

Examples

// only bob in the list
$list = $list->filterAny('Name', 'bob');
// SQL: WHERE "Name" = 'bob'
// azis or bob in the list
$list = $list->filterAny('Name', array('aziz', 'bob');
// SQL: WHERE ("Name" IN ('aziz','bob'))
// bob or anyone aged 21 in the list
$list = $list->filterAny(array('Name'=>'bob, 'Age'=>21));
// SQL: WHERE ("Name" = 'bob' OR "Age" = '21')
// bob or anyone aged 21 or 43 in the list
$list = $list->filterAny(array('Name'=>'bob, 'Age'=>array(21, 43)));
// SQL: WHERE ("Name" = 'bob' OR ("Age" IN ('21', '43'))
// all bobs, phils or anyone aged 21 or 43 in the list
$list = $list->filterAny(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43)));
// SQL: WHERE (("Name" IN ('bob', 'phil')) OR ("Age" IN ('21', '43'))

Filterable filterByCallback(callable $callback)

Note that, in the current implementation, the filtered list will be an ArrayList, but this may change in a future implementation.

Parameters

callable $callback

Return Value

Filterable

See also

Filterable::filterByCallback

Examples

$list = $list->filterByCallback(function($item, $list) { return $item->Age == 9; })

$this applyRelation(string $field, string $columnName = null, bool $linearOnly = false)

Given a field or relation name, apply it safely to this datalist.

Unlike getRelationName, this is immutable and will fallback to the quoted field name if not a relation.

Example use (simple WHERE condition on data sitting in a related table):

 $columnName = null;
 $list = Page::get()
   ->applyRelation('TaxonomyTerms.ID', $columnName)
   ->where([$columnName => 'my value']);

Parameters

string $field

Name of field or relation to apply

string $columnName

Quoted column name (by reference)

bool $linearOnly

Set to true to restrict to linear relations only. Set this if this relation will be used for sorting, and should not include duplicate rows.

Return Value

$this

DataList with this relation applied

protected bool isValidRelationName(string $field)

Check if the given field specification could be interpreted as an unquoted relation name

Parameters

string $field

Return Value

bool

Filterable exclude()

Return a copy of this list which does not contain any items that match all params

Raw SQL is not accepted, only actual field names can be passed

Return Value

Filterable

Examples

$list = $list->exclude('Name', 'bob'); // exclude bob from list
$list = $list->exclude('Name', array('aziz', 'bob'); // exclude aziz and bob from list
$list = $list->exclude(array('Name'=>'bob, 'Age'=>21)); // exclude bob that has Age 21
$list = $list->exclude(array('Name'=>'bob, 'Age'=>array(21, 43))); // exclude bob with Age 21 or 43
$list = $list->exclude(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43)));
// bob age 21 or 43, phil age 21 or 43 would be excluded

$this excludeAny()

Return a copy of this list which does not contain any items with any of these params

Raw SQL is not accepted, only actual field names can be passed

Return Value

$this

Examples

$list = $list->excludeAny('Name', 'bob'); // exclude bob from list
$list = $list->excludeAny('Name', array('aziz', 'bob'); // exclude aziz and bob from list
$list = $list->excludeAny(array('Name'=>'bob, 'Age'=>21)); // exclude bob or Age 21
$list = $list->excludeAny(array('Name'=>'bob, 'Age'=>array(21, 43))); // exclude bob or Age 21 or 43
$list = $list->excludeAny(array('Name'=>array('bob','phil'), 'Age'=>array(21, 43)));
// bob, phil, 21 or 43 would be excluded

DataList subtract(DataList $list)

This method returns a copy of this list that does not contain any DataObjects that exists in $list

The $list passed needs to contain the same dataclass as $this

Parameters

DataList $list

Return Value

DataList

Exceptions

InvalidArgumentException

DataList innerJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with an inner join clause added to this list's query.

Parameters

string $table

Table name (unquoted and as escaped SQL)

string $onClause

Escaped SQL statement, e.g. '"Table1"."ID" = "Table2"."ID"'

string $alias
  • if you want this table to be aliased under another name
int $order

A numerical index to control the order that joins are added to the query; lower order values will cause the query to appear first. The default is 20, and joins created automatically by the ORM have a value of 10.

array $parameters

Any additional parameters if the join is a parameterised subquery

Return Value

DataList

DataList leftJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with a left join clause added to this list's query.

Parameters

string $table

Table name (unquoted and as escaped SQL)

string $onClause

Escaped SQL statement, e.g. '"Table1"."ID" = "Table2"."ID"'

string $alias
  • if you want this table to be aliased under another name
int $order

A numerical index to control the order that joins are added to the query; lower order values will cause the query to appear first. The default is 20, and joins created automatically by the ORM have a value of 10.

array $parameters

Any additional parameters if the join is a parameterised subquery

Return Value

DataList

DataList rightJoin(string $table, string $onClause, string $alias = null, int $order = 20, array $parameters = [])

Return a new DataList instance with a right join clause added to this list's query.

Parameters

string $table

Table name (unquoted and as escaped SQL)

string $onClause

Escaped SQL statement, e.g. '"Table1"."ID" = "Table2"."ID"'

string $alias
  • if you want this table to be aliased under another name
int $order

A numerical index to control the order that joins are added to the query; lower order values will cause the query to appear first. The default is 20, and joins created automatically by the ORM have a value of 10.

array $parameters

Any additional parameters if the join is a parameterised subquery

Return Value

DataList

array toArray()

Return an array of the actual items that this DataList contains at this stage.

This is when the query is actually executed.

Return Value

array

array toNestedArray()

Return this list as an array and every object it as an sub array as well

Return Value

array

$this each(callable $callback)

Walks the list using the specified callback

Parameters

callable $callback

Return Value

$this

debug()

No description

Map map(string $keyField = 'ID', string $titleField = 'Title')

Returns a map of this list

Parameters

string $keyField
  • the 'key' field of the result array
string $titleField
  • the value field of the result array

Return Value

Map

DataObject createDataObject(array $row)

Create a DataObject from the given SQL row If called without $row['ID'] set, then a new object will be created rather than rehydrated.

Parameters

array $row

Return Value

DataObject

array getQueryParams()

Get query parameters for this list.

These values will be assigned as query parameters to newly created objects from this list.

Return Value

array

DataList eagerLoad(...$relationChains)

Eager load relations for DataObjects in this DataList including nested relations

Eager loading alleviates the N + 1 problem by querying the nested relationship tables before they are needed using a single large WHERE ID in ($ids) SQL query instead of many WHERE RelationID = $id queries.

You can specify nested relations by using dot notation, and you can also pass in multiple relations. When specifying nested relations there is a maximum of 3 levels of relations allowed i.e. 2 dots

Example: $myDataList->eagerLoad('MyRelation.NestedRelation.EvenMoreNestedRelation', 'DifferentRelation')

IMPORTANT: Calling eagerLoad() will cause any relations on DataObjects to be returned as an EagerLoadedList instead of a subclass of DataList such as HasManyList i.e. MyDataObject->MyHasManyRelation() returns an EagerLoadedList

Parameters

...$relationChains

Return Value

DataList

int count()

Return the number of items in this DataList

Return Value

int

mixed max(string $fieldName)

Return the maximum value of the given field in this DataList

Parameters

string $fieldName

Return Value

mixed

mixed min(string $fieldName)

Return the minimum value of the given field in this DataList

Parameters

string $fieldName

Return Value

mixed

mixed avg(string $fieldName)

Return the average value of the given field in this DataList

Parameters

string $fieldName

Return Value

mixed

mixed sum(string $fieldName)

Return the sum of the values of the given field in this DataList

Parameters

string $fieldName

Return Value

mixed

mixed first()

Returns the first item in this DataList (instanceof DataObject)

The object returned is not cached, unlike DataObject::get_one()

Return Value

mixed

mixed last()

Returns the last item in this DataList (instanceof DataObject)

The object returned is not cached, unlike DataObject::get_one()

Return Value

mixed

mixed find(string $key, mixed $value)

Find the first DataObject of this DataList where the given key = value

The object returned is not cached, unlike DataObject::get_one()

Parameters

string $key
mixed $value

Return Value

mixed

DataList setQueriedColumns(array $queriedColumns)

Restrict the columns to fetch into this DataList

Parameters

array $queriedColumns

Return Value

DataList

SS_List byIDs(array $ids)

Filter this list to only contain the given Primary IDs

Parameters

array $ids

Array of integers

Return Value

SS_List

mixed byID(int $id)

Return the first DataObject with the given ID

The object returned is not cached, unlike DataObject::get_by_id()

Parameters

int $id

Return Value

mixed

array column(string $colName = "ID")

Returns an array of a single field value for all items in the list.

Parameters

string $colName

Return Value

array

array columnUnique(string $colName = "ID")

Returns a unique array of a single field value for all items in the list.

Parameters

string $colName

Return Value

array

setByIDList(array $idList)

Sets the ComponentSet to be the given ID list.

Records will be added and deleted as appropriate.

Parameters

array $idList

List of IDs.

array getIDList()

Returns an array with both the keys and values set to the IDs of the records in this list.

Does not respect sort order. Use ->column("ID") to get an ID list with the current sort.

Return Value

array

HasManyList|ManyManyList relation(string $relationName)

Returns a HasManyList or ManyMany list representing the querying of a relation across all objects in this data list. For it to work, the relation must be defined on the data class that you used to create this DataList.

Example: Get members from all Groups:

DataList::Create(\SilverStripe\Security\Group::class)->relation("Members")

Parameters

string $relationName

Return Value

HasManyList|ManyManyList

dbObject($fieldName)

No description

Parameters

$fieldName

$this addMany(array $items)

Add a number of items to the component set.

Parameters

array $items

Items to add, as either DataObjects or IDs.

Return Value

$this

$this removeMany(array $idList)

Remove the items from this list with the given IDs

Parameters

array $idList

Return Value

$this

$this removeByFilter(string|array $filter)

Remove every element in this DataList matching the given $filter.

Parameters

string|array $filter
  • a sql type where filter

Return Value

$this

$this shuffle()

Shuffle the datalist using a random function provided by the SQL engine

Return Value

$this

$this removeAll()

Remove every element in this DataList.

Return Value

$this

add(mixed $item)

This method are overloaded by HasManyList and ManyMany list to perform more sophisticated list manipulation

Parameters

mixed $item

DataObject newObject(array $initialFields = null)

Return a new item to add to this DataList.

Parameters

array $initialFields

Return Value

DataObject

remove(mixed $item)

Remove this item by deleting it

Parameters

mixed $item

removeByID(int $itemID)

Remove an item from this DataList by ID

Parameters

int $itemID

The primary ID

Sortable reverse()

Reverses a list of items.

Return Value

Sortable

bool offsetExists(mixed $key)

Returns whether an item with $key exists

Parameters

mixed $key

Return Value

bool

DataObject|null offsetGet(mixed $key)

Returns item stored in list with index $key

The object returned is not cached, unlike DataObject::get_one()

Parameters

mixed $key

Return Value

DataObject|null

void offsetSet(mixed $key, mixed $value)

Set an item with the key in $key

Parameters

mixed $key
mixed $value

Return Value

void

Exceptions

BadMethodCallException

void offsetUnset(mixed $key)

Unset an item with the key in $key

Parameters

mixed $key

Return Value

void

Exceptions

BadMethodCallException

iterable chunkedFetch(int $chunkSize = 1000)

Iterate over this DataList in "chunks". This will break the query in smaller subsets and avoid loading the entire result set in memory at once. Beware not to perform any operations on the results that might alter the return order. Otherwise, you might break subsequent chunks.

You also can not define a custom limit or offset when using the chunk method.

Parameters

int $chunkSize

Return Value

iterable

Exceptions

InvalidArgumentException

CallbackList addCallbacks()

Manage callbacks which are called after the add() action is completed.

Each callback will be passed (RelationList $this, DataObject|int $item, array $extraFields). If a relation methods is manually defined, this can be called to adjust the behaviour when adding records to this list.

Needs to be defined through an overloaded relationship getter to ensure it is set consistently. These getters return a new object every time they're called.

Note that subclasses of RelationList must implement the callback for it to function

Return Value

CallbackList

CallbackList removeCallbacks()

Manage callbacks which are called after the remove() action is completed.

Each Callback will be passed (RelationList $this, [int] $removedIds).

Needs to be defined through an overloaded relationship getter to ensure it is set consistently. These getters return a new object every time they're called. Example:

class MyObject extends DataObject()
{
  private static $many_many = [
    'MyRelationship' => '...',
  ];
  public function MyRelationship()
  {
    $list = $this->getManyManyComponents('MyRelationship');
    $list->removeCallbacks()->add(function ($removedIds) {
      // ...
    });
    return $list;
  }
}

If a relation methods is manually defined, this can be called to adjust the behaviour when adding records to this list.

Subclasses of RelationList must implement the callback for it to function

Return Value

CallbackList

string|array|null getForeignID()

Any number of foreign keys to apply to this list

Return Value

string|array|null

Relation forForeignID(mixed $id)

Returns a copy of this list with the ManyMany relationship linked to the given foreign ID.

Parameters

mixed $id

Return Value

Relation

abstract protected array foreignIDFilter(array|int $id = null)

Returns a where clause that filters the members of this relationship to just the related items.

Parameters

array|int $id

(optional) An ID or an array of IDs - if not provided, will use the current ids as per getForeignID

Return Value

array

Condition In array(SQL => parameters format)

protected string prepareForeignIDsForWhereInClause(array $ids)

Prepare an array of IDs for a 'WHERE IN` clause deciding if we should use placeholders Current rules are to use not use placeholders, unless:

  • SilverStripe\ORM\DataList.use_placeholders_for_integer_ids is set to false, or
  • Any of the IDs values being filtered are not integers or valid integer strings

Putting IDs directly into a where clause instead of using placeholders was measured to be significantly faster when querying a large number of IDs e.g. over 1000

Parameters

array $ids

Return Value

string