Hi

I read the doc, and I only saw DataObject::get(). without the ability to restrict the Select.
With get you can have access to all the fields available for the class.

But is it possible to restrict the result, I mean something like MyClass::get(array('fied1','field2')); which generates a SELECT field1, filed2 whereas withe the get() you have SELECT *

I do not see this possibility in the Doc/Api. Is there a way to do this ?

Thanks

No not with the ORM but you could bypass the ORM and use SQLQuery if you don't want to work with full objects.

http://doc.silverstripe.org/framework/en/reference/sqlquery

Thanks Willr