ZF-5874: $db->select()->join using Zend_Db_Table and $_referenceMap

Issue Type:
New Feature
Created:
2009-02-24T06:54:23.000+0000
Last Updated:
2012-11-20T20:53:26.000+0000
Status:
Closed
Fix version(s):
    Reporter:
    Ben Rexin (salz)
    Assignee:
    None
    Tags:
    • Zend_Db_Table
    Related issues:
    Attachments:

    Description

    For me it's looks somehow crazy that you select Rowset via $referenceMap (->findReporter(), ->findEngineer(), ->findVerifier()), but can't build an Join Statement with them.

    We need to write: $db->select() ->from(new Bugs()) ->join('accounts', 'accounts.account_name = bugs.reported_by') ->join('accounts', 'accounts.account_name = bugs.assigned_to') ->join('accounts', 'accounts.account_name = bugs.verified_by');

    instead of just

    $db->select() ->from(new Bugs()) ->join(new Accounts());

    Comments

    Posted by Rob Allen (rob) on 2012-11-20T20:53:26.000+0000

    Bulk change of all issues last updated before 1st January 2010 as "Won't Fix".

    Feel free to re-open and provide a patch if you want to fix this issue.