You need to sign in to do that
Don't have an account?
Raj01
How to find the contacts which are not related Opportunity, Note, File, Attachment, Task, Event, Activity etc
Hi,
We would like to delete the contacts in production which are not linked to Opportunity, Note, File, Attachment, Task, Event, Activity etc.
Attachment, Notes, Files, Tasks and Event objects are not supporting the semi join inner queries.
Is there anyway i can find the Contacts records which are not used anywhere in salesforce?
We would like to delete the contacts in production which are not linked to Opportunity, Note, File, Attachment, Task, Event, Activity etc.
Attachment, Notes, Files, Tasks and Event objects are not supporting the semi join inner queries.
Is there anyway i can find the Contacts records which are not used anywhere in salesforce?
You can explore this options
This query may helps you to find Contacts:
Select Id, Name from Contact where ID NOT IN (Select ContactId from Opportunity) AND ID NOT IN (Select ContactId from Note) etc;
Regards
Rajesh