Log message #4213209

# At Username Text
# Nov 14th 2019, 09:23 jeremy.halin Hi, I'm doing a complex SQL query with `$connection->execute('SELECT * FROM orders')->fetchAll('assoc');`, is it possible to hydrate entities with the resulting data ? Thanks.
# Nov 14th 2019, 09:21 BOSS75 Hello anyone here ??
# Nov 14th 2019, 09:21 scuadra One more question. When I parse the dates in `beforeMarshal()` I want to add my custom rules to check if everything is OK (start_date is before end_date and some other checks). But is it possible to specify these checks to be triggered only on create? :face_with_rolling_eyes:
# Nov 14th 2019, 09:18 BOSS75 ??
# Nov 14th 2019, 09:16 scuadra @conehead thank you. :slightly_smiling_face:
# Nov 14th 2019, 09:12 conehead More input needed
# Nov 14th 2019, 08:59 BOSS75 How to achieve it perfectly in view??
# Nov 14th 2019, 08:59 BOSS75 But in clients browser it shows rectangular box.
# Nov 14th 2019, 08:58 BOSS75 in my browser its all fine .
# Nov 14th 2019, 08:58 BOSS75 ?
# Nov 14th 2019, 08:58 BOSS75 how to have this
# Nov 14th 2019, 08:58 BOSS75 if($travelType == 'Round Trip'){
# Nov 14th 2019, 08:44 conehead @scuadra You would do that in beforeMarshal(). After using create/patchEntity, you should always have a valid Entity that you should be able to save straight away. This is not the case if you do it in beforeSave
# Nov 14th 2019, 08:37 scuadra Hello. I have a form where the user fills some fields and one of them is `dates` in format YYYY-MM-DD - YYYY-MM-DD. In Cake 3 where is the right place to parse the user input to start_date and end_date? Is it beforeMarshal() or beforeSave()
# Nov 13th 2019, 10:34 admad Bot is run by the CakePHP team
# Nov 13th 2019, 10:34 challgren Ohh ok, wasnt sure if it was community run or cake run
# Nov 13th 2019, 10:34 admad @challgren you can send a mail to security@cakephp.org
# Nov 13th 2019, 10:33 challgren Yeah got a security exploit to report
# Nov 13th 2019, 10:33 steinkel https://github.com/cakephp/cakebot this one?
# Nov 13th 2019, 10:32 challgren @steinkel do you know who runs @cakebot
# Nov 13th 2019, 10:31 steinkel @pieceof @javier.villanueva setting pagination to a high value will possibly lead to memory issues or a slow frontend processing, would it be possible to filter/paginate the results in the backend instead?
# Nov 13th 2019, 09:41 javier.villanueva : )
# Nov 13th 2019, 09:39 pieceof finally got something like this working... https://:D:D:D:D/api/hugetable.json?date=2019-09-08*andsort=durationanddirection=descandlimit=50 prolly made some mistake, its like working... suspicius
# Nov 13th 2019, 09:39 javier.villanueva I hope it changes for good
# Nov 13th 2019, 09:37 pieceof search changed a lot in 3 gotta re learn it
# Nov 13th 2019, 09:34 javier.villanueva I remember now xD I had forgot old issues
# Nov 13th 2019, 09:34 javier.villanueva yes, I use in this case Search plugin
# Nov 13th 2019, 09:30 pieceof when using server pagination most prolly u will need some search
# Nov 13th 2019, 09:25 javier.villanueva I will not use js in very big tables
# Nov 13th 2019, 09:22 pieceof :+1:
# Nov 13th 2019, 09:22 javier.villanueva thanks!
# Nov 13th 2019, 09:21 javier.villanueva ok no problem
# Nov 13th 2019, 09:20 pieceof *appcontroller
# Nov 13th 2019, 09:20 pieceof im not sure as im puzzling it too but a public paginator maybe in controller
# Nov 13th 2019, 09:20 javier.villanueva do you set it in appController?
# Nov 13th 2019, 09:19 javier.villanueva yes thanks xD
# Nov 13th 2019, 09:19 pieceof what you want php or js pagination you have to choose
# Nov 13th 2019, 09:18 pieceof go pro
# Nov 13th 2019, 09:17 pieceof thats nap
# Nov 13th 2019, 09:17 javier.villanueva mm I check it xD
# Nov 13th 2019, 09:16 pieceof xD