MODX Revo custom sort order for getCollection

Question

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...

score 2 · Accepted Answer · answered Oct 15 '12 at 09:32

2

try this:

$criteria = $modx->newQuery('modResource');
$criteria->sortby('FIELD(modResource.id, '.implode(',',$ids).' )', 'DESC');
$criteria->where(array(
    'id:IN' => $ids
));
$res = $modx->getCollection('modResource', $criteria);

answered Oct 15 '12 at 09:32

Vasis

2,281
1
16
23

That hit the spot! I had to change DESC to ASC in my example, but hey, its all good! – BennyLava Oct 15 '12 at 12:06

MODX Revo custom sort order for getCollection

1 Answers1