function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Pramodh KumarPramodh Kumar 

Help with SOQL statement

Hi,

Can anyone help with the SOQL to represent data in tree structure like, 
+Industry
     +Program
         + Market Product
                 +Taxonomy Concept
                         +Concept Terms
                          term1
                          term2

and here is my schema diagram
User-added image

Thanks,
Pramodh
Prabhat Kumar12Prabhat Kumar12
You can't get data of all objects in one SOQL query. SOQL query is retriving the data from object(table). You need to have plan what data from wchich object you want to retrivie. 
Pramodh KumarPramodh Kumar
I know in one SOQL statement no one cant able to write the query, here i am asking about the ideas to the write