Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.
ORM from subquery
I currently have
, which produces a DB query like
. However I need a query like
. I thought the best way to do this is to use a subquery, but I got an error saying, that a ->from() is undefined in ORM\Query class. Is there a way to achieve something similar without using direct DB queries?
Try switching to 1.8/dev for the ORM package.
I've made some changes to move WHERE clauses to the subquery when they only reference a column of the main table, and I'm not sure they made the 1.7.2. release.
Could you please provide me a link?
Sorry for not responding, I've had a lot to do.
I've switched to the 1.8 branch, but the result is still the same.
It might fail to detect it can (and should) move the where() clause to the subquery because of your rather complex and/or nesting?
->where('branch_id', 'IN', array_keys(\Session::get('pce_user.active_branches')))
is your primary selection criteria, why is it somewhere inside some and / or construction?
Thanks, moving it outside really helped.
Add a Comment
It looks like you're new here. If you want to get involved, click one of these buttons!
Apply for Membership
↳ Job Board
↳ Installation & Setup
↳ Tips and Tutorials
↳ Code share
In this Discussion