We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 13577
    • 302 Posts
    I have a search results do-hickey for an app that requires looking at 3 tables. So I figured on using getCollectionGraph - but I couldn’t figure out how to add sort and other criteria info. So then I went with the create a newQuery first, and just use getCollection with a graphed criteria object:

    // query obj
    $crit = $xpdo->newQuery(’TableOne’);

    // graph
    $graph = "{’TableTwo’:{’key’:{’TableThree’:{’key’:{}}}}}";

    // ... a few "andCondition" statements here from the search form that basically look like:
    $crit->andCondition("TableOne.fieldA LIKE ’$formData%’");

    // sort order

    // get collection
    $collection = $xpdo->getCollection(’TableOne’,$crit);
    (Table names etc. changed to protect the innocent.)

    I then go thru the rigamarole of creating a table with the ever fabulous MakeTable class. It seems to be [miraculously] pulling the correct records, but sorting them first by TableOne.primaryKey - which I never specified. I don’t know where it’s coming from, or more importantly how to get rid of it.

    I’m not sure I’m even going about this correctly. But it seems to be giving me about the results I want so I feel hopeful. I welcome any ideas...
      Standard Disclaimer
      I could be totally wrong.
    • One thing I see right off, is that you are binding a graph, but then you are calling getCollection(). Try calling getCollectionGraph() at the end, similar to this example from 0.9.7 and see what difference it makes...

      $crit = $modx->newQuery('modManagerUser');
      $wa = array();
      if ($_SESSION['mgrRole'] != 1) {
      	$crit->where(array ('modUserProfile_internalKey.role:!=' => 1));
      if (!empty($sqlQuery)) {
          $crit->where(array('modManagerUser.username:LIKE' => '%'.$sqlQuery.'%'), XPDO_SQL_AND, null, 1);
          $crit->orCondition(array('modUserProfile_internalKey.fullname:LIKE' => '%' . $sqlQuery . '%'), null, 1);
          $crit->orCondition(array('modUserProfile_internalKey.email:LIKE' => '%' . $sqlQuery . '%'), null, 1);
      $users = $modx->getCollectionGraph('modManagerUser', '{"modUserProfile":{"internalKey":{}}}', $crit);

      If it’s still not sorting properly, we’ll explore other possible problems...
        • 13577
        • 302 Posts
        Thanks Jason-

        Like I mentioned, I tried getCollectionGraph first, but couldn’t figure out how to get it to sort how i wanted, so I did the graph binding in the criteria object and passed it to getCollection instead. Which seemed to work as far as getting the results I wanted. I’ll modify it as your example shows and give ’er a go. But I still don’t understand why it’s ordering by the primary key.

        Tried getCollectionGraph again, still my collection set isn’t accurate. For example, it returns 2 objects (right number) that are the same (which is bad - they should be different). Because they’re the same, I have no idea how they’re being ordered.
          Standard Disclaimer
          I could be totally wrong.