Simple doctrine query using symfony

Question

I'm trying to build a basic query using symfony and doctrine. The query will return a User and all the jobs they are working on. From the two tables 'User' and UserDetails (Contains User_id and Job_id). User is mapped to userdetails correctly as one- many.

my query is

SELECT   userdetails, u FROM TestBundle:User 
join userdetails.u

As user is a field in userdetails, but userdetails isn't a member of users the following query doesn't work. Is there any way to write this so the result will look like User.userDetails.

DonCallisto · Accepted Answer · 2015-08-20 07:51:11Z

1

Try something like

SELECT
  u, ud
FROM 
  TestBundle:User u
JOIN //LEFT JOIN if you want also users without UserDetails
  TestBundle:UserDetails ud
WITH
  u.id = ud.user_id

of course your variables (like ud.user_id) could vary but we don't have enough informations to work on so we have to guess

edited Aug 20, 2015 at 7:51

answered Aug 20, 2015 at 7:09

DonCallisto

30k9 gold badges74 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user3248331 Over a year ago

Thanks for the help, had to change ON to WITH to get it to work. It still put userdetails as a seperate row, but does what i need. Cheers

DonCallisto Over a year ago

@user3248331: yes, I was into "autopilot" mode and wrote with a typo; updated. Dont' forget to accept the answer if this works for you.

Collectives™ on Stack Overflow

Simple doctrine query using symfony

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related