Welcome, Guest
Username: Password: Remember me

TOPIC: Can nested queries work with Cook's ORM

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

  • vlemos
  • vlemos's Avatar
  • Offline
  • Elite Member
  • Posts: 274
  • Thank you received: 38
  • Karma: 20
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
  • liubov's Avatar
  • Online
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 259
  • Thank you received: 32
  • 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
  • vlemos's Avatar
  • Offline
  • Elite Member
  • Posts: 274
  • Thank you received: 38
  • Karma: 20
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
  • liubov's Avatar
  • Online
  • Elite Member
  • (=) 10 mn and it's ready!
  • Posts: 259
  • Thank you received: 32
  • 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
  • vlemos's Avatar
  • Offline
  • Elite Member
  • Posts: 274
  • Thank you received: 38
  • Karma: 20
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.
Time to create page: 0.060 seconds

Get Started