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

Popular posts from this blog

formatting - SAS SQL Datepart function returning odd values -

c++ - Apple Mach-O Linker Error(Duplicate Symbols For Architecture armv7) -

php - Yii 2: Unable to find a class into the extension 'yii2-admin' -