I have a huge problem with the Social Media Managed Package becuase it throw the following error when try to save the Conversations.
Update failed. First exception on row 0 with id a08j0000003lXX0AAM; first error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY, sf4twitter.TwitterConversationTrigger: execution of BeforeUpdate caused by: System.QueryException: Non-selective query against large object type (more than 100000 rows). Consider an indexed filter or contactsalesforce.com about custom indexing. Even if a field is indexed a filter might still not be selective when: 1. The filter value includes null (for instance binding with a list that contains null) 2. Data skew exists whereby the number of matching rows is very large (for instance, filtering for a particular foreign key value that occurs many times) Class.sf4twitter.TwitterPersonAccountManager.getContactFromPersonAccountsByUserName: line 31, column 1 Trigger.sf4twitter.TwitterConversationTrigger: line 148, column 1: 
I suspect that it could be resolved setting an "External Id" on the usernames fields of Contact object.
I opened a case for this but they can not resolve it yet!
Is there a workaround for resolve this?
SFDX - This org does not have the appropriate permissions to use the 'ContentHubSharepointOffice365' data provider
I wanted to push External Object with Auth Providers to my scratch org. It's a Files Connect connection to SharePoint Online. The SFDX CLI returns error:
This org does not have the appropriate permissions to use the 'ContentHubSharepointOffice365' data provider
Is it possible for a scratch org to have this sort of permissions? If yes, how can I set them up?
How to write Test class for ProcessInstanceWorkItem ?
Currently we are firing query to ProcessInstanceWorkItem table to get the workitem Id and updating those records to Approve or Reject as per requirements.
Since we are not able to insert ProcessInstanceWorkItem records Also, In test class, I submiited record for an approval but in next line when I query to ProcessInstanceWorkItem for the same targetObjectId then also I am receiving 0 records.
Please help me in this to resolve this asap.
Is there any way to add an error to an record being updated in a trigger and send an email. The trigger needs to send an email (one per batch). The email works fine if the processing generates no errors and I do not use the addError method. If I use the addError method to pass a message back to the user then the email is not sent.
So is there a way to send an email and use addError in the same trigger code? If not is there another mechanism that can be used to pass a message back to the user interface (standard salesforce UI).