Recently, in the project that I am working on, we have received this error in our apex code and this error occurs when querying large objects using SOQL (particularly for queries inside triggers). In our case, SOQL is inside the TriggerHandler which is called by the trigger.

Developers receive this error message when a non-selective query in a trigger executes against an object that contains more than 200,000 records. To avoid this error, ensure that the query is selective.

The performance of a SOQL will depend on the presence of a selective filter(in WHERE Clause). If a SOQL query contains at least 1 selective filter, the query is said to be selective. If the SOQL query doesn’t contain a selective filter, the query is said to be un-selective and will require a full table scan.

How to determine if the query is selective?

• A query is selective when one of the query filters is on an indexed field and the query filter reduces the resulting number of rows below a system-defined threshold.
• The selectivity threshold is 10% of the first million records and less than 5% of the records after the first million records, up to a maximum of 333,333 records.

Example:

1. SELECT Id FROM Account WHERE Id IN (<list of account IDs>)

Since the filter is on the ID field which is a standard and Primary Key field, it will have an index created at the DB. If SELECT COUNT() FROM Account WHERE Id IN (<list of account IDs>)returns fewer records than the selectivity threshold, the index on Id is used. This index is typically used when the list of IDs contains only a few records.

2. SELECT Id FROM Account WHERE Name != ”

Since Account is a large object even though Name is indexed (primary key), this filter returns most of the records, making the query non-selective.

3. SELECT Id FROM Account WHERE Name != ” AND CustomField__c = ‘ValueA’
Here we have to see if each filter, when considered individually, is selective. As we saw in the previous example, the first filter isn’t selective. So, let’s focus on the second one. If the count of records returned by SELECT COUNT() FROM Account WHERE CustomField__c = ‘ValueA’ is lower than the selectivity threshold, and CustomField__c is indexed, the query is selective.

For more information:

https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/langCon_apex_SOQL_VLSQ.htm

https://help.salesforce.com/articleView?id=000002493&type=1

Also, there are lot of links in stack exchange which discusses this issue and you can refer them as needed: https://salesforce.stackexchange.com/search?q=Non-selective+query

1 of 5. Which two features best describe the new Lightning-optimized Log a Call
action?
Choose 2 answers
A. Autolink the Call Log to the Case
B. Autolink the Audit Log to the Case
C. Autopopulate the Case Contact
D. Autopopulate the Case Team

Ans: A & C

2 of 5. How can an administrator allow users to choose different views of a
dashboard in Lightning Experience?
A. Dashboard filters
B. Dashboard designer
C. Report filters
D. Report creator

Ans: A

3 of 5. Where are the files and related records attached when a sales user converts a lead?
A. Contact, account, person account, opportunity records
B. Contact, account, opportunity, quote records
C. Contact, account, opportunity records
D. Contact, account, person account records

Ans: A

4 of 5. What action can be taken in Lightning, if you receive an approval request
that someone else should approve?
A. Delete the associated record
B. Change Approval Entry Criteria
C. Edit Approval Process Manager
D. Re-assign the approval request

Ans: D

5 of 5. Which two Chatter Groups will show a seen-by count of people who viewed the post, in the Lightning Experience?

Choose 2 answers
A. Restricted
B. Private
C. Unlisted
D. Public

Ans: B & C

Hi All,

I have cleared my Salesforce Certified Platform App Builder – Transition Exam (SP17) today and here are the tips from my side to clear the exam:

1. Go through the training resources given in “SECTION 4. RECOMMENDED TRAINING AND REFERENCES” in the exam guide available at https://www.google.com.au/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&cad=rja&uact=8&ved=0ahUKEwjjtYTppPnUAhXFx7wKHdhqCMQQFggoMAA&url=http%3A%2F%2Fcertification.salesforce.com%2FSG_CertifiedPlatformAppBuilderTransition.pdf&usg=AFQjCNGl2oWzGI-d9lbhQZlCfiFBZtmGFw
2. Go through the questions given in https://www.proprofs.com/quiz-school/story.php?title=transition-app-builder. You may have doubts in answers for some of the questions, you can post them here and I will give my answer accordingly.
3. Also, go through “Platform App Builder – Full Question Set” as given in http://sfdcstudy.org/platform-app-builder-quizzes/

I got almost 90% of the questions in my exam from the above links, so this would suffice mostly, unless you are not lucky:)

Please let me know for any questions.

Apologies, have been busy with work and personal stuff hence could not write posts for a long time and I am back:)

Suppose you want to copy all the fields in an object and put them on to excel, you can use the following chrome extension:

https://chrome.google.com/webstore/detail/columncopy/lapbbfoohlcmlbdaakldmmallcbcbpjb?hl=en

Example:

Suppose, you want to copy all the custom fields from Order object, you can follow the below steps to do so:

1. Go to Setup -> Orders -> Fields
2. Navigate to see Order Custom Fields & Relationships section
3. Right click and select Copy entire table from ColumnCopy option. It will highlight the table that is getting copied, once you select this option.

4. Then open excel and paste

Hope this tip will be useful!

P.S: you have an option to only the column too by selecting Copy this column option.