Log message #4170644

# At Username Text
# Oct 6th 2018, 23:08 dereuromark I see. yeah, the joins here are wrong then
# Oct 6th 2018, 23:04 rightscoreanalysis Column not found: 1054 Unknown column 'Rooms.id' in 'where clause'
# Oct 6th 2018, 23:04 rightscoreanalysis the error I got which lead me to believe contain would not work for me in this case is:
# Oct 6th 2018, 23:04 rightscoreanalysis https://gist.github.com/spacebiscuit/13497a100c2f6c453c4f3d097dd78498
# Oct 6th 2018, 23:04 rightscoreanalysis this is what I was attempting with contains:
# Oct 6th 2018, 22:59 rightscoreanalysis Ok let me post my previous contains to see if I can expalin the issue I had
# Oct 6th 2018, 22:56 dereuromark the join probably doesnt without select() field naming. another reason to use relations and contain :slightly_smiling_face: I guess
# 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?