Skip to main content

Posts

Showing posts from December, 2017

Deep study on Salesforce count() vs count(fieldName)

Some useful links that related with count : COUNT() and COUNT(fieldName) Aggregate Functions Database.countQuery(query) "Count is used to discover the number of rows that a query returns. " You will notice , there two versions of syntax for COUNT(): count() count(fieldName) I experienced using both but I am not really deep into WHY COUNT() and WHY COUNT(fieldName) until today I did some reading and testing.I found the differences is quite interesting. Difference in Query Editor result : COUNT() No field return.It directly say Total Rows:17 COUNT(fieldName) Total Rows:1 and it returns field which 17. Difference in Apex code : COUNT() Can be assigned to Integer directly. Integer count =[SELECT COUNT() FROM Contact WHERE Account. Name Like ' Test% ' ]; system. debug ( ' count ' + count); COUNT(fieldName) You cannot assigned it to Integer or object, you must assign it to AggregateResult.It will throw error if you try to

Salesforce Certified Platform App Builder

On 4th Dec 2017 Malaysia time, I am officially certified as Salesforce Platform App Builder.Honestly I don't feel it easy due to tricky question. Topic Percentage Correct Security 83% Social 0% Data Modeling and Management 83% Salesforce Fundamentals 80% User Interface 50% Mobile 66% Reporting 66% App Deployment 80% Business Logic and Process Automation 56% Personally I believe working in Salesforce will not be enough if we have no idea how the questions will be asked in exam.Sometimes I get confuse with the sentences and easily fall into the trap.The feeling is like taking Science exam in Malay language and although I am Malay I still need to be careful with keyword and how tricky it could be. Once you plan to sit for exam, I highly advice you to check out how the question being asked.This can be done by check out the Exam Guide, quizes or mock up questions.Be careful on mockup question's answer because it might not 100% accurate.Usually I will read the quest