• dchealthcare
  • NEWBIE
  • 0 Points
  • Member since 2013

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

When we try to run a  simple  ‘join’ query  (below) we can only see the columns from the driving table  ( In this case Account History Child table is the driving table)  however the columns from Parent tables appears as a Link  (in this case Account).

 

We  understand that the clicking on the link gives  the selected columns of  the Parent table as a pop up but  we want  every selected column from both Tables on the display  (Just like  the Query editor does)  and export the entire  result  set to a  CSV file. The only  reason we started using ‘Force explorer’  is because  ‘Query Editor’  doesn’t  allow bulk export.  ‘Data Loader’  also does export but it doesn’t allow Joins.

 

Can you help  if there is a quick fix or way out for this ?

 

/*******************************

SELECT Account.ID,Account.FirstName ,Account.LastName

      ,Account.PersonBirthDate ,Account.Phone ,Account.CreatedDate

      ,Account.LastModifiedDate ,Account.LastModifiedByID

      ,AccountHistory.AccountID, AccountHistory.ID

      ,AccountHistory.Field ,AccountHistory.NewValue

      ,AccountHistory.OldValue ,AccountHistory.CreatedDate

      ,AccountHistory.CreatedById ,AccountHistory.Isdeleted

FROM  AccountHistory

WHERE Account.LastModifiedDate > 2013-10-08T00:00:00Z

  and AccountHistory.Field = 'Phone' order by Account.ID

*****************************/

When we try to run a  simple  ‘join’ query  (below) we can only see the columns from the driving table  ( In this case Account History Child table is the driving table)  however the columns from Parent tables appears as a Link  (in this case Account).

 

We  understand that the clicking on the link gives  the selected columns of  the Parent table as a pop up but  we want  every selected column from both Tables on the display  (Just like  the Query editor does)  and export the entire  result  set to a  CSV file. The only  reason we started using ‘Force explorer’  is because  ‘Query Editor’  doesn’t  allow bulk export.  ‘Data Loader’  also does export but it doesn’t allow Joins.

 

Can you help  if there is a quick fix or way out for this ?

 

/*******************************

SELECT Account.ID,Account.FirstName ,Account.LastName

      ,Account.PersonBirthDate ,Account.Phone ,Account.CreatedDate

      ,Account.LastModifiedDate ,Account.LastModifiedByID

      ,AccountHistory.AccountID, AccountHistory.ID

      ,AccountHistory.Field ,AccountHistory.NewValue

      ,AccountHistory.OldValue ,AccountHistory.CreatedDate

      ,AccountHistory.CreatedById ,AccountHistory.Isdeleted

FROM  AccountHistory

WHERE Account.LastModifiedDate > 2013-10-08T00:00:00Z

  and AccountHistory.Field = 'Phone' order by Account.ID

*****************************/