# |
Feb 25th 2018, 21:07 |
Sigfried84 |
Ok savant, I'll try to find out how tomorrow! Now I'm heading to bed! Thank you so much! |
# |
Feb 25th 2018, 21:05 |
savant |
good luck :slightly_smiling_face: |
# |
Feb 25th 2018, 21:05 |
savant |
find(‘list’) ^ |
# |
Feb 25th 2018, 21:05 |
savant |
https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#finding-key-value-pairs |
# |
Feb 25th 2018, 21:04 |
Sigfried84 |
i added a ->['contain' => ['Authors', 'AuthorTypes']] |
# |
Feb 25th 2018, 21:04 |
savant |
im headed into the shower, but the above shows how to use contain |
# |
Feb 25th 2018, 21:04 |
savant |
https://book.cakephp.org/3.0/en/orm/query-builder.html#loading-associations |
# |
Feb 25th 2018, 21:03 |
savant |
you’d need to `contain` the extra tables - it’s like joining - and modify the `fields` that are retrieved for that find |
# |
Feb 25th 2018, 21:03 |
Sigfried84 |
a concatenation of these fields? |
# |
Feb 25th 2018, 21:02 |
Sigfried84 |
how and make it show author.name and author_type.name? |
# |
Feb 25th 2018, 21:02 |
savant |
you’ll need to modify that find(‘list’) call to get it to show something other than the `id` as the displayField |
# |
Feb 25th 2018, 21:02 |
savant |
so the authorities dropdown is populated by the Authorities->find(list) call |
# |
Feb 25th 2018, 20:51 |
Sigfried84 |
Sorry for the delay |
# |
Feb 25th 2018, 20:50 |
Sigfried84 |
Books/add.ctp https://www.irccloud.com/pastebin/3JuAw1Mr/ |
# |
Feb 25th 2018, 20:49 |
Sigfried84 |
Books Controller https://www.irccloud.com/pastebin/QsV0ywdZ/ |
# |
Feb 25th 2018, 20:41 |
Sigfried84 |
sure...let me fix some things...i messed up something ^_^! |
# |
Feb 25th 2018, 20:33 |
savant |
can you gist the add.ctp and your BooksController.php as well |
# |
Feb 25th 2018, 20:27 |
Sigfried84 |
(illustrators table is unnecessary...) |
# |
Feb 25th 2018, 20:26 |
Sigfried84 |
https://www.irccloud.com/pastebin/LfFZynZ2/ |
# |
Feb 25th 2018, 20:23 |
savant |
just trying to get you to actually show all the information so Im not guessing at what im looking at |
# |
Feb 25th 2018, 20:22 |
Sigfried84 |
Sure I can |
# |
Feb 25th 2018, 20:22 |
Sigfried84 |
lol...in no way was my intention to assume you don't know how it works. Sorry for that. |
# |
Feb 25th 2018, 20:22 |
savant |
Can you show your _entire_ database schema? |
# |
Feb 25th 2018, 20:21 |
savant |
if it helps to prove that, I’m one of the core developers |
# |
Feb 25th 2018, 20:21 |
savant |
I know how cakephp works |
# |
Feb 25th 2018, 20:21 |
Sigfried84 |
sorry I did not post books table because I thought field there were irrelevant as no fields refer to authorities, authors, etc. Bake deduces relation and includes an input with authorities_ids. |
# |
Feb 25th 2018, 20:20 |
savant |
in your controller |
# |
Feb 25th 2018, 20:20 |
savant |
you’d need to change the find call to do that |
# |
Feb 25th 2018, 20:19 |
Sigfried84 |
well...the thing is how to get two join field to be a display field....so how author.name + author_type.name can be displayfield of authorities_books |
# |
Feb 25th 2018, 20:19 |
savant |
where is the books table |
# |
Feb 25th 2018, 20:16 |
Sigfried84 |
here :) https://www.irccloud.com/pastebin/o0GUan8M/ |
# |
Feb 25th 2018, 20:13 |
savant |
im not asking for stuff from you for my health ;) |
# |
Feb 25th 2018, 20:13 |
Sigfried84 |
:D |
# |
Feb 25th 2018, 20:13 |
Sigfried84 |
lol..obviously no problem to show that! |
# |
Feb 25th 2018, 20:13 |
Sigfried84 |
the thing is how can i get a a joined field to be a display field |
# |
Feb 25th 2018, 20:13 |
savant |
but if you dont want to show the table schema because you think its not useful, thats fine, I dont need to help :slightly_smiling_face: |
# |
Feb 25th 2018, 20:12 |
savant |
i know how cake bake works, so my guess is that the dropdowns are showing an id instead of the name field because the displayField of your tables is being incorrectly detected |
# |
Feb 25th 2018, 20:12 |
savant |
just saying if someone is asking for something, they are probably asking for good reason |
# |
Feb 25th 2018, 20:11 |
Sigfried84 |
enjoy it :D |
# |
Feb 25th 2018, 20:11 |
Sigfried84 |
ok ;) |
# |
Feb 25th 2018, 20:11 |
savant |
good luck! |