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.
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
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....
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
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
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 😇
Check this post to PPT and code for this session www.apexhours.com/soql-sosl-dml-in-salesforce/
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.
These teachers and content designers deserve the BEST OF THE BEST AWARD 🥇
Some of these videos have good breakdowns of what's essential. Useful.
Glad it was helpful!
Your Lectures are awesome please make course for certification on PD1
This course will cover lots of topic but we will plan one soon for PD1 exam as well.
For 32:30, did you create the account_name__C object off-screen? For my demo, it exists in the account, but not in opportunities.
Excellent teaching sir👌👌👌
Also could u pls make session on copado tutorials?
Will try
Excelente. Gracias.
Thanks
This is really good! Thank you!
Keep watching
Exactly what I was looking for
Keep watching
Good video. I recommend it.
Thank you so much sir, helpful video
Happy to help. Keep watching
What is "less" or "more" in query cost? Is 1 a good value? What is a good range?
This is so helpful! Thank you 😊
Keep watching
@@apexhours I am! 🙂
Very Helpful video
Glad you think so!
Great Content, Thanks guys!!
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
You are correct . You should use map to avoid for loop inside for loop
Can you please post the correct alternative code here! Thanks in advance
@@narenp8471 did you get the answer?
@@apexhours can you please share the alternate code ... Please
Excellent presentation
Glad you liked it
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?
Can you please share the code ?
@@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....
Can post lighting videos
Soon
One cuestion, you have a course complete for developers Salesforce?, thanks i liked this video
Yes. Please check our developer playlist www.apexhours.com/apex-hours-for-students-developer-program/
Cand we query the data definition of table like table name , column name , data type , size , etc
Compared to the previous videos, i am struggling to understand this gentleman.
Sorry about that
@@apexhours thanks, that's ok. I'm listening over a few times to understand
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
Q) 1:09:11 Why did u use String s = 'Acme'; (What is the significance of 'string s' over SOQL in for loop iteration)
Can you please post full code here
Do you have a course complete for admin Salesforce?
check here www.apexhours.com/salesforce-apex-hours-for-students/
T hank you
Glad you like it
excellent
Glad it was helpful! keep watching
When i was trying same Query i am getting unknown parse error and something Aggregate parse error could you help me this error
Can you please share more detail like code and etc
Thank you!!
Glad you liked it
niceee
Thanks
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?
SOSL could have been elaborated more. It was rushed. Rest was explained good.
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.
He has created a custom field for that, you can see it from how the API name of the field ends
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
Sql and soql is same ?
almost same.
Can I be Salesforce engineer after pgdca
32.48 I got some error
what error you got ?
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 😇
Thank you so much for your kind words. Your appreciation is more then money for us.
@@apexhours Understood. Well... in that case, please accept $10000000 worth of my appreciation ❤
sokel sosel
:)
Very boring
Sorry about that. We will try to improve in future. Thanks for your feedback. Keep watching
@@apexhours Don't listen to him. It's a very informative video. Thanks for putting out the content!