Log message #4119785

# At Username Text
# Feb 25th 2018, 21:09 Sigfried84 if you're still here...
# Feb 25th 2018, 21:09 Sigfried84 just one more thing...how do i concatenate them?
# Feb 25th 2018, 21:08 savant no problem, night
# 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