We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 26503
    • 620 Posts
    well this seems to be returning something now.

    $criteria->bindGraph('{"MarketZone":{}}');
    $zones = $this->modx->getCollectionGraph('Countries','{"MarketZone":{}}',$criteria);



    and the query is looking like this:

    SELECT `Countries`.`id` AS `Countries_id`, `Countries`.`Country` AS `Countries_Country`, `Countries`.`abbreviation` AS `Countries_abbreviation`, `Countries`.`zone` AS `Countries_zone`, `MarketZone`.`id` AS `MarketZone_id`, `MarketZone`.`zone` AS `MarketZone_zone`, `MarketZone`.`abbreviation` AS `MarketZone_abbreviation` FROM `modx_countries` AS `Countries` LEFT JOIN `modx_market_zone` `MarketZone` ON `Countries`.`zone` = `MarketZone`.`id` WHERE `Countries`.`abbreviation` = 'CA' ORDER BY `Countries`.`id` ASC 


    It's not returning an object yet - but I'll have to tinker with it tomorrow.
    Still driving me nuts that we have to manually specify the join/binding. [arrgh!!]
      *** Not just websites, we also create signage, banners, print, trade show displays and more! ***

      Sean Kimball CLP, CLS.
      Technical Director / Sr. Developer | BigBlock Studios
      ._______________________________________________.
      Bigblock Studios http://www.bigblockstudios.ca Web site design & development.
      27-1300 King Street East. Box 167 Oshawa, Ontario L1H8J4 Canada.
      phone/fax: 905-426-5525