So... let’s pretend we want to grab a bunch of related tables via getCollectionGraph:
$resources = $modx->getCollectionGraph('Resources', '{"modChunk": {},"Category":{}, "MassUnit":{}, "VolumeUnit":{} }',$query);
In my example, the join tables could be joined via a specific criteria, e.g.
SELECT *
FROM `resources`
LEFT JOIN `units` as mass_units ON resources.unit_id=mass_units.unit_id AND mass_units.type='mass'
WHERE resources.`id` = 32117;
Note the MySQL ’AND’ following the ’ON’ bit...
Is that the type of thing that can be specified inside the {} bits? And what is the syntax for that?
☆ A M B ☆
MODX Staff
MODX Staff