MODX :: Filtering results with getCollectionGraph

aladage Reply #1, 4 months, 1 week ago

Link to this post#1

I'm having trouble understanding how to sort and filter getCollectionGraph based on anything other than the primary key. I have another column called "created_userid", and all I want is the equivalent of a where statement that lets me show only entries that match a passed-in userid. Can anyone clarify? I'd be glad to provide my example code.

Btw, I saw this thread...

http://forums.modx.com/thread/31768/but-i-don-t-want-to-order-by-primary-key#dis-post-171755

...but it makes no sense to me and (I think) is way more complicated than what I'm trying to do:

$user_id = $_GET['user_id']; $crit = $modx->newQuery('Table1'); $crit->where(array ('Table1.created_userid:=' => $user_id)); $articles = $modx->getCollectionGraph('Table1', '{ "Table2":{},"Table3":{} }', $crit);

Filtering results with getCollectionGraph#

aladage Reply #1, 4 months, 1 week ago

aladage Reply #2, 4 months, 1 week ago