Log message #4201999

# At Username Text
# Sep 6th 2019, 09:54 jotpe @neon1024 I removed the ->first() and tried to replace it with the example from here https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#custom-finder-methods both didn't work. Seems that the method cannot be found on that table?!
# Sep 6th 2019, 09:51 alexdd55976 @jotpe except from your problem... i find the your `$emailTable->find('ownedBy)` somehow very disturbing. especially because its somehow generic (which would be fine) but then in a specific model... why not calling a model method directly with the user_id, which is available anyway? :thinking_face:
# Sep 6th 2019, 09:49 javier.villanueva and you dont need ->getIdentifier() in call
# Sep 6th 2019, 09:48 javier.villanueva +1
# Sep 6th 2019, 09:48 javier.villanueva yes
# Sep 6th 2019, 09:48 neon1024 Calling `first()` you’re executing, converting to ResultSet and popping the first Entity
# Sep 6th 2019, 09:48 neon1024 So that you can chain finders
# Sep 6th 2019, 09:48 neon1024 A custom finder should return a `Query` instance right?
# Sep 6th 2019, 09:47 neon1024 @jotpe You’re calling `->first()`
# Sep 6th 2019, 09:46 jotpe Cleared Cache, but didn't changed anything. $user is the user and $user->getIdentifier() is the userId. I changed this, but it didn't even get into the function...
# Sep 6th 2019, 09:45 alexdd55976 i upvoted your answer ;)
# Sep 6th 2019, 09:42 javier.villanueva $emailTable->find('ownedBy', ['user' => $user]);
# Sep 6th 2019, 09:42 javier.villanueva or
# Sep 6th 2019, 09:42 javier.villanueva $query->where(['user_id' => $user, 'status' => 'confirmed']
# Sep 6th 2019, 09:41 javier.villanueva user is the id?
# Sep 6th 2019, 09:41 david098 did you cleared the cache?
# Sep 6th 2019, 09:34 jotpe Anyone has a clue why the custom finder is not working? I sticked to https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#custom-finder-methods
# Sep 6th 2019, 09:34 slackebot <jotpe>
# Sep 6th 2019, 09:31 david098 Thanks for pushing me in the right direction
# Sep 6th 2019, 09:31 david098 For the onces who have looked into my issue yesterday, i created a working solution; https://stackoverflow.com/questions/57807225/
# Sep 6th 2019, 09:12 racmiroslav thank you for advice
# Sep 6th 2019, 09:04 alexdd55976 except `number` is the primary key of the table
# Sep 6th 2019, 09:04 neon1024 @racmiroslav https://github.com/ADmad/cakephp-sequence
# Sep 6th 2019, 09:03 alexdd55976 yes, you can do that. did that before too
# Sep 6th 2019, 09:02 racmiroslav @alexdd55976 I mean to save entity with `$this->Documents->save($doc)`
# Sep 6th 2019, 09:01 alexdd55976 $this->find()->select(['MAX(number)])->where(['scope' => 'stuff'])
# Sep 6th 2019, 09:01 racmiroslav or… when I run this subquery in beforeSave within transaction, will it satisfy concurrency issues?
# Sep 6th 2019, 08:59 racmiroslav Hey folks. What are your suggestions to implement number series for table row property? I need to increment value on insert. is it possible with ORM? something like ```$doc = new Document(); $doc->number = $query->newExpr('SELECT MAX(number) FROM Documents WHERE scope = xy')```
# Sep 6th 2019, 08:59 peppejaripappalardo thx to @neon1024 and @alexdd55976 i will tru extractOriginalChanged
# Sep 6th 2019, 08:58 alexdd55976 `$changed = $entity->extractOriginalChanged($entity->visibleProperties());`
# Sep 6th 2019, 08:58 peppejaripappalardo this is what i do: if ($entity->actor->incident_type_group->description != $entity->actor->incident_type_group->getOriginal(‘description’)) { $modified_fields[] = [‘was’ => $entity->actor->incident_type_group->getOriginal(‘description’), ‘is_now’ => $entity->actor->incident_type_group->description, ‘field_name’ => ‘description’]; }
# Sep 6th 2019, 08:57 neon1024 As what you’re doing is what this function does for you
# Sep 6th 2019, 08:57 neon1024 Did you check `$entity->isDirty($propertyName)`
# Sep 6th 2019, 08:57 neon1024 Perhaps they haven’t changed
# Sep 6th 2019, 08:56 peppejaripappalardo Hello guys, a little help please. i am using $entity->getOrigina(property), and i check the diff with entity->property, but how is possible that the getOriginal(property) return the same of the $entity->property? i premise that i made a changes into the database of the property that i trying to check the old result
# Sep 6th 2019, 08:55 alexdd55976 not so happy for people who are working on yii unittests and sh*t does not work :(
# Sep 6th 2019, 08:47 dereuromark I found a php5 fix after all
# Sep 6th 2019, 08:38 neon1024 Hey everyone. Happy Friday :tada:
# Sep 6th 2019, 06:02 alexdd55976 morning
# Sep 6th 2019, 05:50 conehead morning
# Sep 6th 2019, 05:36 javier.villanueva morning all