SOQL in Salesforce || Salesforce Object Query Language Salesforce || All About SOQL in Salesforce

Want to learn more about salesforce join me at sfdcpanther.com Hi Developers,
Please find the agenda for today session
What is SOQL?
When to use SOQL?
Types of SOQL Query
Live Demo on Different of SOQL Queries.
Aggregate Query
Polymorphic Query
Q & A
#Salesforce #SOQL #SFDCPanther
sfdcpanther.com/
sfdcpanther.wordpress.com/

[@rafaellorenzi8665]

Great video! I just started to work with Salesforce. Thank you very much!!

[@kapilsane]

thank you very much sir

[@SharifD-PaletteAnArtdsb]

Hi..:) Thanks for this video lesson. I am downloading it.

[@tmohan7454]

Thank you so much for sharing this!

[@monteriojackson]

Nice video very informative!

[@mallikarjunas2989]

good job

[@jayagupta8547]

really very thank u.

[@mdjavedansari1855]

Amit sir nice explanation . Can you upload more videos on SOQL related and development(Apex)

[@muzzammilkhan7137]

Good

[@venkychepuri587]

Nice explanation Amit. can you upload more videos on development(Apex)

[@sfdcpanther]

Hey thank you. Yes more development video's are on the way.

[@hishmatrai91]

Very informative amit, thank you so much but your voice is very low or its microphone problem.

[@sfdcpanther]

I think it's microphone problem

[@gmahesh4141]

amit i m facing difficulties in List, Set, map could you plss make a video on that ??????? & make a video on Real time work ...hw v gonna work !!!

[@sfdcpanther]

Hi,
There is already a video on collection and how to use them. The first video in the Back To Basic Playlist

[@raghavendrasharma2466]

Please make video on how to use ant migration tool.

[@sfdcpanther]

Thanks for suggestion. I will try to record the same.

[@jitendralenka9378]

Nice one ..but voice was very slow

[@raghavendrasharma815]

Hi amit, somewhere I saw like (0) or [0] after soql query ex [select name from account](0), could you tell me what does it mean. Thanks

[@sfdcpanther]

Hey,
That means after querying all the records they are returning the record which is on first index that's zero mean. In short to get the top Record from the soql people used to put zero at the end

[@raghavendrasharma815]

@@sfdcpanther u mean for fetch zero index record.

[@raghavendrasharma815]

If I put (3) so it give me forth one record?

[@sfdcpanther]

@@raghavendrasharma815 Yes

[@sfdcpanther]

@@raghavendrasharma815 I did not tried this you can give this a try :)

[@apunkabhai6516]

How we write SOQL for custom object ?

[@avinashnair8433]

As already explained in the video, always fetch with the API name of the custom object.
Let's say you created a custom object called employee and the api name got saved as employee__c.
Then the requisite query will be :-
Select id, name from employee__c.
Here id, name will always be the standard fields for any custom objects.

[@PraveenKumar-be8lh]

When u gonna upload this viddo??

[@sfdcpanther]

It's Uploaded You can watch the complete video

[@nareshkumar-lz5fq]

Voice is low

[@sfdcpanther]

Try to use headphones and volume up 🙂. I will change my device from next time .

[@worldaffairs1193]

Hi SIr, I hope you are doing great
Opportunities have a picklist field for the Year value, such as 2018, 2019, 2020, and 2021.
I want to retrieve the last two years' Opportunity According to the Year__c field,

Integer lastTwoYear = system.today().year() -2;
List opplist =[SELECT Year__c ,Name,CreatedDate, Amount
FROM Opportunity where Year__c >= :lastTwoYear];
It is throwing error
Invalid Integer type bind statement for a String type column
Could you possibly suggest a better way to accomplish this?
Thanks!