You need to sign in to do that
Don't have an account?
geis6
Need help with getting owner profile ID on Case extract
Hi All,
I've been pulling my hair out on this one for the past few hours.
I'm running a CMD line data loader job to extract case data to send to Oracle. I need to be able to extract the Owner Profile ID so that I can filter my results later in SQL.
Right now, my best sample SOQL I have for testing is this:
Select Id, CaseNumber, ContactId, AccountId, OwnerId, Case.Owner.ProfileID FROM Case WHERE CaseNumber = '00836387'
However the return for Case.Owner.ProfileID comes back as a blank field even though it has a value elsewhere.
Am I missing something here.
Cheers,
Ward
I've been pulling my hair out on this one for the past few hours.
I'm running a CMD line data loader job to extract case data to send to Oracle. I need to be able to extract the Owner Profile ID so that I can filter my results later in SQL.
Right now, my best sample SOQL I have for testing is this:
Select Id, CaseNumber, ContactId, AccountId, OwnerId, Case.Owner.ProfileID FROM Case WHERE CaseNumber = '00836387'
However the return for Case.Owner.ProfileID comes back as a blank field even though it has a value elsewhere.
Am I missing something here.
Cheers,
Ward
Cheers,
Ward