Actually I overcame this one...
But i got another question =))
$c = $modx->newQuery('yi_items');
$c->sortby($sort,$dir);
$yishop = $modx->getCollectionGraph('yi_items','{"yv":{}}', $c);
So the sorting doesnt work very good for yi_items had to change the code to this
$c->sortby('yi_items.'.$sort,$dir)
(then if i define in script to sort some rows from the yi_items table -> it works fine)
but if I want to sort row frow left joined table ("yv") -> it doesnt work ... of course, you say, it is because of
$c->sortby('yi_items.'.$sort,$dir)
well i changed this one to
if ($sort == 'v_name') {$c->sortby('yv.v_name',$dir);}
else {$c->sortby('yi_items.'.$sort,$dir);}
still nothing’s good
Actually modx provides not very much info on how working with collectionGraph, as i cant really sort, or save changes to both tables... althoug there is plenty of info on how to get data -> camoon guys, I need CRUD with my joined tables...
