Xjyuk

If there's something that implicates the president why is there then a national security issue? (John Dowd)

What differences exist between adamantine and adamantite in all editions of D&D?

What would prevent chimeras from reproducing with each other?

How can I remove material from this wood beam?

Is there a DSLR/mirorless camera with minimal options like a classic, simple SLR?

Is it okay to have a sequel start immediately after the end of the first book?

Analogy between an unknown in an argument, and a contradiction in the principle of explosion

How to avoid typing 'git' at the begining of every git command

What is the logic behind charging tax _in the form of money_ for owning property when the property does not produce money?

Did Apple bundle a specific monitor with the Apple II+ for schools?

Why is long-term living in Almost-Earth causing severe health problems?

tabular: caption and align problem

How do free-speech protections in the United States apply in public to corporate misrepresentations?

Is the use of umgeben in the passive unusual?

Why does this query, missing a FROM clause, not error out?

How to write a convincing religious myth?

Is there a set of positive integers of density 1 which contains no infinite arithmetic progression?

How to befriend someone who doesn't like to talk?

I have a problematic assistant manager, but I can't fire him

Why AM-GM inequality showing different results?

Java Servlet & JSP simple login

Fermat's statement about the ancients: How serious was he?

Ability To Change Root User Password (Vulnerability?)

How to prove a 4D vector is a 4-Vector?

How do i export activities related to an account with a specific recordtype?

Can I upsert with the Data Loader using different fields for existing and new records?Help with a report and/or Data Loader Export/QueryData Cleaning: Removing Opportunities from Contact ActivitiesChanging Person Account RecordType to Business Account RecordTypeData export of contacts on AccountData Overage in Old Salesforce OrgData Loader from Command Line - Upsert Opportunity - Indicate Acccount Relationship FieldHow to Extract Notes and Attachments Associated with a Specific ObjectHow can I migrate data and related data from one org to another org?Need help on Dataloader

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I am looking to export Events and Tasks from one org to another for all Account records with a specific recordtype.
Is there a way i can query Tasks and Events which are related to Accounts with a specific recordtype. This would include opportunities as well whose account recordtype will also be of specific recordtype.

Any pointers would be of great help

data-loader polymorphic

share|improve this question

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

add a comment | 

1

I am looking to export Events and Tasks from one org to another for all Account records with a specific recordtype.
Is there a way i can query Tasks and Events which are related to Accounts with a specific recordtype. This would include opportunities as well whose account recordtype will also be of specific recordtype.

Any pointers would be of great help

data-loader polymorphic

share|improve this question

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

add a comment | 

I am looking to export Events and Tasks from one org to another for all Account records with a specific recordtype.
Is there a way i can query Tasks and Events which are related to Accounts with a specific recordtype. This would include opportunities as well whose account recordtype will also be of specific recordtype.

Any pointers would be of great help

data-loader polymorphic

share|improve this question

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

share|improve this question

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

share|improve this question

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

edited 5 hours ago

Ohana

5,068753134

edited 5 hours ago

Ohana

5,068753134

asked 8 hours ago

PradyPrady

6,6532490173

asked 8 hours ago

PradyPrady

6,6532490173

1 Answer
1

active

oldest

votes

5

You're in luck: you don't have to wait until Summer '19 hits your org, bringing with it Polymorphic SOQL, or use a subquery on WhatId, because you can query through the non-polymorphic AccountId relationship on the Task and Event objects:

SELECT Id FROM Task WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

Opportunities don't have any polymorphic relationships, so they're no more than an ordinary relationship query:

SELECT Id FROM Opportunity WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

share|improve this answer

answered 8 hours ago

David Reed♦David Reed

44.2k82564

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Really.. That's so exciting to hear.
  
  – Prady
  8 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "459"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsalesforce.stackexchange.com%2fquestions%2f265227%2fhow-do-i-export-activities-related-to-an-account-with-a-specific-recordtype%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

5

You're in luck: you don't have to wait until Summer '19 hits your org, bringing with it Polymorphic SOQL, or use a subquery on WhatId, because you can query through the non-polymorphic AccountId relationship on the Task and Event objects:

SELECT Id FROM Task WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

Opportunities don't have any polymorphic relationships, so they're no more than an ordinary relationship query:

SELECT Id FROM Opportunity WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

share|improve this answer

answered 8 hours ago

David Reed♦David Reed

44.2k82564

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Really.. That's so exciting to hear.
  
  – Prady
  8 hours ago
  

  
  
  
  

add a comment | 

5

You're in luck: you don't have to wait until Summer '19 hits your org, bringing with it Polymorphic SOQL, or use a subquery on WhatId, because you can query through the non-polymorphic AccountId relationship on the Task and Event objects:

SELECT Id FROM Task WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

Opportunities don't have any polymorphic relationships, so they're no more than an ordinary relationship query:

SELECT Id FROM Opportunity WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

share|improve this answer

answered 8 hours ago

David Reed♦David Reed

44.2k82564

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Really.. That's so exciting to hear.
  
  – Prady
  8 hours ago
  

  
  
  
  

add a comment | 

You're in luck: you don't have to wait until Summer '19 hits your org, bringing with it Polymorphic SOQL, or use a subquery on WhatId, because you can query through the non-polymorphic AccountId relationship on the Task and Event objects:

SELECT Id FROM Task WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

Opportunities don't have any polymorphic relationships, so they're no more than an ordinary relationship query:

SELECT Id FROM Opportunity WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

share|improve this answer

answered 8 hours ago

David Reed♦David Reed

44.2k82564

SELECT Id FROM Task WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

SELECT Id FROM Opportunity WHERE Account.RecordType.DeveloperName = 'My_Record_Type'

share|improve this answer

answered 8 hours ago

David Reed♦David Reed

44.2k82564

answered 8 hours ago

David Reed♦David Reed

44.2k82564

answered 8 hours ago

David Reed♦David Reed

44.2k82564