Tuesday, October 14, 2014

Re: belongsTo custom condition not working

CakePHP 2.4.5

LinkedinPerson.linkedin_id (actual ID from Linkedin)

LinkedinRecommendation.linkedin_id (actual ID from Linkedin)

Both tables share the same foreignKey - which is the unique identifier from LinkedinIn. That is it. Another example of this would be if I had two tables that shared the same email address, so I keyed off of that. Instead of the more typical primary key/ foreign key relationship.

--
Matt

On Tuesday, October 14, 2014 11:04:39 AM UTC-6, John Andersen wrote:
How are your tables defined?

What is the primary key for the table used by the model "LinkedinPerson"?
What is the primary key for the table used by the model "LinkedinRecommendation"?

In each of the tables, what is the definition of the column "linkedin_id" - I hear mean the purpose of the column?

What version of CakePHP are you using?

Kind regards
John

On Monday, 13 October 2014 22:09:11 UTC+3, Matt Myers wrote:
// in LinkedinPerson
public $hasMany = array(
    'LinkedinRecommendation' => array(
        'className' => 'LinkedinRecommendation',
        'foreignKey' => false,
        'dependent' => true,
    ),
)


// in LinkedinRecommendation
public $belongsTo = array(
    'LinkedinPerson' => array(
        'className' => 'LinkedinPerson',
        'foreignKey' => false,
        'conditions' => array('LinkedinPerson.linkedin_id = LinkedinRecommendation.linkedin_id'),
    ),
);

When I query these out with find() the LinkedinPerson returns ALL recommendations. Not just those associated by linkedin_id. I've tried a variety of different things, and I'm stumped. Can someone help?

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: