Query for Tasks, Notes, and Events by Object Type #inSalesforce

on

Query for Tasks, Notes, and Events by Object Type #inSalesforce


SELECT Id, Who.Id, Who.Type FROM Task WHERE Who.Type = 'Lead'

SELECT Id, Parent.Id, Parent.Type FROM Note WHERE Parent.Type = 'Opportunity'

SELECT Id, Subject, What.Type, WhatId FROM Event WHERE What.Type IN ('Account', 'Opportunity')

Comments

Post a Comment