I have an array with id's:
$ids = array(240, 12, 400);
And I want to get those objects in that order with $modx->getCollection('modResource');
How can I accomplish that?
if I do like this:
$res = $modx->getCollection('modResource', array(
'id:IN' => $ids
));
the boxes are in ASC order, but I want them in this order: 240, 12 400...
[ed. note: thorjarle last edited this post 14 years ago.]
...I believed it was Friday...
you can try something like that:
$ids = '240,12,400';
$classname = 'modResource';
$c = $modx->newQuery($classname);
$c->where(array('id:IN' => explode(',',$ids)));
$c->sortby('FIELD(modResource.id, ' . $ids . ')';
$res = $modx->getCollection($classname, $c);
