FuelPHP Forums

sveatlo

Hi!
I currently have this code, which produces a DB query like this. However I need a query like this. 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?

Harro

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.

sveatlo

Could you please provide me a link?

Harro

https://github.com/fuel/orm/archive/1.8/develop.zip

sveatlo

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.

Harro

It might fail to detect it can (and should) move the where() clause to the subquery because of your rather complex and/or nesting?

If

->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?

sveatlo

Thanks, moving it outside really helped.

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

Howdy, Stranger!

Categories

In this Discussion