Stuck trying to get only users with same idempresa

Question

In my application (developed with Symfony 1.4 and Doctrine) I'm trying to get all users based on idempresa of the user logged in. idempresa is in a sf_guard_user_profiletable and this is the schema for that:

SfGuardUserProfile:
  connection: doctrine
  tableName: sf_guard_user_profile
  columns:
    id: { type: integer(8), primary: true }
    user_id: { type: integer(8), primary: false }
    idempresa: { type: integer(4), primary: false }
  relations:
    User:
      local: user_id
      class: sfGuardUser
      type: one
      foreignType: one
      foreignAlias: SfGuardUserProfile
      onDelete: CASCADE
      onUpdate: CASCADE

I'm trying with this query:

Doctrine_Core::getTable('sfGuardUser')
   ->createQuery('u')
   ->leftJoin('u.Profile p')
   ->where('idempresa = ?', $id_empresa)
   ->execute();

But get this error:

Unknown relation alias Profile

What is wrong in my code?

score 2 · Accepted Answer · answered Jun 12 '13 at 07:14

2

Your relation between the sfGuardUser and sfGuardUserProfile is not called Profile but SfGuardUserProfile. So you should use in your query builder:

 ->leftJoin('u.SfGuardUserProfile p')

answered Jun 12 '13 at 07:14

Michal Trojanowski

10,641
2
22
41

I'm pretty sure I try that but doesn't work, maybe a typo and I was tired at 2 AM, anyway thanks – Reynier Jun 12 '13 at 13:55
It's definitely fun to write code at 2 am but you can easily get stuck with such simple mistakes. ;) – Michal Trojanowski Jun 12 '13 at 14:32

Stuck trying to get only users with same idempresa

1 Answers1