So I've created an controller extension and have added a visualforce page to my account layout. It all works fine and dandy except for a few accounts I get this error: "Content cannot be displayed: INVALID_TYPE_FOR_OPERATION: entity type ActivityHistory does not support query". I believe it has to do with the fact that the accounts that seem to error have a large amount of activity history. However, when I add a LIMIT to the controller extension it still errors. How do we fix this?
Apex Class:
public class AccountSalesActH {
private final Account acct;
public AccountSalesActH(ApexPages.StandardController stdController) {
this.acct = (Account)stdController.getRecord();
}
public String getName() {
return 'AccountSalesActH';
}
public Account getAccount() {
Account[] acct = [select id, name, ownerid,
(select subject, whatid, whoid, activitydate, LVM__c, ownerid, lastmodifieddate from ActivityHistories
where ownerid not in ('00530000000vpI1') order by activitydate DESC ) //filter out marketing actvities
from Account
where id = :ApexPages.currentPage().getParameters().get('id')]; if (acct.size()>0) {return acct[0];} else {return null;
}
}}
public class LeadSalesActH {
private final Lead ld;
public LeadSalesActH(ApexPages.StandardController stdController) {
this.ld = (Lead)stdController.getRecord();
}
public String getName() {
return 'LeadSalesActH';
}
public Lead getLead() {
return [select id, name, ownerid,
(select subject, whatid, whoid, activitydate, LVM__c, ownerid, lastmodifieddate from ActivityHistories
where ownerid not in ('00530000000vpI1') order by activitydate DESC ) //filter out marketing actvities
from Lead
where id = :ApexPages.currentPage().getParameters().get('id')];
}
}
I started on my test class but I'm getting stuck on the getLead() tests. Can someone put me in the right direction?
Test Class:
@isTest
private class ExtendObjectTest {
static testmethod void constructorTest() {
// set up some test data to work with
Lead ld = new Lead(LastName='Test', Company='Test1', Status='New');
insert ld;
// start the test execution context
Test.startTest();
// set the test's page to your VF page (or pass in a PageReference)
Test.setCurrentPage(Page.leadsales);
// call the constructor
LeadSalesActH controller = new LeadSalesActH(new ApexPages.StandardController(ld));
// stop the test
Test.stopTest();
}
}
I'm creating a trigger to create a campaign member to a specific campaign. However, my edition of Salesforce only includes 1 Developer Sandbox and thus does not have the campaign needed for the trigger (no production data). What is the best way to create the trigger given this limitation? Is there a way to do it the Force.com IDE?
public class LeadSalesActH {
private final Lead ld;
public LeadSalesActH(ApexPages.StandardController stdController) {
this.ld = (Lead)stdController.getRecord();
}
public String getName() {
return 'LeadSalesActH';
}
public Lead getLead() {
return [select id, name, ownerid,
(select subject, whatid, whoid, activitydate, LVM__c, ownerid, lastmodifieddate from ActivityHistories
where ownerid not in ('00530000000vpI1') order by activitydate DESC ) //filter out marketing actvities
from Lead
where id = :ApexPages.currentPage().getParameters().get('id')];
}
}
I started on my test class but I'm getting stuck on the getLead() tests. Can someone put me in the right direction?
Test Class:
@isTest
private class ExtendObjectTest {
static testmethod void constructorTest() {
// set up some test data to work with
Lead ld = new Lead(LastName='Test', Company='Test1', Status='New');
insert ld;
// start the test execution context
Test.startTest();
// set the test's page to your VF page (or pass in a PageReference)
Test.setCurrentPage(Page.leadsales);
// call the constructor
LeadSalesActH controller = new LeadSalesActH(new ApexPages.StandardController(ld));
// stop the test
Test.stopTest();
}
}
