Basic of SOQL and SOSL in Salesforce | SOQL Crash Course | DAY 4 Part 1
Vložit
- čas přidán 21. 07. 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/
Great Content, Thanks guys!!
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 🥇
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.
Some of these videos have good breakdowns of what's essential. Useful.
Glad it was helpful!
What is "less" or "more" in query cost? Is 1 a good value? What is a good range?
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
Cand we query the data definition of table like table name , column name , data type , size , etc
Exactly what I was looking for
Keep watching
Thank you so much sir, helpful video
Happy to help. Keep watching
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.
Excellent presentation
Glad you liked it
Excelente. Gracias.
Thanks
Good video. I recommend it.
Very Helpful video
Glad you think so!
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?
Thank you!!
Glad you liked it
This is so helpful! Thank you 😊
Keep watching
@@apexhours I am! 🙂
excellent
Glad it was helpful! keep watching
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
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
This is really good! Thank you!
Keep watching
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/
Excellent teaching sir👌👌👌
Also could u pls make session on copado tutorials?
Will try
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....
niceee
Thanks
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
SOSL could have been elaborated more. It was rushed. Rest was explained good.
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
Can post lighting videos
Soon
32.48 I got some error
what error you got ?
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
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
Sql and soql is same ?
almost same.
Can I be Salesforce engineer after pgdca
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!