| # |
Mar 12th 2018, 21:52 |
 savant |
since your query appears to me that its doing a select instead. |
| # |
Mar 12th 2018, 21:52 |
savant |
are you sure you left the `UserEmails` strategy and joinType to what you showed in the pastebin? |
| # |
Mar 12th 2018, 21:51 |
xinobi |
savant don't follow the url |
| # |
Mar 12th 2018, 21:50 |
xinobi |
savant no that :id param is being passed on... this is the url: http://sandbox.lc/teams/users/1?sort=UserAddresses.addressanddirection=asc |
| # |
Mar 12th 2018, 21:48 |
savant |
so if there is no JoinedTeam, then it wont show up |
| # |
Mar 12th 2018, 21:48 |
savant |
so thats because you are setting team_id to something |
| # |
Mar 12th 2018, 21:47 |
xinobi |
savant this is the query https://pastebin.com/1hhK3MjY |
| # |
Mar 12th 2018, 21:39 |
savant |
can you show me the query you are seeing |
| # |
Mar 12th 2018, 21:39 |
savant |
and leave the joinType as it was |
| # |
Mar 12th 2018, 21:39 |
savant |
leave it as join |
| # |
Mar 12th 2018, 21:39 |
savant |
do not use select |
| # |
Mar 12th 2018, 21:39 |
xinobi |
savant if i choose to use setStrategy('select') than I can see all users but i'm not allowed to sort associated data, I get a mysql error for unknown column (the one I sort) etc |
| # |
Mar 12th 2018, 21:38 |
savant |
what is the database query executed here? |
| # |
Mar 12th 2018, 21:36 |
xinobi |
savant with the current setup the users without email, address or phone joined to a team won't get listed but I'm able to sort my data without problems |
| # |
Mar 12th 2018, 21:35 |
savant |
or rather, what is happening and what do you want to happen? |
| # |
Mar 12th 2018, 21:34 |
savant |
and what is the error you are seeing? |
| # |
Mar 12th 2018, 21:33 |
xinobi |
savant my controller action https://pastebin.com/5nkEH2c5 |
| # |
Mar 12th 2018, 21:31 |
savant |
can you show me the query that you are using? |
| # |
Mar 12th 2018, 21:26 |
xinobi |
savant this is my Table code https://pastebin.com/jmMZvibg |
| # |
Mar 12th 2018, 20:52 |
savant |
can you show the code you are using? via a gist please |
| # |
Mar 12th 2018, 20:52 |
savant |
what is a “registries’ |
| # |
Mar 12th 2018, 20:51 |
savant |
which is the default |
| # |
Mar 12th 2018, 20:51 |
savant |
that will then mean you use a `join` strategy of `LEFT` joinType |
| # |
Mar 12th 2018, 20:51 |
savant |
do not change to select |
| # |
Mar 12th 2018, 20:51 |
savant |
leave the strategy as is |
| # |
Mar 12th 2018, 20:51 |
savant |
you can sort by a LEFT column |
| # |
Mar 12th 2018, 20:50 |
xinobi |
savant I can't find a proper solution, I've opened this https://discourse.cakephp.org/t/sort-from-view-with-when-using-hasone-associations/3976 a "while" ago I stoped looking for a solution meanwhile but now I need to fix this |
| # |
Mar 12th 2018, 20:46 |
xinobi |
savant I'm sorry but I'm really frustrated here |
| # |
Mar 12th 2018, 20:45 |
xinobi |
savant by default joinType is LEFT |
| # |
Mar 12th 2018, 20:45 |
savant |
:slightly_smiling_face: |
| # |
Mar 12th 2018, 20:45 |
savant |
also, there isnt any need for a bunch of !?!!?1 |
| # |
Mar 12th 2018, 20:45 |
savant |
xinobi: you can change the `joinType` to `LEFT` if you’d like |
| # |
Mar 12th 2018, 20:44 |
xinobi |
I'm sorry to get back to this but the book says "You can use INNER if your hasOne association is always present." what if it's not an obligatory column?!? has I see it I got only one option I've to use 'select' as strategy but I can't sort data... https://book.cakephp.org/3.0/en/orm/associations.html#hasone-associations |
| # |
Mar 12th 2018, 20:01 |
xinobi |
when sorting hasOne associations within pagination I don't see all the registries, but if I add setStrategy('select') I get an all the registries however I'm allowed to sort without a MYSQL Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column... |
| # |
Mar 12th 2018, 19:22 |
bakro.istvan |
I will get back at you if I find anything |
| # |
Mar 12th 2018, 19:22 |
bakro.istvan |
Thanky anyway |
| # |
Mar 12th 2018, 19:22 |
bakro.istvan |
ok |
| # |
Mar 12th 2018, 19:21 |
dereuromark |
Find out why. It works for me. |
| # |
Mar 12th 2018, 19:14 |
bakro.istvan |
I think the behavior creates the relation between my People entity and the Tag. But nevertheless it does not save it. |
| # |
Mar 12th 2018, 19:12 |
bakro.istvan |
``` $person = $this->People->newEntity(); if ($this->request->is('post')) { $person = $this->People->patchEntity($person, $this->request->getData()); if ($this->People->save($person)) { ``` does not gets saved. |
| # |
Mar 12th 2018, 19:12 |
bakro.istvan |
I think your plugin does gets the data and starts to process it. ``` |