Log message #4170637

# At Username Text
# Oct 6th 2018, 22:55 rightscoreanalysis but when I debug $result->first() I do not see the model I have joined on
# Oct 6th 2018, 22:53 rightscoreanalysis ok so moving the 'first()' to the end of the query fixes the error I was seeing
# Oct 6th 2018, 22:52 dereuromark find() and count(), all() are closing ones. after that you get a collection, not a query
# Oct 6th 2018, 22:52 dereuromark you need to understand how the orm works.
# Oct 6th 2018, 22:51 rightscoreanalysis ok so find() should be the last thing
# Oct 6th 2018, 22:51 dereuromark you cannot close a query though and then continue doing things on the resulting entity.
# Oct 6th 2018, 22:51 rightscoreanalysis Or Properties / properties
# Oct 6th 2018, 22:51 rightscoreanalysis should it be singlur Property with table named 'properties'
# Oct 6th 2018, 22:50 rightscoreanalysis I am modelling Properties
# Oct 6th 2018, 22:50 dereuromark the error message tells you that (entity vs table/query)
# Oct 6th 2018, 22:50 rightscoreanalysis I think there maybe some confusion with my model names
# Oct 6th 2018, 22:50 dereuromark where()->leftJoin()->first()
# Oct 6th 2018, 22:50 rightscoreanalysis Ok I'll take a few steps back
# Oct 6th 2018, 22:50 dereuromark also, first() closes a query, why are you doing leftJoin after a first()?
# Oct 6th 2018, 22:49 dereuromark using ->belongsTo(), ->has...() etc
# Oct 6th 2018, 22:49 dereuromark still, you could set up all the relations
# Oct 6th 2018, 22:48 rightscoreanalysis it's because I need to do some deep filtering
# Oct 6th 2018, 22:47 dereuromark why are you doing manual joins? I always set up my relations in the table classes and then can just use contain()
# Oct 6th 2018, 22:47 rightscoreanalysis similarly I am also getting: Call to undefined method App\Model\Entity\Property::innerJoinWith()
# Oct 6th 2018, 22:44 rightscoreanalysis I am unable to do any joins it seems
# Oct 6th 2018, 22:38 rightscoreanalysis leftJoin - sorry typo
# Oct 6th 2018, 22:38 slackebot <rightscoreanalysis>
# Oct 6th 2018, 22:30 dereuromark lef or left?
# Oct 6th 2018, 22:28 rightscoreanalysis why is that?
# Oct 6th 2018, 22:28 rightscoreanalysis I tried another approach and now I see: Call to undefined method App\Model\Entity\Property::lefJoin()
# Oct 6th 2018, 22:18 rightscoreanalysis do I need to specify the fields in order to see the join, I seems to remember something similar in cake2
# Oct 6th 2018, 22:18 rightscoreanalysis hi guys, I'm doing a simple join on my query - when I debug the result it is empty
# Oct 6th 2018, 21:28 murat I haven't used that before. Thanks.
# Oct 6th 2018, 21:28 dereuromark jep
# Oct 6th 2018, 21:27 murat `Table::schema()`?
# Oct 6th 2018, 21:26 dereuromark you can make it work reading fields of schema()
# Oct 6th 2018, 21:26 murat Is it completely removed?
# Oct 6th 2018, 21:25 dereuromark not in 3.x
# Oct 6th 2018, 21:25 murat When I create a query with fields option, I can't just say `'TableName.*'` in fields array, right?
# Oct 6th 2018, 21:23 murat Thank you.
# Oct 6th 2018, 21:23 murat :,'( Yes.
# Oct 6th 2018, 21:20 dereuromark not reading it. how does your find look like? sounds like you are not querying the id. check your sql query
# Oct 6th 2018, 21:16 slackebot array (size=0) empty public '[errors]' => array (size=0) empty public '[invalid]' => array (size=0) empty public '[repository]' => string 'Type' (length=4)```
# Oct 6th 2018, 21:16 murat ``` object(App\Model\Entity\Type)[1243] public 'name' => string '.......' (length=19) public 'dept_id' => int 3 public '[new]' => boolean false public '[accessible]' => array (size=2) '*' => boolean true 'id' => boolean false public '[dirty]' => array (size=0) empty public '[original]' => array (size=0) empty public '[virtual]' =>
# Oct 6th 2018, 21:15 murat What the hell am I doing to get a null from `$entity->id`?
# Oct 6th 2018, 21:13 murat I get null.