Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

DataObject::get with specific Select


Reply

3 Posts   452 Views

Avatar
Ajaxian

5 December 2012 at 8:59pm Community Member, 8 Posts

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

Avatar
Willr

8 December 2012 at 4:49pm Forum Moderator, 5511 Posts

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

Avatar
Ajaxian

8 December 2012 at 7:34pm Community Member, 8 Posts

Thanks Willr