Great video! Just a quick comment in reference to something you said at 45:35 in the video. In fact, the ORDER BY clause _will_ order the records by a field that is _not_ selected. For instance, the following SOQL query will organize the returned rows by last name even though LastName is not part of the SELECT clause: *SELECT Id, Name FROM Contact ORDER BY LastName*
Another helpful SOQL function is FORMAT(). If you wrap a currency, number, or date,/time field with it, it will make those fields more reader-friendly. For instance, it will add the currency denomination ($) and delimiters (eg, 45000000 >>> $45,000,000): *SELECT Id, Name, FORMAT(Amount) FROM Opportunity*. You can also use it with aggregate queries: *SELECT FORMAT(MAX(Amount)) FROM Opportunity*.
Lol, well I write it all out ahead of time (the outline of the video, not the exact words I say) and then I actually typically record these long videos over multiple days, I just edit it all together and make sure I use the same shirt when I record lol, that way it all seems more seamless to the viewers.
Hello you are great and your lessons great too thank you for all of the hardwork.Even when my query is correct, it's underlined in red, and it's driving me crazy. What can we do about this issue? I bought Intellij with your advice. But I guess the system there is not the same as in the developer console. I can't reach some of the things that I can reach in developer consel, I guess because I don't know how to use intejij.
Thank you for this great video. One comment about lookup SOQL query from parent to child. If its custom object then Child Relationship Name which is available in UI , has to be appended with __r when you query, right?
One thing I was hoping to see but didn't: how to work with the outputs of sub queries returning more than one object in apex. You showed how a regular query or one that uses parent fields can be put right into a list, but I didn't see anything about the more complex types of results in apex.
They are in the comments in all my videos, but my favorite for beginners will always be Advanced Apex by Dan Appleman. It is an excellent book and really helped me get started out on the right foot many years ago.
Great video! Just a quick comment in reference to something you said at 45:35 in the video. In fact, the ORDER BY clause _will_ order the records by a field that is _not_ selected. For instance, the following SOQL query will organize the returned rows by last name even though LastName is not part of the SELECT clause: *SELECT Id, Name FROM Contact ORDER BY LastName*
Another helpful SOQL function is FORMAT(). If you wrap a currency, number, or date,/time field with it, it will make those fields more reader-friendly. For instance, it will add the currency denomination ($) and delimiters (eg, 45000000 >>> $45,000,000): *SELECT Id, Name, FORMAT(Amount) FROM Opportunity*. You can also use it with aggregate queries: *SELECT FORMAT(MAX(Amount)) FROM Opportunity*.
Cool video, thank you for explaining the difference between SAQL and SOQL.
Excellent content, i loved it. Thank you! please do cover more on LWC stuff!
Thank you this is helpful !
Great content. Would love to learn more about the Async queries :).
Thanks for providing this! Incredibly helpful content. Also, you kind of sound like Michael J Fox in Back to the Future.
Thanks, it's impressive that you can maintain for so long. I had to digest it in three sessions!
Lol, well I write it all out ahead of time (the outline of the video, not the exact words I say) and then I actually typically record these long videos over multiple days, I just edit it all together and make sure I use the same shirt when I record lol, that way it all seems more seamless to the viewers.
Thanks.. It is really a reference tutorial. ::: + :)
Hello you are great and your lessons great too thank you for all of the hardwork.Even when my query is correct, it's underlined in red, and it's driving me crazy. What can we do about this issue? I bought Intellij with your advice. But I guess the system there is not the same as in the developer console. I can't reach some of the things that I can reach in developer consel, I guess because I don't know how to use intejij.
Thank you for this great video. One comment about lookup SOQL query from parent to child. If its custom object then Child Relationship Name which is available in UI , has to be appended with __r when you query, right?
One thing I was hoping to see but didn't: how to work with the outputs of sub queries returning more than one object in apex. You showed how a regular query or one that uses parent fields can be put right into a list, but I didn't see anything about the more complex types of results in apex.
Edit: I do see the SOSL List part now not sure how I missed that before. Cool!
please guide me best salesforce text in amazon
They are in the comments in all my videos, but my favorite for beginners will always be Advanced Apex by Dan Appleman. It is an excellent book and really helped me get started out on the right foot many years ago.