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   500 Views

Avatar
Ajaxian

Community Member, 8 Posts

5 December 2012 at 8:59pm

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

Forum Moderator, 5513 Posts

8 December 2012 at 4:49pm

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

Community Member, 8 Posts

8 December 2012 at 7:34pm

Thanks Willr