function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
geis6geis6 

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
GanuGanu
try this,
 
Select Id, CaseNumber, ContactId, AccountId, OwnerId, Owner.ProfileID FROM Case WHERE CaseNumber = '00836387'
 
-- Ganu
geis6geis6
Thanks for the advice Ganu, however, I'm still not getting a value returned in my extract.

Cheers,
Ward