Log message #3940575

# At Username Text
# Sep 30th 2016, 03:48 prepender How do I build a query in cakephp 3 so that I can get all records from a table that have all the same column values except user_id, created and modified?
# Sep 30th 2016, 01:06 moose517 any of you use the cake based CMS's at all?
# Sep 29th 2016, 23:35 dereuromark would be cool if it was actively maintained, seems to be quite handy combining vagrant and cake this way
# Sep 29th 2016, 23:27 dereuromark yeah not too many
# Sep 29th 2016, 23:05 ceeram @dereuromark https://packagist.org/packages/alt3/cakebox-console/stats
# Sep 29th 2016, 22:43 dereuromark do people actively use cakebox these days?
# Sep 29th 2016, 22:17 ndm np
# Sep 29th 2016, 22:17 Schalla Thanks!
# Sep 29th 2016, 22:17 Schalla Yes, in that case I really need all.
# Sep 29th 2016, 22:17 Schalla True. Glad I asked, you saved me a lot of time. :)
# Sep 29th 2016, 22:17 ndm if you really need all of them
# Sep 29th 2016, 22:17 ndm correct... but you can easily grab them via `$Table->schema()->columns()`
# Sep 29th 2016, 22:15 Schalla That has the disadvantage that I have to add every single column of the base table as well, that's correct @ndm?
# Sep 29th 2016, 22:12 ndm I'd think it's since 3.0
# Sep 29th 2016, 22:12 Schalla Interesting, I will give that a shot now, ty!
# Sep 29th 2016, 22:11 ndm http://book.cakephp.org/3.0/en/controllers/components/pagination.html#control-which-fields-used-for-ordering
# Sep 29th 2016, 22:11 Schalla ndm: Is that behavior new or already since release of 3.0?
# Sep 29th 2016, 22:11 ndm @Schalla You must whitelist fields of associations
# Sep 29th 2016, 22:10 Schalla Anyone ran into that issue before?
# Sep 29th 2016, 22:10 Schalla Assuming Foo has a relation to Bar, when running having sort defined as "Bar.company", Foo's this->paginate results wont sort to the name of Bar.company
# Sep 29th 2016, 22:07 royalty create*
# Sep 29th 2016, 22:07 royalty something hacky i might be able to do is set a page title helper which simply echoes the value given to it or something
# Sep 29th 2016, 22:07 Schalla Hi, I am having bad luck making the paginator work on association. It works fine on the base table, however, when running it on a assoc it just wont sort.
# Sep 29th 2016, 22:06 royalty that won't work very easily in my case i'm afraid
# Sep 29th 2016, 22:06 royalty heh
# Sep 29th 2016, 22:05 Cake3Beginner @royalty: In PSpad Editor (http://www.pspad.com/) there is a function "Find and replace in Folder" where you can replace the variable name (string) in multiple files at once. Not sure about Sublime Text...
# Sep 29th 2016, 22:02 prepender dereuromark: ty
# Sep 29th 2016, 21:59 royalty is there a quick way to just attach a pageTitle property to the view class in 1.3
# Sep 29th 2016, 21:59 royalty so simply replacing them all to title_for_layouts would take long
# Sep 29th 2016, 21:58 royalty I'm on cake 1.2 and want to upgrade to 1.3 the legacy code has a lot of $this->pageTitle defined in the view rather than the controller
# Sep 29th 2016, 21:58 royalty hello cake geniouses
# Sep 29th 2016, 21:55 harry1 can anyone help with this issue: http://stackoverflow.com/questions/39780485/cakephp-crud-api-filtering-fields
# Sep 29th 2016, 21:54 dereuromark http://book.cakephp.org/3.0/en/orm/behaviors/counter-cache.html
# Sep 29th 2016, 21:53 dereuromark isnt the behavior for it documented?
# Sep 29th 2016, 21:53 dereuromark you mean counterCache?
# Sep 29th 2016, 21:53 prepender used to be easy in cakephp2
# Sep 29th 2016, 21:53 prepender How do I make an automatic count column in cakephp 3
# Sep 29th 2016, 21:52 slackebot to configure the filter accordingly like `->add('Alias.created', 'Search.Callback', /* ... */)`.
# Sep 29th 2016, 21:52 ndm @adityapansari Again my bad... should have known better, that's the behavior of the 1.x version. As of 2.x the fields that do not match any filter field name will be removed, ie, you have to go with the nesting solution, like `?created[0]=2016-09-01andcreated[1]=2016-09-03`. If you'd wanted to use named nested fields, then you'd have to nest everything under an alias, like `?Alias[created][from_date]=2016-09-01andAlias[created][to_date]=2016-09-03`,
# Sep 29th 2016, 21:23 slackebot $args and got null array. [ ]
# Sep 29th 2016, 21:23 adityapansari @ndm I tried. Query run. Thanks. ->add('created', 'Search.Callback', [ 'alwaysRun' => true, 'callback' => function ($query, $args, $manager) { debug($args); exit; return $query->andWhere(["Events.start >=" => new FrozenTime($args['from_date'])]) ->andWhere(["Events.start =" = new FrozenTime($args['to_date'])]); } ]);