All Lectures are really align and proper learning path.. Great work by Apexhour team.. Content like this not even explained in paid courses also. Thank you guys.
An other great session - thank you guys!! One question: The child record query from 1:06:30 - could we use that to initiate a map instead of list? How to write that?
@@apexhours Yes, sure. The code shown in 1:06:30 is like this: List lstAcc = [SELECT Name, (SELECT Id, Name, CloseDate FROM Opportunities) FROM Account]; I wonder if it's possible to use a map instead, where the AccountId is the key and Opportunities the values Map. Can I use a single Query to introduce a map? I believe not - but what do I know, I'm beginner … Have tried: Map lstAcc = [SELECT Id, (SELECT Id, Name, CloseDate FROM Opportunities) FROM Account]; ERROR: Illegal assignment from List to Map Makes total sense … probably a dumb question … sorry, think I've answered it for myself 😅
@@heikokraemer2735 i guess a bit of external processing you can do that Map accMap = [SELECT ID, (SELECT ID FROM OPPORTUNITY) FROM ACCOUNT] ; Map oppMap = new Map(); for(Id accid : accMap.keySet()) { Account acc = accMap.get(accid); If(oppMap.contains(accid)) { LIST temp = oppMap.get(accid); Temp.addall(acc.opportunities); OppMap.put(accid, temp) ; } Kindly ignrke some basic mistake, wrote this on a phone....
First of all thank you for this. This is really informative. But one thing wanna know that, you have used for loop under another for loop which is not a best practice. Let know if I am not wrong. Thanks
If have created a report and report type contains Accounts, Custom object lets say B. I am filtering in report using Account record type and record type from B. COULD YOU PLEASE TELL ME HOW CAN WE WRITE A SOQL QUERY FOR THIS?? PLEASE
I want to send you some money as a thank you. Typically, there’s a THANK YOU button on a monetized channel where a viewer like me can click and send you cash 💰 Why don’t you have the THANK YOU button to accept money from grateful viewers? I’ve learned so much, I’m so grateful 😇
SHello Sir can you help me with this?? Select AccountId,max(Amount) from Opportunity where AccountId = '0015i00000NCb9lAAD' group by AccountID I should get the result as 915000 but getting 91500 . Can you explain me why this is happening?
at 32:24 how did you get the API name for Account Name in Opportunity because when i look in field and relationship for opportunity in object manager field Name for Account Name is AccountId. please explain i am new in salesforce and i am having hard time finding those value api name.
AccountId is a standard field refers to the salesforce Id of the account but if you want to fetch any field values from child to parent you need to eliminate the Id key word and refer the account fields with Account.AccountfieldAPIname but if its custom field then you need to append __r.AccountfieldAPIname. So lets say if the custom lookup field API name is AccountId__c then you need to use AccountId__r.AccountfieldAPIname