Basic of SOQL and SOSL in Salesforce | SOQL Crash Course | DAY 4 Part 1
ฝัง
- เผยแพร่เมื่อ 3 ส.ค. 2024
- Basic of Salesforce Object Query Language and SOSL in Salesforce, What is SOQL, Basics of SOQL, Relationship Queries, SOQL in Apex, Querying Records in Batches by Using SOQL for Loops, Introduction to SOSL, Using the right tool for the job SOQL Vs SOSL, Writing optimal queries - Query Plan
Salesforce Object Query Language (SOQL) full Course
Check blog post for PPT and assignment. www.apexhours.com/soql-sosl-dm...
0:00 Introduction
4:15 What is SOQL
8:13 Basic of SOQL Syntax
12:30 First SOQL Query
17:14 WHERE clause in SOQL
18:00 Order By in SOQL
19:14 Limit in SOQL
22:01 Conditional Expression
26:10 Like Operators
31:43 IN Operators
33:52 Not IN
35:10 AND Operator in SOQL
38:45 Aggregate Queries
47:33 Group By and Having Clauses
49:46 Relationship Queries Child to parent
54:10 Parent to Child Relationship SOQL queries
1:00:21 Writing SOQL in Apex
1:11:02 Introduction to SOSL
1:15:11 Writing optimal queries - Query Plan
#soql #salesforcetutorial #soqltutorial
#SOQL #SOSL #QueryPlan #AggregateQueries #Having #GROUPBY #RelationshipQueries
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!
Great Content, Thanks guys!!
Exactly what I was looking for
Keep watching
Thank you so much sir, helpful video
Happy to help. Keep watching
Good video. I recommend it.
Excellent presentation
Glad you liked it
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.
Thank you!!
Glad you liked it
This is really good! Thank you!
Keep watching
This is so helpful! Thank you 😊
Keep watching
@@apexhours I am! 🙂
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.
Very Helpful video
Glad you think so!
Excelente. Gracias.
Thanks
Excellent teaching sir👌👌👌
Also could u pls make session on copado tutorials?
Will try
excellent
Glad it was helpful! keep watching
What is "less" or "more" in query cost? Is 1 a good value? What is a good range?
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/
niceee
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?
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....
Cand we query the data definition of table like table name , column name , data type , size , etc
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
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
T hank you
Glad you like it
Can post lighting videos
Soon
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
Do you have a course complete for admin Salesforce?
check here www.apexhours.com/salesforce-apex-hours-for-students/
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
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
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
SOSL could have been elaborated more. It was rushed. Rest was explained good.
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?
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 ❤
32.48 I got some error
what error you got ?
Sql and soql is same ?
almost same.
Can I be Salesforce engineer after pgdca
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!