• Grantley
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

I'm using the Office Toolkit interface to submit a SOQL query like this:

 

strQuery = string.Format(

    "SELECT Id, Owner.Extension, LastActivityDate, CreatedDate FROM Contact WHERE "+

    "Phone LIKE \'{0}\' OR OtherPhone LIKE \'{0}\' OR MobilePhone LIKE \'{0}\'", strNumber);

 

QueryResultSet4 result = SFSession.Query(strQuery, false);

 

It works fine, finds the expected record and I can access the Id, LastActivityDate adn the CreatedDate field values by enumerating the fields collection of the QueryResultSet4.  What I can't figure out is how to extract the presumably returned Owner.Extension field.  I think that part of the query is working as if I change it then the query fails.  I just can't figure out how I'm supposed to get at the data for the field...???

 

Thanks!