• ian elrick
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hi
I have successfully got a rest call working with bbbbasic fields from the opportunity table as follows:

SELECT Opportunity.Name, OrderNumber__c,Account.Name, Type,StageName, Description,CloseDate from Opportunity where IsClosed = False order by CloseDate ASC LIMIT 100

I want to add other fields to this such as "Created  By" but these are lookups on the User table and including the CreatedById field gives the id as opposed to the meaningfull date. 
Any idea how to do this?

Thanks in advance.