TOPIC:

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

vlemos Topic Author Offline Elite Member Posts: 295 Thank you received: 41	Hello Admin How can I implement nested selects with ORM or return a fixed value as a field? Ex: 'status' = `online`; Thanks vlemos
	Please Log in or Create an account to join the conversation.

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: 279
Thank you received: 36

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...)

The following user(s) said Thank You: vlemos

Please Log in or Create an account to join the conversation.

Last edit: by liubov.

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

vlemos Topic Author Offline Elite Member Posts: 295 Thank you received: 41	Yes, I did it with: //SELECT $this->addSelect('......'); even without Exploded I think So thanks again my friend!
	Please Log in or Create an account to join the conversation.

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: 279 Thank you received: 36	And what's happenned ? not working fine ? Give me an example of what you want do to, maybe i can help you ... The following user(s) said Thank You: vlemos
	Please Log in or Create an account to join the conversation.

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

vlemos Topic Author Offline Elite Member Posts: 295 Thank you received: 41	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
	Please Log in or Create an account to join the conversation.

Page:
1

Forum

Support forum

Design your application

Can nested queries work with Cook's ORM

Time to create page: 0.138 seconds

“

”

WOW.. WOW... WOW... This is awesome... in less than 3 hours of work I have my application done... this is simply the best tool I ever tried to generate Joomla Components... Thank you very much for this tool and your answer.. it helped me a lot... My friends here in Brazil are going nuts with this...
Griiettner (Forum)