use SilverStripe\Forms\FieldList; use SilverStripe\Forms\TextField; $fields = FieldList::create( TextField::create('FirstName', 'First Name'), TextField::create('LastName', 'Last Name'), TextField::create('Email', 'Email') );
use SilverStripe\ORM\DataList; use SilverStripe\Forms\FieldList; $fields = FieldList::create( 'FirstName', 'LastName', 'Email' ); $users = DataList::create('User')->alterDataQuery(function($query) use ($fields) { $query->setSelect($fields->getSQL()); });In this example, we create a FieldList object called $fields and add three fields to it that correspond to the first name, last name, and email of a user. We then create a DataList object for the User model and use the alterDataQuery() method to modify the SQL query it generates. Inside the alterDataQuery() method, we call the getSQL() method on the $fields object to get the SQL string for the fields we added. We then set the select statement of the query to this SQL string, so that only the selected fields are retrieved from the database. The FieldList class is part of the SilverStripe framework's user interface package, which provides various classes and methods for building user interfaces in PHP applications.