I get this error in every test class :

System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Required Field: []

The error comes at every  "Insert " function 



 

sp.actionItems = [
            SELECT Customer_Objective__r.Objective_Name__c, Priority__c, Due_Date__c, Subject__c, Assigned_To__r.Name, Status__c
            FROM Action_Item__c
            WHERE
                Success_Plan__c = :successPlanId
                AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SET
                AND Internal_External__c = :SUC_Constants.ACTION_ITEM_INT_EXT_EXT
            ORDER BY Customer_Objective__r.Objective_Name__c
        ];

How to write That Status__c not equal Closed.

Consider the following transaction:

AggregateResult[] x = 
[SELECT SellToCust__r.Id,  SUM(InvAmount__c) 
FROM Invoice__c 
WHERE InvDate__c >= 2023-01-01 AND InvDate__c <= 2023-08-31 
GROUP BY SellToCust__r.Id
HAVING SUM(InvAmount__c) >= 2000];

where SellToCust__c is the field that relates an invoice__c (child) to the corresponding Account.

If I try this in an anon block of code I run against the 50,000 row limit. Batch Apex cannot handle results from such SOQL queries. If I try, for example, to simplify the query and then do the grouping etc. myself in Batchable execute() and finish() methods, I run into the heap size issue.

How would you approach this issue?
I am a novice developer and I find that I spend as much time writing logic as looking for ways to work around governor limits. Anyone else?

Hi all,

I would like to display an external page inside SalesForce using a lightning component.  I would like to be able to authenticate SalesForce users to the external website page.


How do I do this? Do you have any example ?

Hi,

I have created this component :

<lightning:recordEditForm aura:id="edit" recordId="{!v.recordId}" 
                          objectApiName="Account" 
                          > 
    <lightning:inputField fieldName="Sales_DT__c" variant="label-hidden"/>
</lightning:recordEditForm>

Where Sales_DT__c is a lookup on User.
This field Sales_DT__c  has a value recorded : 00530000004FGcfAAG.

Before, it's was working with this old workaround : add lightning:recordViewForm in the same compoent, but it's doesn't work anymore :

<lightning:recordViewForm recordId="{!v.recordId}" 
                              objectApiName="Account" >
        <div class="slds-hidden">
            <lightning:outputField fieldName="Sales_DT__c" />
        </div>
    </lightning:recordViewForm>

I have already read this : https://developer.salesforce.com/forums#!/feedtype=SINGLE_QUESTION_SEARCH_RESULT&id=9060G0000005qTaQAI

But, I didn't found a good response.

Any idea on how to populating this lookup field when I load the component ?
 

Hi,

After saving on my lightning component, I'm trying to go back to my record page with the good slide enabled.

I have a custom tab : 'configurateur' . 

I have tryed this :

var sObectEvent = $A.get("e.force:navigateToSObject");
sObectEvent.setParams({
     recordId: component.get("v.recordId"),
     slideDevName: 'configurateur'
});
sObectEvent.fire();

I'm going back to my record page but i'm landing in the default slide.

Is there a way to go back on my custom slide (tab) 'configurateur' ?

Thanks for your help
 

I have a very strange error.
I have developped a component with lightning:dualListbox.
I have a button 'enregistrer' in controller to save this ordered list (Call when I hit button Save)

But sometimes "enregistrer" return null after the call back on :
actionEnregistrer.setCallback(this, function(actionResult) {
...
if(actionResult.getReturnValue()==null){
service.showWarningToast('Le composant APEX ne répond pas, impossible de sauvegarder !');
}

The strange things is, if i open developper console in another tab, and go back to my component, it's working !
Very strange, isn't it ?

Well do you have an idea where this bug come from ?

Component is :

<lightning:dualListbox name="multipleOptions"  
                                       sourceLabel="Corbeille" 
                                       selectedLabel="Affiché" 
                                       options="{!v.listOptions}" 
                                       value="{!v.selectedOptions}"
                                       />


<lightning:button variant="brand" 
                                      iconName="utility:save" 
                                      label="Enregistrer"
                                      title="Enregistrer"
                                      onclick="{! c.enregistrer }"/>

Controller is :

enregistrer: function(component, event, helper) {
        let service = component.find('service');
        var selectedOptionValue = component.get("v.selectedOptions");//component.get("v.selectedArray");
        var typeObj = component.get("v.typeObj");
        if(selectedOptionValue!=null && typeObj!=null){
            console.log("Option selected with value: '" + selectedOptionValue.toString() + "'");
            var actionEnregistrer = component.get("c.doSaveOrder");
            actionEnregistrer.setParams({
                tabOrderedLine : selectedOptionValue,
                typeObj :typeObj
            });
            //Setting the Callback
            actionEnregistrer.setCallback(this, function(actionResult) {
                console.log('enregistrer:setCallback');
                console.log('actionResult:'+actionResult.getReturnValue());
                if(actionResult.getReturnValue()==null){
                    service.showWarningToast('Le composant APEX ne répond pas, impossible de sauvegarder !');
                }
                else{
                    var result=actionResult.getReturnValue()[0];
                    console.log('result:'+result);
                    var resultMessage=actionResult.getReturnValue()[1];
                    console.log('resultMessage:'+resultMessage);
                    //check if result is successfull
                    if(result=='0'){
                        console.log('avant showSuccessToast');
                        service.showSuccessToast(resultMessage);
                        console.log('apres showSuccessToast');
                        helper.clickBackToConfig(component, event);
                    } else{
                        service.showWarningToast('Erreur :'+resultMessage);
                    }
                }
            });
            //adds the server-side action to the queue        
            $A.enqueueAction(actionEnregistrer);
        }
        else{
            if(selectedOptionValue==null) service.showWarningToast('Impossible de charger la selection');
            else service.showWarningToast('Le type d\'objet n\'a pas été chargé :'+typeObj);
        }
    },

APEX is:

//Sauver l'odre des options 
    @AuraEnabled
    public static List<String> doSaveOrder(List<String> tabOrderedLine, String typeObj) {
        List<id> lIdSelected = new List<id>();
        List<String> ReturnString=new List<String>();
        List<score_setting_field_mapping__c> sco_field_map_toUpdate = new List<score_setting_field_mapping__c>();
        if(tabOrderedLine.size()>0){
            String debug = '';
            score_setting_field_mapping__c[] sco_field_map;
            //Perform Operation with records (cutted)
            update sco_field_map_toUpdate;
            ReturnString.add('0');
            ReturnString.add('Sauvegarde effectuée !');
            
        }
        else{
            ReturnString.add('1');
            ReturnString.add('Vous devez modifier l\'odre d\'au moins une ligne');
        } 
        return ReturnString;
    }

​​​​​​​

Hi,

I have used a lightning:datatable and I want to format number in a column.

Today, i  my controller, I use :
{label: 'My number', fieldName: 'my_number', type: 'currency',sortable : true
},

My result is :
123,00 €

And I want to have :
123 €
=> No digit allowed after the commat.

Is there a way to do that ?

Thanks for your help,
Julien

Hi,

I'm using a lightning:datatable in a lightning component.
My controller set a column using currency :
{label: 'My label for currency', fieldName: 'my_currency_number', 
             type: 'currency',sortable : true,
             cellAttributes: { class: { fieldName: 'showClass'}}
            },
            
Today, my problem is :
I have this result : 234,00 €

And I would like to remove digits, and I would like to have this result :
234 €

How can I do that?

Thanks for your help,
Julien

Hello,

I'm creating a new salesforce package. 
I want my final user be able to configure it.
So I want to give them access to a custom page where they will be able to change setting.

My question is, where do I save this settings ? I want this setting be writable trought a visulaforce page or a lightning component.

Thanks for your help.

Hi,

Something strange happend..
 have developp an apex and a test class in Summer 2018.
Eveything was fine. Today, my class are working in production.

But today, I have re-run the test, and I have got 
"SObject row was retrieved via SOQL without querying the requested field".

But the field is in the apex class, in SOQL and test class too.

Does something happend in the last 2 release ?

Hi,

I'm using lightning:inputField, but I want only the input field, nothing else.
I have hidde the label, but I automaticaly get the helptext near the field.
And I don't want it in my component.

My code is :
<lightning:inputField fieldName="myCustomField__c" variant="label-hidden" "/>

Any Idea ?
 

I get this error in every test class :

System.DmlException: Insert failed. First exception on row 0; first error: FIELD_CUSTOM_VALIDATION_EXCEPTION, Required Field: []

The error comes at every  "Insert " function 



 

Group_or_Party_Payout__c objGroupPayout = new Group_or_Party_Payout__c(
                        Rebate_Program__c = strPGID,
                        Rebate_Program_Payout_Period__c = strPeriodID,
                        Account__c = strAccountId,
                        Calculation_Date__c = date.today(),
                        Gross_Dollar_Rebates__c = (Decimal)mapDetail.get(GROSS_DOLLAR) == null ? 0 : (Decimal)mapDetail.get(GROSS_DOLLAR),
                        Gross_Per_Pound_Rebates__c = (Decimal)mapDetail.get(GROSS_PER_POUND) == null ? 0 : (Decimal)mapDetail.get(GROSS_PER_POUND),
                        Calculated_Rebate_Amount__c = ((Decimal)mapDetail.get(GROSS_DOLLAR) == null ? 0 : (Decimal)mapDetail.get(GROSS_DOLLAR)) + ((Decimal)mapDetail.get(GROSS_PER_POUND) == null ? 0 : (Decimal)mapDetail.get(GROSS_PER_POUND)),
                        Rebate_23100__c = decRebate23100,
                        Commission_23190_Tax__c = decCommission23100,
                        Advertising_23120__c = decAdvertising,
                        Total_Approved_Adjustment_Amount__c = (Decimal)mapDetail.get(ADJUSTMENT) == null ? 0 : (Decimal)mapDetail.get(ADJUSTMENT),
                        Name = strPGName + '-' + strPeriodName,
                        Due_Date__c = date.today(),
                        External_ID__c = strPGID + '-' + strPeriodID + '-' + strAccountId,
                        Delinquent_Accounts__c = (String)mapDetail.get(DELINQUENT),
                        Org_ID2__c = (String)mapDetail.get(ORG_ID),
                        Invoice_Description__c = strInvoiceDesc,
                        Cash_Discount2__c = decCashDisc,
                        Fuel_Surcharge__c = decFuelSur,
                        Status__c = 'Draft'
                    ); 
                    lstGroupPayout.add(objGroupPayout);
                }
            }
            
            system.debug('List of group or part payouts =>' + lstGroupPayout); // List of group or party payout.

            Integer intSuccessCount = 0;
            Integer intFailureCount = 0;
            String strFailureInfo = '';
            Schema.SObjectField externalId = Group_or_Party_Payout__c.Fields.External_ID__c;
            Database.UpsertResult[] srList = Database.upsert(lstGroupPayout, externalId, false);

I just want the due date to be set at as when the record is created and not update everyday

(This is a batch class that runs everynight)

We have an Apex method calling out a REST API Get method, which suddently started responding with binary data instead of JSON. We have not made any changes to the code in the REST API, and using tools like Postman, browser request or JS-fetch returns the appropriate JSON response.
Has anyone experience an issue like this? Other REST APIs do not have the same issue, but our prod, sandbox and scratch orgs all return the same corrupted response.
Here is a sample of the basic call we have in Apex:

@AuraEnabled
  public static String getEventById(String eventId) {
    Http http = new Http();
    HttpRequest request = new HttpRequest();
    request.setEndpoint('https://RESTURI/' + eventId);
    request.setMethod('GET');
    request.setHeader('Content-Type', 'application/json');
    HttpResponse response = http.send(request);
    // Parse the JSON response
    if (response.getStatusCode() != 200) {
      System.debug('The status code returned was not expected: ' + response.getStatusCode() + ' ' + response.getStatus());
      return null;
    }
    return response.getBody();
  }

We are getting a status code 200, but the body of the response is just a lot of random binary data.

Hi Everyone,

I stuck with this error now give me some solution.

ERROR 
System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, field integrity exception: []

Thank you for Help 

This code 
@isTest
public class UpdateOpportunityToTotalValueTest {
    @isTest
    static void testInsertOpportunityLineItems() {
       
        Pricebook2 priceBook = new Pricebook2(Name = 'Test Pricebook');
        insert priceBook;
       
        Pricebook2 standardPB = [SELECT Id FROM Pricebook2 WHERE isStandard=true LIMIT 1];
       
        Product2 product1 = new Product2(
            Name = 'Product1',
            ProductCode = 'P1',
            Description = 'Product Test 1'
        );
        Product2 product2 = new Product2(
            Name = 'Product2',
            ProductCode = 'P2',
            Description = 'Product Test 2'
        );
        insert product1;
        insert product2;
        PricebookEntry standardPrice = new PricebookEntry(
             Pricebook2Id = standardPB.Id,
             Product2Id = product1.Id,
             UnitPrice = 10000,
             IsActive = true,
             UseStandardPrice = true          
        );
        insert standardPrice;
        PricebookEntry priceCustom1 = new PricebookEntry(
            Pricebook2Id = priceBook.Id,
            Product2Id = product1.Id,
            UnitPrice = 100.00,
            UseStandardPrice = false,
            IsActive = true
        );
        insert priceCustom1;
       
        PricebookEntry priceCustom2 = new PricebookEntry(
            Pricebook2Id = priceBook.Id,
            Product2Id = product2.Id,
            UnitPrice = 50.00,
            UseStandardPrice = false,
            IsActive = true
        );
       
        insert priceCustom2;
       
        Opportunity testOpportunity = new Opportunity(
            Name = 'Test Opportunity',
            StageName = 'Closed Won',
            CloseDate = Date.today(),
            TotalValue__c = 0,
            Pricebook2Id = priceBook.Id
        );
        insert testOpportunity;
       
        OpportunityLineItem oline1 = new OpportunityLineItem(
            OpportunityId = testOpportunity.Id,
            PricebookEntryId = priceCustom1.Id,
            Quantity = 2
        );
        OpportunityLineItem oline2 = new OpportunityLineItem(
            OpportunityId = testOpportunity.Id,
            PricebookEntryId = priceCustom2.Id,
            Quantity = 1
        );
        List<OpportunityLineItem> oppLineToUpdate = new List<OpportunityLineItem>{oline1, oline2};
        insert oppLineToUpdate;
        testOpportunity = [SELECT TotalValue__c FROM Opportunity WHERE Id = :testOpportunity.Id];
        System.assertEquals(250.00, testOpportunity.TotalValue__c);
    }
}
 

sp.actionItems = [
            SELECT Customer_Objective__r.Objective_Name__c, Priority__c, Due_Date__c, Subject__c, Assigned_To__r.Name, Status__c
            FROM Action_Item__c
            WHERE
                Success_Plan__c = :successPlanId
                AND Status__c IN :SUC_Constants.ACTION_ITEM_STATUS_SET
                AND Internal_External__c = :SUC_Constants.ACTION_ITEM_INT_EXT_EXT
            ORDER BY Customer_Objective__r.Objective_Name__c
        ];

How to write That Status__c not equal Closed.

HI Team, 

I have one task updatevthe contacts related to account. I have wrote the apex code but getting error , please check and let me know where I'm making mistake. 

Apex code :

public class updateRelatedAcc {
    public static  void accUpdate (List<Account> accList){
        Set<Id> getUpdateAcc = new Set<Id>();
        for(Account a: accList) {
            getUpdateAcc.add(a.Id);
            
        }
        
        List<Contact> con = [Select Id, Name,AccountId, MailingCity from Contact Where AccountId =: getUpdateAcc];
        List<Contact> updateContacts = new List<Contact>();
        for(Contact c :con) {
            c.MailingCity = a.BillingCity;
            updateContacts.add(c);
        }
        update updateContacts;
        

    }

}

Error Screenshot :

Hi Team , i need help in fixing this test class

Wrapper Class:

public class AccountWrapper {
    public List<accRecords> AccountList;
  public  class accRecords {
    public String AccId;  
    public String NextVal;  
  }
  public static AccountWrapper parse(String json){
    return (AccountWrapper) System.JSON.deserialize(json, AccountWrapper.class);
  }

}

My Apex Snippet:

 Map<Id,String> accMap = new Map<Id,String>();
RestRequest req = RestContext.request;
RestResponse res = RestContext.response;
String bodyJson = req.requestBody.toString();
AccountWrapper reqJSON = AccountWrapper.parse(bodyJSON);
for(AccountWrapper.accRecords acc : reqJSON.AccountList){
accMap.put(acc.AccId,acc.NextVal);
}

My test class is failing above highlighted line,i want to pass list of Account id in JsonBody 

currently i am facing below error message
System.JSONException: Malformed JSON: Expected '{' at the beginning of object  - i think this is i am passing single record
 

I have a very large customer requirement in which they have products and a customer object related to Cases that references those products (when they are used in a case).

What they would like to do is have a related object to products to capture stock available, having a custom object would allow me to have batches and batch numbers which is why ive chosen that way over just a quantity field on the product. 
Then be able pick them when completing a repair, and have the counters be dynamic, updating when stock is replensihed and decreasing when they are consumed. 
Anyone have any thoughts how i could best complete this?

Hi,
  I want to add a quick action button for my component(lwc) on the list view. And in my js-meta.xml, I added the following :

<targets>
<target>lightning__AppPage</target>
<target>lightning__HomePage</target>
<target>lightning__RecordPage</target>
<target>lightning_RecordAction</target>
</targets>
<targetConfigs>
<targetConfig targets="lightning_RecordAction">
<actionType>Action</actionType>
</targetConfig>
</targetConfigs>

but I got the following error message when I tried to add it to my org:
'lightning_RecordAction' target is not a valid target.

Anyone knows how to add a quick action button to the component (lwc) on the list view? Any example or reference is appreciated.

Thanks,
   Jo

When trying to convert a Lead using the standard APEX method we get a DUPLICATE_DETECTED error because there is another Lead with the same email address. The same behaviour is not experianced with the exact same Lead when converting using the convert button on the screen.

Error Message:
System.DmlException: ConvertLead failed. First exception on row 0; first error: DUPLICATES_DETECTED, You're creating a duplicate contact. We recommend you use an existing record instead.: []

Apex Code (from SF Example in Doc (https://developer.salesforce.com/docs/atlas.en-us.apexref.meta/apexref/apex_dml_convertLead.htm))

Database.LeadConvert lc = new Database.LeadConvert();
lc.setLeadId('00Q5t000003eBKzEAM');
lc.setConvertedStatus('Closed - Converted');
Database.LeadConvertResult lcr = Database.convertLead(lc);

Is this a bug in the out of the box method or am I missing something?

 

Consider the following transaction:

AggregateResult[] x = 
[SELECT SellToCust__r.Id,  SUM(InvAmount__c) 
FROM Invoice__c 
WHERE InvDate__c >= 2023-01-01 AND InvDate__c <= 2023-08-31 
GROUP BY SellToCust__r.Id
HAVING SUM(InvAmount__c) >= 2000];

where SellToCust__c is the field that relates an invoice__c (child) to the corresponding Account.

If I try this in an anon block of code I run against the 50,000 row limit. Batch Apex cannot handle results from such SOQL queries. If I try, for example, to simplify the query and then do the grouping etc. myself in Batchable execute() and finish() methods, I run into the heap size issue.

How would you approach this issue?
I am a novice developer and I find that I spend as much time writing logic as looking for ways to work around governor limits. Anyone else?

hello everyone, 

I need some help to be able to get the infomrations of this small part of JSON : 

 

"cancellation_policies":{
   "alidays":[
      {
         "text_message":"Penale voli emessi o non emessi: 200 euro a persona",
         "penalty":{
            "money":{
               "currency":"EUR",
               "amount":500
            }
         }
      }
   ],
   "agency":[
      {
         "text_message":"Penale voli emessi o non emessi: 200 euro a persona",
         "penalty":{
            "money":{
               "currency":"EUR",
               "amount":875.43
            }
         }
      }
   ]
}

I say small part since the passed JSON turns out to be much larger, but I am having difficulty with getting the data from this part only. 

I created my wrapper class to help me with the deserialization after I wrote this to be able to get the "cancellation_policies" part 

 

 

public Map<String, Object> serviceInfo;
this.serviceInfo = (Map<String, Object>) deserializedObj.get('cancellation_policies');
        system.debug('cancellation_policies' +serviceInfo);

Now, however, i cannot get the information that is within my two lists : alidays and agency, 

I should save the information to custom fields such as : 


CancellationPolicies__c = alidays.text_message;
CancellationPoliciesPublic__c =agencies.text_message;
AlidayPolicieAmount__c alidays.penalty.money.amount;
etc.
 

Thanks for help. 

if(mapOldOpp != null && opp.stageName != mapOldOpp.get(opp.Id).stageName && opp.stageName == PROJECT_STAGE_PENDING_APPROVAL && setRecTypeID.contains(opp.RecordTypeID)){
                setOppDOAId.add(opp.Id);                
            }
           
            if(mapOldOpp != null && opp.stageName != mapOldOpp.get(opp.Id).stageName && opp.stageName == PROJECT_STAGE_APPROVED_FOR_PAYMENT && setRecTypeID.contains(opp.RecordTypeID)){
                setOppPaymentId.add(opp.Id);
            }
        }
        
        system.debug ('@@@ setOppDOAId : ' + setOppDOAId);
        system.debug ('@@@ setOppPaymentId : ' + setOppPaymentId);
        
        //
        if(setOppPaymentId != null && !setOppPaymentId.isEmpty()){
            
            Set<String> pmStatusSet = new Set<String>{'Withdrawn', 'Rejected'};
            list<OpportunityLineItem>lstOppLine = [select id,ESA_Total_Approved_Cost_EI__c,Opportunity.Program_EI__c, Opportunity.Program_EI__r.Pgm_Code_EI__c,
                                                          Opportunity.ImplementerAccount_EI__c, Opportunity.ImplementerAccount_EI__r.Vendor_Number_EI__c, 
                                                          Opportunity.ContractorAccount_EI__c, Opportunity.ContractorAccount_EI__r.Vendor_Number_EI__c,
                                                          ESA_Order_Number_EI__c,GL_Account_Code__c,Measure_Code_EI__c,Payment_EI__c,
                                                          Payee_Attention_To_EI__c, Payee_EI__c, Payee_Mailing_Add_EI__c, Payee_Mailing_City_EI__c,
                                                          Payee_Mailing_State__c, Payee_Mailing_Zip_EI__c, Opportunity.RecordType.DeveloperName,
                                                          Opportunity.Name
                                                          from OpportunityLineItem 
                                                          where OpportunityId IN : setOppPaymentId AND Payment_EI__c = null 
                                                          AND Project_Measure_Status_EI__c NOT IN : pmStatusSet  limit 10000];
                                                          
            map<string,decimal>mapImplementorOrderTotalCost = new map<string,decimal>();
            map<string, OpportunityLineItem> mapImplementorOrderLine = new map<string, OpportunityLineItem>();
            string keyVal ='', keyVal1 = '', keyVal2 = '';
            String sysAdminError = '';
            

I have to write a test class,Can anyone help me to cover this part?

Hi,

I have created this component :

<lightning:recordEditForm aura:id="edit" recordId="{!v.recordId}" 
                          objectApiName="Account" 
                          > 
    <lightning:inputField fieldName="Sales_DT__c" variant="label-hidden"/>
</lightning:recordEditForm>

Where Sales_DT__c is a lookup on User.
This field Sales_DT__c  has a value recorded : 00530000004FGcfAAG.

Before, it's was working with this old workaround : add lightning:recordViewForm in the same compoent, but it's doesn't work anymore :

<lightning:recordViewForm recordId="{!v.recordId}" 
                              objectApiName="Account" >
        <div class="slds-hidden">
            <lightning:outputField fieldName="Sales_DT__c" />
        </div>
    </lightning:recordViewForm>

I have already read this : https://developer.salesforce.com/forums#!/feedtype=SINGLE_QUESTION_SEARCH_RESULT&id=9060G0000005qTaQAI

But, I didn't found a good response.

Any idea on how to populating this lookup field when I load the component ?
 

Hi,

I have used a lightning:datatable and I want to format number in a column.

Today, i  my controller, I use :
{label: 'My number', fieldName: 'my_number', type: 'currency',sortable : true
},

My result is :
123,00 €

And I want to have :
123 €
=> No digit allowed after the commat.

Is there a way to do that ?

Thanks for your help,
Julien

Hi,

I'm using lightning:inputField, but I want only the input field, nothing else.
I have hidde the label, but I automaticaly get the helptext near the field.
And I don't want it in my component.

My code is :
<lightning:inputField fieldName="myCustomField__c" variant="label-hidden" "/>

Any Idea ?