Log message #4184806

# At Username Text
# Apr 26th 2019, 18:16 jnguyen is there*
# Apr 26th 2019, 18:16 jnguyen is any work around?
# Apr 26th 2019, 18:15 jnguyen ah ok
# Apr 26th 2019, 18:15 ricksaccous okay yeah i think that's where the problem is
# Apr 26th 2019, 18:15 jnguyen yes
# Apr 26th 2019, 18:15 ricksaccous @jnguyen?
# Apr 26th 2019, 18:14 ricksaccous is the custom finder being used to define an association in this case?
# Apr 26th 2019, 18:12 ricksaccous hmmmm
# Apr 26th 2019, 18:12 ricksaccous there is somewhere in the book about limitations on pagination when using custom finders
# Apr 26th 2019, 18:11 jnguyen ah ok so I can't use sortWhiteList if I use a custom finder?
# Apr 26th 2019, 18:11 ricksaccous yeah that's the limitations of custom finders with pagination
# Apr 26th 2019, 18:10 jnguyen Hey guys, so I have a problem when I use the pagination component , when I use a custom finder I'm not able to sort the data
# Apr 26th 2019, 15:09 hollistergraham123 So right now I set the view var by doing $this->set([‘var’ => $var, ‘_serialize’ => ‘var’]); I am assuming your saying do some sort of getmethod $this->set([‘_serialize’ => array_merge($this->getViewVar(), ‘user’)]);
# Apr 26th 2019, 15:07 admad and it's not a "function", just an array
# Apr 26th 2019, 15:06 admad so merge instead of overwriting
# Apr 26th 2019, 15:05 hollistergraham123 Is there a way to push variables to the _serialize function. I.e. I want to always send back the logged in user data along with whatever the individual controller function sends. I put the serialize function in Appcontroller on the beforeRender event to serialize the user var but it is overriding what got serialize in the controller method.
# Apr 26th 2019, 15:00 dereuromark you can only lose/delete data if you store additional fields in your pivot table. but fair enough :slightly_smiling_face:
# Apr 26th 2019, 14:59 hollistergraham123 Good point
# Apr 26th 2019, 14:57 dereuromark it is important to not call this delete, as no records on the both sides should be removed (or people think they might).
# Apr 26th 2019, 14:56 hollistergraham123 Thank you! I swear I looked through all of the delete documentation before asking!
# Apr 26th 2019, 14:56 admad yup unlink() is the way then
# Apr 26th 2019, 14:56 dereuromark I just remembered that I used that for tags module.
# Apr 26th 2019, 14:56 dereuromark https://book.cakephp.org/3.0/en/orm/saving-data.html#unlink-many-to-many-records :slightly_smiling_face:
# Apr 26th 2019, 14:55 admad ah, miread
# Apr 26th 2019, 14:55 dereuromark I think he wants to keep both sides, though.
# Apr 26th 2019, 14:55 admad dont need to do anything explicitly
# Apr 26th 2019, 14:54 admad join table records are automatically deleted if a primary table record is deleted
# Apr 26th 2019, 14:54 dereuromark isnt there even unlink() or sth?
# Apr 26th 2019, 14:53 dereuromark Simplest solution is to work on this pivot table directly, ->delete($entity) or deleteAll( with conditions)
# Apr 26th 2019, 14:52 hollistergraham123 How do I delete just a relationship in cakephp. In my use case I have users with many to many relationship with stores. If I just want to remove a user from that store. How can I just delete the join record?
# Apr 26th 2019, 13:55 hippo :thumbsup: trying to track down the issue now.. Just thought I'd mention it in here as well!
# Apr 26th 2019, 13:54 dereuromark otherwise you can open a ticket with a detailed report on how to reproduce.
# Apr 26th 2019, 13:54 dereuromark hippo: if you can trace down the issue, maybe you can open a PR to fix things.
# Apr 26th 2019, 13:53 hippo (postgres)
# Apr 26th 2019, 13:53 dereuromark to all involved parties.
# Apr 26th 2019, 13:53 dereuromark using the ext is always cleaner. it more clearly communicates the type via ext.
# Apr 26th 2019, 13:53 hippo I'm having a strange issue where I'm using `$import` in a fixture, one of the columns `char(32)` is created in the test database as `CHAR` which results in a length of 1 (ie. as if it was doing `char(1)`)
# Apr 26th 2019, 13:51 martin I did fight with that a few times :P
# Apr 26th 2019, 13:46 neon1024 Ahh, yes, good idea! Thanks @admad
# Apr 26th 2019, 13:46 admad explicitly set view class to Json
# Apr 26th 2019, 13:44 neon1024 Silly question, but how can I have my api respond with json without having to use a .json extension? I’ve done it before by forcing the headers in a middleware, but it feels a bit hacky. Feels a bit like I should be able to set the response type by routing prefix or something