Hi, in SS 2.x.x I had no problems with custom queries transformed to Dataobjectsets. I have made
$result = DB::query('SELECT blah blah blah');
$dos = singleton('WowClass')->buildDataObjectSet($result);
if($dos)
$dos->someMagicFunctionToSetLimit(0,40); // can't find that one, but it was neat ;)
So this is SS 2.x.x
I wanna do something like this in SS3 ;)
I have:
$result = DB::query('
SELECT * FROM (
SELECT * FROM (
SELECT * FROM Auction WHERE IsFeatured = 1
ORDER BY ID DESC
) as Auction
UNION ALL
SELECT * FROM(
SELECT * FROM Auction WHERE IsFeatured = 0
ORDER BY ID DESC
) as Auction
) as Auction
');
singleton('Auction')->buildDataObjectSet(....) // Here is deprecated...
How can I make this work under SS3?
Any help will be appreciated
M.