Re: [Xoops-development] new version XoopsObjectHandler

[K. O. <on...@xo...>]

> Set a limit (or start and limit) by itself (no where clause). I didn't see
a way to achieve this, so I did fetch() this way.

Yes, you can set it without the where part by creating an instance of the
CriteriaCompo class
that doesn't contain any child instance of the Criteria class.

$criteria = new CriteriaCompo();
$criteria->setLimit(10);
$criteria->setStart(5);
With the above code, either $criteria->renderWhere() or $criteria->render()
will return an empty string.


> I also wasn't sure if I could add multiple sort columns (with separate
sort order). Or how to use multiple group by columns. I need some time to
play with the class.

You're right and this is not currently possible. You can only set multiple
sort columns.
$criteria->setSort('id, title');


- Kazu