We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 25551 ☆ A M B ☆
    • 1,231 Posts
    Hello,

    I’m trying to get documents from multiple parents in a TV but not having any luck. I’ve tried the following but it’s not working right. It just displays 1 resource but it appears blank so I assume it’s not working at all. If I remove the second `parent` call it does work so how do I get from multiple parents?

    @SELECT `pagetitle`,`id` FROM `[[+PREFIX]]site_content` WHERE `parent` = 109 AND `parent` = 100 AND `published`= 1

    Thanks!

    *** Solved

    WHERE `parent` = IN (100,109)
      Ross Sivills - MD AugmentBLU Edinburgh, Scotland UK
      AugmentBLU - MODX Partner

      BLUcart - MODX Revolution E-Commerce & Shopping Cart