Log message #4119798

# At Username Text
# Feb 26th 2018, 09:31 turkles Ah, thanks
# Feb 26th 2018, 09:24 neon1024 `$player = $results->firstMatch(['player_id' => 123]);`
# Feb 26th 2018, 09:19 turkles Hi :slightly_smiling_face: if I have done a find()->contain('Players') how can I check if a player with id 123 was in the contained results
# Feb 26th 2018, 09:14 neon1024 Morning all
# Feb 26th 2018, 07:28 kitcat711_ Bonjour
# Feb 25th 2018, 21:16 Sigfried84 okk
# Feb 25th 2018, 21:15 savant dont remember, heading into the shower
# Feb 25th 2018, 21:15 Sigfried84 in an Authorities Entity?
# Feb 25th 2018, 21:14 Sigfried84 the example is not a join field...would it be like: $this->Authors->_properties['name'] ?
# Feb 25th 2018, 21:12 Sigfried84 cool! thnx! bye!
# Feb 25th 2018, 21:11 savant https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#customize-key-value-output <-- that
# Feb 25th 2018, 21:10 Sigfried84 bye!
# Feb 25th 2018, 21:10 Sigfried84 late ^_^!
# 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