I have been following the PKB setup guide to the letter and have verified that my Category Group unique name and Category Root unique name are correct and active. Yet, I am still getting the following error when going to the PKB site. Does anyone have a solution to this issue?
Newbie developer here. I am having a problem trying to solve an issue with too many queries using scheduled APEX. We have the following Account trigger that fires before update:
I am trying to update all Accounts en masse on the 1st of every month using Scheduled APEX, however, my Class will only work for a limited # of Accounts:
Works when I pass one record:
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes']);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{if (account.ID == '0014000000L1CQQ')
{
update account;
}
}
}
}
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes'] limit 1);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{
update account;
}
}
}
Does not work in bulk:
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes']);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{
update account;
}
}
}
I am very green to writing APEX and am hoping that someone might be willing to lend some advice. I have created a trigger that updates a Contact with queried information from Leads and Opportunities:
trigger PartnerPerformance on Contact bulk(before insert, before update){
Contact myContact = trigger.new[0];
public String getL() {
if (l == null) l = 0;
return '' + l;
}
integer l = [SELECT count() FROM Lead WHERE (lead.createddate = LAST_N_DAYS:180) AND (lead.Referring_Contact__c = :myContact.Id) LIMIT 100];
public String getQ() {
if (q == null) q = 0;
return '' + q;
}
integer q = [SELECT count() FROM Opportunity WHERE (opportunity.createddate = LAST_N_DAYS:180) AND (opportunity.Referring_Contact__c = :myContact.Id) LIMIT 1];
public String getC() {
if (c == null) c = 0;
return '' + c;
}
integer c = [SELECT count() FROM Opportunity WHERE (opportunity.closedate = LAST_N_DAYS:180) AND (opportunity.stagename = 'Closed Won') AND (opportunity.Referring_Contact__c = :myContact.Id) LIMIT 100];
if (myContact.Id != null) {
myContact.Referred_Leads__c = l;
myContact.Qualified_Leads__c = q;
myContact.Closed_Won_Opps__c = c;
}
}
The challenge is that my Test Code only covers 40% and disregards all of my Public Strings. Can anyone provide an example of how to test the Public String established in the trigger? Thank you!
I have been following the PKB setup guide to the letter and have verified that my Category Group unique name and Category Root unique name are correct and active. Yet, I am still getting the following error when going to the PKB site. Does anyone have a solution to this issue?
Newbie developer here. I am having a problem trying to solve an issue with too many queries using scheduled APEX. We have the following Account trigger that fires before update:
I am trying to update all Accounts en masse on the 1st of every month using Scheduled APEX, however, my Class will only work for a limited # of Accounts:
Works when I pass one record:
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes']);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{if (account.ID == '0014000000L1CQQ')
{
update account;
}
}
}
}
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes'] limit 1);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{
update account;
}
}
}
Does not work in bulk:
global class RunPartnerPerformance
{
Set<Account> accs = new Set<Account>([select ID from Account where RecordTypeID = '012400000009Xes']);
// Gets a unique list of Account ids
{
for ( Account account : accs )
{
update account;
}
}
}
I am very green to writing APEX and am hoping that someone might be willing to lend some advice. I have created a trigger that updates a Contact with queried information from Leads and Opportunities:
trigger PartnerPerformance on Contact bulk(before insert, before update){
Contact myContact = trigger.new[0];
public String getL() {
if (l == null) l = 0;
return '' + l;
}
integer l = [SELECT count() FROM Lead WHERE (lead.createddate = LAST_N_DAYS:180) AND (lead.Referring_Contact__c = :myContact.Id) LIMIT 100];
public String getQ() {
if (q == null) q = 0;
return '' + q;
}
integer q = [SELECT count() FROM Opportunity WHERE (opportunity.createddate = LAST_N_DAYS:180) AND (opportunity.Referring_Contact__c = :myContact.Id) LIMIT 1];
public String getC() {
if (c == null) c = 0;
return '' + c;
}
integer c = [SELECT count() FROM Opportunity WHERE (opportunity.closedate = LAST_N_DAYS:180) AND (opportunity.stagename = 'Closed Won') AND (opportunity.Referring_Contact__c = :myContact.Id) LIMIT 100];
if (myContact.Id != null) {
myContact.Referred_Leads__c = l;
myContact.Qualified_Leads__c = q;
myContact.Closed_Won_Opps__c = c;
}
}
The challenge is that my Test Code only covers 40% and disregards all of my Public Strings. Can anyone provide an example of how to test the Public String established in the trigger? Thank you!
I have an issue with the Excel Connector. I am trying to import some new leads in to Salesforce and it is failing with the above mentioned error on the Owner ID field. I am putting the full username into the field. ie. Alain Obrien in this example. This is the same format I used when importing contacts and accounts etc and I had no issues.
The bizaar bit is if I use the wizard to extract leads into Excel, it shows the owner ID as I have described above. If I change nothing, and try and use the update option, it fails with the same error. So its failing to update with the data it has just extracted.
I have two fields - one in a standard object and one in a custom object.
When the value for the field in the standard object is populated I would like the corresponding field in the custom object to be updated with the same value. Is there a way to do this?
