| # |
Apr 19th 2017, 08:46 |
Neon1024 |
So you can find the specific user, and then contain all their associated roles |
| # |
Apr 19th 2017, 08:46 |
Neon1024 |
$this->Users->find()->contain([‘Roles’])->where([‘Users.id’ => $userId])->first(); |
| # |
Apr 19th 2017, 08:45 |
Neon1024 |
So you’ll need to find a user and contain roles |
| # |
Apr 19th 2017, 08:45 |
joop |
'UsersRoles.user_id' is gives error |
| # |
Apr 19th 2017, 08:44 |
joop |
i checked but for the where(or condition) 'id' =>$this->Auth->user('id') //the id is wrong i need user_id because i would like to query the specific user's roles |
| # |
Apr 19th 2017, 08:42 |
Neon1024 |
Instead, we have McDonalds down the road :s |
| # |
Apr 19th 2017, 08:41 |
Neon1024 |
Times like this I wish I was in the Netherlands, so I could pop out for a proper coffee and a stroopwaffel |
| # |
Apr 19th 2017, 08:41 |
Neon1024 |
Yeah, I’ve had a coffee, but it’s horrible instant coffee |
| # |
Apr 19th 2017, 08:41 |
 ankr |
neon1024 get that coffee maker running asap |
| # |
Apr 19th 2017, 08:39 |
Neon1024 |
That ^ |
| # |
Apr 19th 2017, 08:39 |
inoas |
belongsToMany() ;) |
| # |
Apr 19th 2017, 08:39 |
Neon1024 |
As it’ll be included automagically |
| # |
Apr 19th 2017, 08:39 |
Neon1024 |
If it’s a hasAndBelongsToMany() then you don’t need to contain it |
| # |
Apr 19th 2017, 08:39 |
Neon1024 |
Yeah |
| # |
Apr 19th 2017, 08:39 |
inoas |
maybe you want a real model then ;) |
| # |
Apr 19th 2017, 08:39 |
inoas |
containing a pivot table sounds weirdo |
| # |
Apr 19th 2017, 08:38 |
inoas |
the example is still here https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#using-finders-to-load-data |
| # |
Apr 19th 2017, 08:38 |
inoas |
urgh |
| # |
Apr 19th 2017, 08:38 |
Neon1024 |
https://pastebin.com/wkFB33ep |
| # |
Apr 19th 2017, 08:37 |
joop |
Neon would you show me the 3 way please |
| # |
Apr 19th 2017, 08:36 |
joop |
Guest71037 try the History tab |
| # |
Apr 19th 2017, 08:36 |
Neon1024 |
Well it’s very Cake 2 |
| # |
Apr 19th 2017, 08:36 |
Neon1024 |
Your query is all wrong |
| # |
Apr 19th 2017, 08:35 |
joop |
https://pastebin.com/TNtPkvwK |
| # |
Apr 19th 2017, 08:35 |
Guest71037 |
in debugkit, the sql tab is empty, is there any way to fix this or debug it to see why |
| # |
Apr 19th 2017, 08:35 |
joop |
no 3 |
| # |
Apr 19th 2017, 08:35 |
Neon1024 |
Ah Cake 2 |
| # |
Apr 19th 2017, 08:33 |
joop |
but UsrsRoles['user_id'] or ['users_roles']['user_id'] does not works |
| # |
Apr 19th 2017, 08:32 |
joop |
'users_roles'=>['user_id //what need to check |
| # |
Apr 19th 2017, 08:32 |
joop |
but can not acces to data specific field |
| # |
Apr 19th 2017, 08:31 |
joop |
i can get it bay the contain |
| # |
Apr 19th 2017, 08:31 |
joop |
Users->Roles->UsersRoles |
| # |
Apr 19th 2017, 08:31 |
joop |
i have to make a query in a HABT association |
| # |
Apr 19th 2017, 08:29 |
joop |
thank you ionas |
| # |
Apr 19th 2017, 08:29 |
inoas |
so I couldn't sleep to 8:30 :p |
| # |
Apr 19th 2017, 08:29 |
inoas |
same but our boy awoke 3 times |
| # |
Apr 19th 2017, 08:28 |
Neon1024 |
My own fault, I went to bed at midnight, so only got about 6 hours sleep |
| # |
Apr 19th 2017, 08:27 |
inoas |
you are not the only one. |
| # |
Apr 19th 2017, 08:26 |
Neon1024 |
ankr, Struggling to get started today |
| # |
Apr 19th 2017, 08:26 |
inoas |
things are not going smooth then |
| # |
Apr 19th 2017, 08:26 |
inoas |
I got foreign keys that can have nullable parts... meh |