Useful SOQL Queries

Useful SOQL Queries

//Get Cases followed by User 
SELECT Id, CaseNumber, Subject, Owner.Name, Status, CreatedDate, ClosedDate 
FROM Case 
WHERE Id IN (SELECT ParentId FROM EntitySubscription WHERE SubscriberId = '')
ORDER BY CreatedDate

//Get User Signatures by Profile
SELECT id, FirstName, LastName, email, FederationIdentifier, LastLoginDate, Profile.Name, UserRole.Name, Signature
FROM user
where IsActive = true
and Profile.Name = ''
order by LastLoginDate desc