Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
sandeep reddy 37sandeep reddy 37 

sub query solution

can any one please tell me how to get child records from parent object 
this the coad 


public class shopcart {
    public list<srinivasreddy__shopcart__c> scart{set;get;}
    public list<srinivasreddy__aproduct__c> apro{set;get;}
    public list<id> ids{set;get;}
    public shopcart(){
       apro=[select srinivasreddy__price__c,Name,(select Name,srinivasreddy__quantity__c,srinivasreddy__total__c from srinivasreddy__shopcart__r)  from srinivasreddy__aproduct__c];
       ids=new list<id>();
        scart=new list<srinivasreddy__shopcart__c>();
    }
    public void addproduct(){
        for(srinivasreddy__aproduct__c c:apro){
          srinivasreddy__shopcart__c sc=new srinivasreddy__shopcart__c();  
           sc.srinivasreddy__cartproduct__c=c.id;
            sc.Name=c.Name;
            scart.add(sc);
        }
        insert scart;
       
    }
}
}
Aniket Malvankar 10Aniket Malvankar 10
Hello Sandeep, 

Did you check on cross object field?

Thanks
Aniket
sfdcMonkey.comsfdcMonkey.com
hi sandeep
go to below link for understand how to query parent to child and child to parent in salesforce
http://www.sfdc99.com/2013/06/24/example-how-to-write-a-cross-object-soql-query-part-2/

i hop it helps you
Thanks :)
 
sfdcMonkey.comsfdcMonkey.com
and you cannot  contain two consecutive underscore characters in custom fields of custom object (in your case i see srinivasreddy__shopcart__c)
thanks
Naveen DhanarajNaveen Dhanaraj
[select srinivasreddy_price__c,Name,(select Name,srinivasreddy_quantity__c,srinivasreddy_total__c from srinivasreddy_shopcart__r)  from srinivasreddy_aproduct__c];
Do you any relationship between two objects..??
 
sandeep reddy 37sandeep reddy 37
yes srinivasreddy_aproduct__c is master and srinivasreddy_shopcart__r is child object look up relation