Log message #4126026

# At Username Text
# Mar 18th 2018, 06:20 Sigfried84 Good morning! I am creating a custom helper...how can I set optional arguments and avoid warnings in case an argument is missing?
# Mar 18th 2018, 00:48 turkles answer: ->indexBy()
# Mar 18th 2018, 00:40 turkles how to I get my result set keys to be a specific field?
# Mar 17th 2018, 20:46 richellyitalo Hello. How can i do the cake rest make most fast?
# Mar 17th 2018, 18:55 dereuromark well, if you google it, you will find a lot of references on that one, but you could look into https://stackoverflow.com/questions/27983/sql-group-by-with-an-order-by (also found via google)
# Mar 17th 2018, 18:55 joopm do you have any hint for me please
# Mar 17th 2018, 18:55 joopm haha
# Mar 17th 2018, 18:55 joopm this does not help me
# Mar 17th 2018, 18:55 dereuromark yeah that doesnt work :slightly_smiling_face:
# Mar 17th 2018, 18:54 joopm ->group(['model_id'])->order(['created'=>'DESC'])
# Mar 17th 2018, 18:54 joopm i made a query filter it with ->group(['model_id']) i also want that only the last datetime ->order(['created'=>'DESC'])
# Mar 17th 2018, 18:52 joopm my problem is a bit more complicated
# Mar 17th 2018, 18:52 Rif2007 i dont know if i will be able to help but let others see
# Mar 17th 2018, 18:51 Rif2007 what was your problem joopm
# Mar 17th 2018, 18:51 Rif2007 ahh... let me reback...
# Mar 17th 2018, 18:50 joopm make it composite in mysql and cake will make automatically the associations for you
# Mar 17th 2018, 18:49 joopm than dont use 'id' field in the table just the 2 foreing key names
# Mar 17th 2018, 18:49 joopm but if you really need using composite keys
# Mar 17th 2018, 18:49 joopm yes dont mess with 'id'
# Mar 17th 2018, 18:48 dereuromark I agree. Keep things simple. id as only primary key.
# Mar 17th 2018, 18:48 Rif2007 yes
# Mar 17th 2018, 18:48 Rif2007 Lucky me I am just 3 days old. But how to handle around the association. Yes, I have firsts, seconds as well
# Mar 17th 2018, 18:48 joopm and you want to connect them in the thirds
# Mar 17th 2018, 18:48 joopm as i suppose you have a firsts,seconds tables too
# Mar 17th 2018, 18:47 joopm if you still learn cakephp using composite keys not the best practice
# Mar 17th 2018, 18:45 joopm moment
# Mar 17th 2018, 18:45 Rif2007 and the table has 3 fields (id [PK], first_id[PK], data3)
# Mar 17th 2018, 18:43 Rif2007 sorry for the wired formating
# Mar 17th 2018, 18:43 Rif2007 public function view($id = null) { $third = $this->Thirds->get($id, [ 'contain' => ['Firsts'] ]); $this->set('third', $third); }
# Mar 17th 2018, 18:42 Rif2007 it exists alright
# Mar 17th 2018, 18:42 Rif2007 this is just a fresh bake with a table having a composit primary key
# Mar 17th 2018, 18:42 joopm did you check in the database manually if that record exist?
# Mar 17th 2018, 18:41 Rif2007 so I have this ----> Record not found in table "thirds" with primary key ['1']
# Mar 17th 2018, 18:41 joopm so as i see you have a thirds table
# Mar 17th 2018, 18:41 Rif2007 ok, a ray of hope....
# Mar 17th 2018, 18:41 Rif2007 oh, so they help
# Mar 17th 2018, 18:41 joopm tell me your question first
# Mar 17th 2018, 18:40 joopm nou i am not really new here
# Mar 17th 2018, 18:40 Rif2007 Lets see what problem you got....
# Mar 17th 2018, 18:40 Rif2007 I am new here
# Mar 17th 2018, 18:40 Rif2007 no one here seems to help anyone