We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
MODX Community Forums Archive

getCollection syntax for getting resources from multiple templates

    • 17667
    • 108 Posts
    lukemcd Reply #1, 14 years, 6 months ago
    I have created a query to pull all published resources that use template 18. The code works:
    $c = $modx->newQuery('modResource');
$c->where(
	'published'=>1,
	'deleted:!='=>1,
	'template'=>18
);
$collection = $modx->getCollection('modResource',$c);

    Now I need a query which chooses published resources that use template 18 *or* 19. This is what I have but it doesn't work:
    $c = $modx->newQuery('modResource');
$c->where(
	'published'=>1,
	'deleted:!='=>1,
	array('template'=>18,'OR:template'=>19)
);
$collection = $modx->getCollection('modResource',$c);


    I've tried a few different combinations but I can't figure out the proper syntax.
      • 4172
      • 5,888 Posts
      Bruno17 Reply #2, 14 years, 6 months ago
      you can try 'IN'

      $c = $modx->newQuery('modResource');
$c->where(array(
    'published'=>1,
    'deleted:!='=>1,
    'template:IN'=>array(18,19))
);
$collection = $modx->getCollection('modResource',$c);
        -------------------------------

        you can buy me a beer, if you like MIGX

        http://webcmsolutions.de/migx.html

        Thanks!
        • 17667
        • 108 Posts
        lukemcd Reply #3, 14 years, 6 months ago
        Perfect! Thanks.
          • 22303 MODX Staff
          • 10,725 Posts
          opengeek Reply #4, 14 years, 6 months ago
          Quote from: lukemcd at Mar 30, 2012, 12:33 PM
          Now I need a query which chooses published resources that use template 18 *or* 19. This is what I have but it doesn't work:
          $c = $modx->newQuery('modResource');
$c->where(
	'published'=>1,
	'deleted:!='=>1,
	array('template'=>18,'OR:template'=>19)
);
$collection = $modx->getCollection('modResource',$c);


          I've tried a few different combinations but I can't figure out the proper syntax.

          FYI, you were really close with this, you just need to pass an array to the where clause, and to specify the operator explicitly when you include a conjunction in an array criteria key, e.g.
          <?php
$c = $modx->newQuery('modResource');
$c->where(array(
    'published' => 1,
    'deleted:!=' => 1,
    array(
        'template' => 18,
        'OR:template:=' => 19
    )
));
$collection = $modx->getCollection('modResource',$c);

            Jason Coward
            Chief Architect @ MODX
            http://www.jasoncoward.com | http://twitter.com/drumshaman | https://github.com/opengeek
            • 17667
            • 108 Posts
            lukemcd Reply #5, 14 years, 6 months ago
            That's good to know! I am starting to get a hang of the syntax.