You need to sign in to do that
Don't have an account?
Naresh_reddy
need help on parent to child query
what we need to fetch all records present in paymentlineitems from payment,using parent to child nested relation ship query.
how to write this query?
can any one help me
please check below
how to write this query?
can any one help me
please check below
Try this type nested Parent to child query for your Requrment
Select Name, (Select Name, Price__c From Child__c) From Parent__c
Thanks :)
If my answer helps you to solve your problem please mark it as best answer. It will help other to find best answer.
fields in payment: name
payment_schedule --->parent
fields payment_schedule : name
Payment line item -->child
fields in Payment line item : name , price__c
here having m-d relation ship between payment line item (child ) and payment_schedule (parent) and a m-d relation ship between payment_schedule (child )and payment (parent)
grand parent (payment )----- > child (Payment line item) .
@soni piyush : this is a nested query right , r u sure whether this will fet h the records of the child using parent to child rel ???
fields in payment: name , parent__r(lookup)
payment_schedule --->parent
fields payment_schedule : name , child__r(lookup)
Payment line item -->child
fields in Payment line item : name , price__c
Select Parent__r.child__c, Parent__c From grandParent__c