You need to sign in to do that
Don't have an account?
Divya Gupta 11
Contacts and Orders
Hi,
I've standard contact and custom orders. Now I want to show contacts with all their associated orders with them. Meanwhile, I want show total amount of all orders for that contact too. Any help for the query ?
I've standard contact and custom orders. Now I want to show contacts with all their associated orders with them. Meanwhile, I want show total amount of all orders for that contact too. Any help for the query ?
The best way to do this by creating one more rollup summary field (count of order), since you don’t want to create new field please try something like this.
Select Id, Name from Contact where Id In (Select Contact__c from Order__c)