Welcome, Guest

Design your application

Can nested queries work with Cook's ORM

TOPIC: Can nested queries work with Cook's ORM

Can nested queries work with Cook's ORM 15 Jun 2017 17:07 #15217

vlemos Online Elite Member Posts: 295 Thank you received: 41 Karma: 21	Hello Admin How can I implement nested selects with ORM or return a fixed value as a field? Ex: 'status' = `online`; Thanks vlemos
	The administrator has disabled public write access.

Can nested queries work with Cook's ORM 24 Jun 2017 09:41 #15228

liubov Offline Elite Member (=) 10 mn and it's ready! Posts: 278 Thank you received: 35 Karma: 22	If you design the Item layout, you could find the appropriate ORM query to display the value in the Item Model. If you want to add / complement or overwrite queries with ORM, you need to go in the Project Configuration / SQL Queries. Then choose 'Explosed'. Then you could add your specific queries with ORM or standard (AddJoin, AddSelect, still works too in Explosed Mode...)
	Last Edit: 24 Jun 2017 09:42 by liubov. The administrator has disabled public write access. The following user(s) said Thank You: vlemos

Can nested queries work with Cook's ORM 25 Jun 2017 05:49 #15229

vlemos Online Elite Member Posts: 295 Thank you received: 41 Karma: 21	Yes, I did it with: //SELECT $this->addSelect('......'); even without Exploded I think So thanks again my friend!
	The administrator has disabled public write access.

Can nested queries work with Cook's ORM 25 Jun 2017 10:46 #15230

liubov Offline Elite Member (=) 10 mn and it's ready! Posts: 278 Thank you received: 35 Karma: 22	And what's happenned ? not working fine ? Give me an example of what you want do to, maybe i can help you ...
	The administrator has disabled public write access. The following user(s) said Thank You: vlemos

Can nested queries work with Cook's ORM 26 Jun 2017 21:00 #15231

vlemos Online Elite Member Posts: 295 Thank you received: 41 Karma: 21	Hey liubov, It is interesting how things happen at times. After working to develop the select query I found a better way which is more consistent and reusable in my model. But it wasn't a bad learning experience either. Thanks again v
	The administrator has disabled public write access.

Design your application

Can nested queries work with Cook's ORM

Time to create page: 0.099 seconds

Get Started