map with list as value in SOQL -
map with list as value in SOQL -
i'm working on little project in salesforce client can master in master-detail relationship more single project object. projects have currency 'max_budget__c' , want calculate max budget per client adding max_budget__c per project. means need collect list per client need client stored can update max_budget__c object of it. thinking storing in map customer__c key , set value, i'm not sure how in single soql query or if i'm looking in right direction. ideas? in advance
let suppose have multiple projects project1, project2 etc .
each has many 1 relationship customer.
i.e many project1 records single client record.
many project2 records single client record , on.
so each client have many project1 records,project2 records etc..
to calculate max budget per client need calculate max budget project1 records,max budget project2 records etc..from each client , add.
so requirement simple write roll summary on each child(each project) , add together roll summaries custom field.
i hope help or please allow me know if else needed.
regards,
naveen
automated deployments , dataloader , sandbox back-ups, test automation salesforce applications
list map salesforce soql
Comments
Post a Comment