eZ Community » Forums » Developer » making subquery or query like mysql...
expandshrink

making subquery or query like mysql jointure

making subquery or query like mysql jointure

Thursday 22 September 2016 5:36:21 pm

hi,
I spend my time since a begin this projet on ez to find the right and goods tutorials and good documentations for eZ5...Now as I success to render a bundle controler where I want in my pagelayout template.
Now I would like to make a query and a subquery to 2 differents content-type one I call categories and second content_category. The second is linking to categories or to another content_category normaly I other framework I could usually make a join and a recursive request in Mysql how doing that with eZplatform framework ?!
In normal case I use Msql command join and I could have the array I need. But with eZplatform is it possible to make a fake of this kind of jointure ??? For the moment I success to make 2 query first one to get catgories and second to get category_content and is id content_categories id but have trouble in my template to render the id I get. I'm tired and boring explore all forum about Ez where we don't know if is specific answer for eZ4 or eZ5... 
There is anyone who could explain me how to do a 2 query with a join between two content type or to tell how to construct a good eZrender array content from my own array result to give to my controler template and have in twig template a good eZrender field...????
thanks to all 

  

No reply yet!

expandshrink

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu

Proudly Developed with from