Hello guys,
I’m working on my first ever apex class and currently facing the following issue.
In the class, which I wrote I use getInstance() method as follow:
Id mdrQueueId = (Id)User_Id__c.getInstance().get('mdr_queue_id__c');

to query Custom Settings and get the Id of a queue, which I use later on to update a Case Owner.

When I test the relevant functionality via GUI (as SysAdmin & regular user), everything is working perfect. The query returns the correct queue Id and the Case owner gets updated.

But, if I run the relevant test class, it fails!
I saw that the reason for this is that in case of test class execution the same query returns null instead of the actual Id.
I ran the test both as SysAdmin and as regular user. In both cases I get mdrQueueId = null.
I get the same result (null) if I use the query directly in (another) test class.

Please can you help me understand what causes such different behaviour?
Is there any principle difference by the use of getInstance() method in regular apex classes and test classes?

Thank you in advance!

Ventzi
 

Within Apex is there a way that I can check who updated a record. Basically a to check see if someone other than the account holder updated a record. 

Thanks for taking the time to read this! This is my first trigger and the purpose is to update the UnitPrice field on Opportunity Line Items with the value of a formula field Net_Amount__c.  I don't even understand the error message I received and will share below.

Greatly appreciate any help!

My Trigger:
 

trigger oliUpdate on OpportunityLineItem (after insert, after update) {

    Set <String> oliID = New Set <String> (); 
    For (OpportunityLineItem oli: Trigger.new) { 
        if (oli.OpportunityId != Null ) { 
        oliID.add (oli.Id); 
        } 
    } 
    If (oliID.size ()> 0) { 
        List <OpportunityLineItem> upOpiList = new List <OpportunityLineItem> (); 
        For (OpportunityLineItem ol: 
[SELECT Id, Net_Amount__c, UnitPrice FROM OpportunityLineItem WHERE id in: oliID AND Net_Amount__c > 0.0]) { 
            ol.UnitPrice = ol.Net_Amount__c; 
            UpOpiList.add (ol); 
        } 
        If (upOpiList.size ()> 0) 
            update upOpiList; 
    } 
}

global class LoanOfficerBatch implements Database.Batchable<sObject> {
    public String query = 'SELECT Loan_Officer_1a__c,Loan_Officer_1a__r.Email, ConvertedOpportunityId, Name, Phone, Starting_Credit_Score__c, ' 
                          +  'Status, Enrolled_On__c, Est_Re_Pull_Date__c, Realtor_Name__c ' 
                          +   ' FROM Lead'; /*JMA:: add  ConvertedOpportunityId field*/ 
    public EmailTemplate templateId = [Select Id,HtmlValue,Subject from EmailTemplate where name = 'LoanOfficerRecord' LIMIT 1];

    global Database.QueryLocator start(Database.BatchableContext bc) {

        query += ' WHERE CreatedDate >= LAST_MONTH AND CreatedDate <= THIS_MONTH AND Loan_Officer_1a__c != null';
        return Database.getQueryLocator(query);
    }

    global void execute(Database.BatchableContext BC, list<Lead> allLeads) {
        
        //JMA:: Create a map of <Id, Opportunity>
        Map<Id,List<Opportunity>> OpptyMap = new Map<Id,List<Opportunity>>();
        //JMA:: Query Opportunities by using Lead.ConvertedOpportunityId. You need to first create a set of Id from Lead.ConvertedOpportunityId
        //JMA:: populate the map <Id, Opportunity>
        
        Map<Id,List<Lead>> leadMap = new Map<Id,List<Lead>>();
        List<Messaging.SingleEmailMessage> mails = new List<Messaging.SingleEmailMEssage>();
        if(allLeads != null && allLeads.size() > 0){
            for(Lead l: allLeads){
                if(!leadMap.containsKey(l.Loan_Officer_1a__c)){
                    leadMap.put(l.Loan_Officer_1a__c, new List<lead>());
                }
                leadMap.get(l.Loan_Officer_1a__c).add(l);
            }
        }
        if(leadMap.keySet().size() > 0){
            Map<Id,Contact> officers = new Map<Id,Contact>([SELECT Id,Email,Name FROM Contact WHERE Id IN: leadMap.keySet()]);
            for(Id i: leadMap.keySet()){
                Contact con = officers.get(i);
                System.debug(con);
                if(String.isnOtBlank(con.Email)){
                    Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
                    mail.setToAddresses(new String[]{con.EMail});
                    mail.setSubject(templateId.Subject);
                    String html = templateId.HtmlValue;
                    html = html.replace('||OfficerName||',con.Name);
                    String leadsTable = '<table cellpadding="3" cellspacing="3" width="100%" align="center" border="1" style="border-collapse:collapse;">'+
                        '<tr style="font-weight:bold;"><td>Name</td><td>Phone</td><td>Starting Credit Score</td><td>Status</td><td>Enrolled On</td><td>Est. Re Pull Date</td><td>Realtor Name</td></tr>';
                    for(Lead l: leadMap.get(i)){
                        //JMA:: for each lead you can get the associated Opportunity from map <Id, Opportunity>
                        leadsTable += '<tr><td>'+l.Name+'</td>'+
                            '<td>'+l.Phone+'</td><td>'+l.Starting_Credit_Score__c+'</td><td>'+l.Status+'</td><td>'+l.Enrolled_On__c+'</td>'+
                            '<td>'+l.Est_Re_Pull_Date__c+'</td><td>'+l.Realtor_Name__c+'</td></tr>';
                    }
                    leadsTable += '</table>';
                    html = html.replace('||Leads||',leadsTable);
                    html = html.replace('null',' ');
                    mail.setHTMLBody(html);
                    mails.add(mail);
                }
            }
        }
        if(mails.size() > 0){
            //Messaging.sendEmail(mails);
        }
    }

    global void finish(Database.BatchableContext BC) {

    }
   
}

 

Hi All,

I am new to lightning and trying use file upload lightning components. 

I used exact same code which is mentioned in salesforce website
https://developer.salesforce.com/docs/component-library/bundle/lightning:fileUpload/example
just replaced recordid to my account id

But it is not working.

Please help me on this

Thanks in Advance

Hi all,

I have a custom object called "CO" and having a field called "User".
I am able to get Account ID now, but I would like to get Account Name insted.
Would someone let me know if there is a way to get Account Name from CO?

=================================
CO (CO__c)
----
Id
User (User__c) -> Contact
                            ---------
                            Id
                            Company  (Account) -> Account
                                                               ---------
                                                               Id
                                                               Name
=================================

"User"       : Lookup(Contact)
"Company": Lookup (Account)

This is what I have now.
select User__r.AccountId from CO__c where Id = 'xxxxxxx';

Thank you,
HG

Can anyone help me on getting  below data , some sample endpoint URL and response as XML.
New to Integration, learning how the parse  json and xml from response. I have one url for json( https://api.androidhive.info/contacts/) but not for xml.

Thanks in Advance.....

HttpRequest req=new HttpRequest();
req.setendpoint(' ? ');
req.setmethod('GET');
http req1=new http();
httpResponse xmlresponse=req1.send(req);

 

Hello,

I am having trouble completing a module, specifically, the second hands-on challenge. In the challenge you are asked to modify the Opportunity Pipeline report and create a Key Accounts report with a probability greater than 30%. When I go to check the challenge I am told that the report does not show records with a probability greater than 30%. I have checked the report multiple times along with recreating the report in another trailhead playground.
Has anyone experienced this problem?

Dears,

Can Anyone give me a good solution !!

Example:- 

Person A and Person B Working in Same company , Person A Will not continue his job hereafter. Suddenly he leaves his job without give any information. So Person B need to handle him record as well. How it's Possible ???

1. Person A Using Different Profile .

2. Person A Records OWD is Private.

3. How person B can access that records ???


Thanks In Advance !

Regards,
Soundar P

Hi All,

Am very new to API.In my salesforce org, somebody implemented the API. I don't know whether its REST/SOAP.

Now I want to do some changes in that. Kindly let me know, where I to find the respective API details in my Org.

 

From VF Page:
<div style="float: left; width: 20%;">

<apex:outputField value="{!d.Company__c}" />

</div>

In the controller, if the Company__c is null, I want to set its value to '<div class="spacer" />' so that the div tag is rendered correctly on the page.  My output at the moment is literally <div class="spacer" />.

The goal is to have 5 static columns on the page but if one of the custom fields for the custom object is null, I just want a placeholder there in the HTML so that everything continues to line up correctly.

Hi,

How to access apex class method form process builder, I want to access apex class function by process builder but ,i am not able to access my class function.

Please suggest.

Thanks
Deepak 

Hi,

I am not aware about omni channel and where it's used.  Can you please benefit of this.


Thanks
Romash

Hi everybody,
I'm trying to render a VF Page which contains JavaScript to Generate a QR Code like so:
VF Page:

But PDF after the renderAs is all messed up:

Anyone knows how to render Javascript to PDF?

Hi

We have a visualforce section on all of our Opportortunity page layouts.
This section shows a particular image depending on what has been selected within the stage field.
Below is a sample of the code that we have in place.
Is it possible to split it up so that depending on which Opportunity Record Type is selected different images can be displayed against each stage?

For example if record type = X and the stage is Closed Won then show image A
If record type = Y and the Stage is closed Won then show image B

Thank you
 

<apex:page standardController="Opportunity" showHeader="true" sidebar="true">

<div align="center">

></apex:image> <apex:image id="won" value="{!$Resource.stageWon}" height="60" rendered="{!Opportunity.stageName = 'Closed Won'}"

 ></apex:image> <apex:image id="lost" value="{!$Resource.stageLost}" height="60" rendered="{!Opportunity.stageName = 'Closed Lost'}" 

</div>

</apex:page>

 

Hello,

I have following error:
System.CalloutException: You have uncommitted work pending. Please commit or rollback before calling out

My usecase:
I am calling a webservice in a future handler. 

Other workaround i tried:
I tried to call the webservice without a future handler, but as i am calling in trigger it is giving me error.

Can someone please tell me any workaroud ?

thank you

I am using a process buider:- 

if user cloned any opportunity then one of my process builder should not execute, after creation of this opportunity if user edit this opportunity then process builder should execute.

Please suggest

Hi Expert,

I have a custom field on Task object, and now i want to update task by API. i have tried to update by Postman, but facing error.
 

{
        "message": "insufficient access rights on object id",
        "errorCode": "INSUFFICIENT_ACCESS_ON_CROSS_REFERENCE_ENTITY",
        "fields": []
    }

 Please suggest

Regards
Mukesh

Hi Expert,

I am using add error method, when criteria match then addError method call, but here script doenot stop and execute next loop.

i want to stop script when addError call. i have used break; return; but nothing happen

 

for (Opportunity currOpp: newOpportunities_1){
              System.debug('currOpp name '+currOpp.name);
            if (currOpp.RecordTypeId!=PMRecordTypeId.Id  ){
                currOpp.addError(Label.pmr);   
               
            }
          }

for (Opportunity currOpp: newOpportunities_2){
              System.debug('currOpp name '+currOpp.name);
         
          }

Thanks 
Mukesh

 

Hi Expert ,

I am creating dynamic check boxes that's crated perfect, change event is not working for created check boxes;

when i select any check box then get error
getting error :- Unable to find action 'handleSelectedOLI' on the controller 
 

for(var i = 0; i<5; i++){
 $A.createComponent(
            "ui:inputCheckbox",
            {
                "aura:id": "checkBoxOLI",
                "value":chekboxVal,
                "change": component.getReference("c.handleSelectedOLI")
            },
            function(newButton, status, errorMessage){
                //Add the new button to the body array
                if (status === "SUCCESS") {
                    var body = component.get("v.body");
                    //body.push(newButton);
                    component.set("v.body", newButton);
                }
                else if (status === "INCOMPLETE") {
                    console.log("No response from server or client is offline.")
                    // Show offline error
                }
                else if (status === "ERROR") {
                    console.log("Error: " + errorMessage);
                    // Show error message
                }
            }
        );  
		
handleSelectedOLI: function(component, event, helper) {
        alert('change ecevt ');
    
    },

Please suggest

Regards
Mukesh

Hi Expert,

I want to destroy selected check box when user try to select all and click on delete buttion.
 without destroy this is exist already and make extra check boxes that's was previously deleted so now i want to destroy selected items

Below code is creating check boxes:-

this is select All check box

<ui:inputCheckbox value = "{!v.isSelectAll}" change="{!c.handleSelectAllOLI}" aura:id="selectAll"/>

this is list of check boxes:-

<aura:iteration items="{!v.DEFProductInstance}" var="item" indexVar = "indx">
<ui:inputCheckbox aura:id="checkBox" />
 </aura:iteration>

Please suggest

Thanks

When manager reject opportunity then error message display from trigger, but i want to bypass addError message in apex trigger. for spicific condition user face addError message, but when opportuntiy reject by manager then i want to by pass this error message.

Please suggest

Regards
Mukesh 

Hi Expert,

I am using below code but not able to get maximum length  on keyUp event.

 

<ui:inputCurrency class="slds-input" aura:id="curr" format="##,##,###,##0.00" maxlength="6" updateOn="keyup" keyup = "{!c.changesValueInput}"/>

Please suggest
 

Hi Expert,

I am creating contact by 'e.force:createRecord', but now i want to created contact record Id. after this event. 

Can you please suggest.

Regards
Mukesh 

Hi Expert,

I am trying to create a lwc project in VS code, but when i try to create 
then facing error:

command 'sfdx.force.project.create' not foundPlease suggest.

I am using jdk1.8.0_231 for 64 bit

Hi expert,

I have multiple country picklist in lightning compont that's is iterating in Table TR
we i choose any picklist value 'UAS' and click on save button than this picklist should be disable.

but when i change of picklist then picklist disable on selection time. but i want to disable on save button.

Please suggest

<aura:iteration items="{!v.CountryDetails}" var="item" >
<tr> 
<td class="slds-cell-wrap">
                        <lightning:select name="statusFld" label="" value="{!item.Country__c}" disabled="{!item.Country__c == 'Closed Won')}">
                            <option value="--None--">--None--</option>
                            <aura:iteration items="{!v.listCountry}" var="val">
                                <option value="{!val.value}" selected="{!val.value==item.Country__c}">{!val.key}</option>
                            </aura:iteration>
                        </lightning:select>
                    </td>
</tr>
</aura:iteration>

 

Hi I am using visualforce page to open Lightninng component in new tab:-

on opportunity object -->> button & Link (Name:-AddProduct)

add URL parameter :- 

/apex/OppProduct_VFP?oppId={!Opportunity.Id}

when user click on 'AddProduct' button then below VF page open in new tab with lightnig component:-

OppProduct_VFP:-

<apex:page controller="TestController" tabStyle="Opportunity" lightningStylesheets="true">
    <apex:includeLightning />
    <div class="slds" style="margin-top:10px;margin-left:10px;"> 
        <div id="lightning" />
    </div>
   
    <script>
    

        $Lightning.use("c:AddProductApp", function() {
            $Lightning.createComponent(
                "c:AddProduct",
                {recordId : "{!OpportunityId}"},
                "lightning",
                function(cmp) {
                   
            });
        });
    </script>
</apex:page>

i have a close button in AddProductController to close this tab but not able to closed this tab getting UNDEFINED in console log. i am not able to get TabId by this code.

 

Close : function(component, event, helper){
        var workspaceAPI = component.find("workspace"); // mentioned in component 
          workspaceAPI.isConsoleNavigation().then(function(consoleResponse) {  
              console.log('consoleResponse-->>> '+consoleResponse) // return undefined
              workspaceAPI.getFocusedTabInfo().then(function(tabResponse) {
                  console.log('tabResponse-->> '+tabResponse)// return undefined
                   var isSubtab = tabResponse.isSubtab;
                  console.log('isSubtab-->> '+isSubtab);// return undefined
              });
        });

Please suggest and let me know where i am wrong
​​​​​​​

I am using a lightning componet, whrn i click on a button then this coponent open. on this component i have a close button. when i click on this closed button page redirect to previous page, but tab not closed.

i am using below code for tab close

closeFocusedTab : function(component, event, helper) {
         var workspaceAPI = component.find("workspace");
        //alert(workspaceAPI);
        workspaceAPI.getFocusedTabInfo().then(function(response) {
            //alert('aaaa -- '+response);
            var focusedTabId = response.tabId;
            workspaceAPI.closeTab({tabId: focusedTabId});
        })
        .catch(function(error) {
            console.log(error);
        });

    
    }

    Can you please suggest.

Hi Expert,

I want to add attachment on record creation time in apex code, but in attachment custom code  we need record Id, but record is not created. so how achive this functionality,

Example: when we fill any exam from then we can attachemtn or document, and then save the record.

Thanks
 

Hi Expert,

i want to open a popup box that should be open when user logged In. when user  closed this then this will not reopen for this session. if user logged in again then popup should be open .

what i have done:

create a lightning component and added this on home page layout. but this popup open again and again when home page refresh. 

So can you please suggest what should i use sothat model popup should open once for current session.

Regards
Mukesh

Hi Expert,

I want to use Remote Objects in lightning component , below code is working in visualforce  pages, but now i need to implement this code in lightning component.

for example:- 
  <!-- Remote Objects definition to set accessible sObjects and fields -->
    <apex:remoteObjects >
        <apex:remoteObjectModel name="Warehouse__c" jsShorthand="Warehouse" 
            fields="Name,Id">
            <apex:remoteObjectField name="Phone__c" jsShorthand="Phone"/>
        </apex:remoteObjectModel>
    </apex:remoteObjects>

Thanks
Mukesh

Hi Expert,

In one class i have two soql:-
Example:- 
public class test(){

     List<Account> acc = [select id, name from Account Limit 40000];
     List<Contact> con = [seldect id, email from Contact Limit 15000];
}

//above queries will return limit excede error or not 

 

Hi Expert,

I want to reopen a case when any email comes from user. what i implemented:-

I creaed a workflow that execute on when agent close a case with email template taht's have a case thread id. but when customer reply this email then related case shouuld be reopen and this mail should be add in Email related list on that case.

Please suggest.

Regards
Mukesh​



  





 

Hi Expert,

How would sharing rule work in the below scenario
Suppose i create a new object called "XXXX". Now profile called "AAAA" doesn't have read, create, edit permission on it.

Q1: What would happen if I create a record of object "XXX" and share it with user which has profile "AAAA" and give him "Edit" permission on the record? Would user be able to see the record or edit the record? please qualify your answer.

Q2: Can anybody explain in what order access on record or object is granted in terms of OWD, Sharing rule, Role and profile?

Q3: If i set OWD setting as Public Read/Edit on Object "XXXX" but profile "AAAA" don't have read, create and edit permission on Object "XXXX" then the user who owns profile "AAAA" would be able to see and edit the records of object "XXXX"?

Q4: What would happen if profile "AAAA" has only Read permission on Object "XXXX" then user who owns profile "AAAA" would be able to see and edit ALL the records of object "XXXX"?

Q5: In order to work out OWD setting, at least profile must have Read permission on that particular object?

Q6: The user who is higher role in hierarchy would get owner permission on the records created by user who are lower in the roles means he can edit and delete the record as well. Is that correct?

Please share your best 

Regards
Mukesh

Hi Expert,

I have added a inline visualforce page on case page layout. Now i am able to upload files perfectlry, but now i want to add loader or spiner on file upload time. I add a spiner in visualforce page but when uploading compleatd. then this move on case Tab with files list not on same page. 
 

<apex:page standardController="Case" extensions="UploadFileController" >
<apex:form >
<style type="text/css">
.bPageBlock .detailList .dataCol {
    width: 100%;
}

.bPageBlock .detailList .dataCol {
    width: 107%;
}


dataCol.first {
    text-align: center;
    }

  .detailList td.dataCol.first.last:nth-child(1) {
    text-align: right;
    width: 50%;
}
.inner-tab {
    padding: 20px 0px;
}
  </style>
  
 
 <apex:pageMessages />
 
 <apex:actionStatus id="pageStatus">
    <apex:facet name="start">
        <apex:outputPanel >
           <img src="/img/loading32.gif" width="50" height="50" />
           
            <apex:outputLabel value="Loading..." />
        </apex:outputPanel>            
    </apex:facet>
    
    <apex:facet name="stop">
         
    
    </apex:facet>
    
</apex:actionStatus>
 
<apex:pageBlock >




<apex:pageBlockSection id="sec1" rendered="{!sec1}"> 
    <apex:commandButton id="btnUpload"  action="{!Upload}" value="Upload File"  />
   
    <br/>
     <br/>
    <apex:pageBlock title="File Links" id="rerenderId">
    
      <apex:pageBlockTable value="{!listOfFiles}" var="fl" width="100%">
           <apex:column headerValue="URL" width="50%"><apex:outputLink target="_blank" value="{!fl.URL__c}">{!fl.Url}</apex:outputLink></apex:column>
           <apex:column headerValue="Created Date" width="20%" value="{!fl.createdDate}"></apex:column> 
      </apex:pageBlockTable>
    </apex:pageBlock>
  
    
</apex:pageBlockSection>


<div class="inner-tab">
<apex:pageBlockSection id="sec2" rendered="{!sec2}">
 <apex:inputFile value="{!AttchBody}" fileName="{!AttchName}" fileSize="{!AttachSize}"/>
 
 <apex:commandButton id="btnSubmit"  action="{!SubmitAttachment}" value="Submit Attachment"/>
</apex:pageBlockSection>
 </div>


</apex:pageBlock>





</apex:form>
 
  
</apex:page>

  

public with sharing class UploadFileController {

    Public Id RecordId {get;set;}
    public Blob AttchBody {get;set;}
    public String AttchDesc {get;set;}
    public String AttchName {get;set;}
    Public Integer AttachSize {get;set;}
    Public Attachment attch {get;set;}
    public boolean attachmentBtn {get; set;}
    public boolean sec1 {get;set;}
    public boolean sec2 {get;set;} 
    public External_File_Relationship__c fileDB; 
    public External_File__c ef;
    public List<String> fileList {get;set;} 
    public String parentId; 
    Public List<External_File__c>listOfFiles {get;set;}
     
  
     public UploadFileController(ApexPages.StandardController controller) {
        parentId = ((case)controller.getRecord()).id;
        sec1 = true;
        sec2 = false;
        
        RecordId = ApexPages.CurrentPage().getParameters().get('Id');
        init();

    }
    
    
    public PageReference SubmitAttachment(){
    
      if(AttchName != '' && AttchBody != NUll ){
      
      //file that is 25Mb or less
      if(AttachSize <= 25000000 ){
          External__c  extFile = new External__c();
          extFile.Name =  AttchName;
          extFile.CaseId__c = RecordId;
          
          Insert extFile ;
          attch = new Attachment(ParentId=extFile.id,Description=AttchDesc,Name=AttchName,Body=AttchBody);
       
         try{
                insert attch;
                
                system.debug('attch  '+attch);
                AttchBody = null;
                AttchDesc = null;
                AttchName = null;
               
            }
            catch(DMLException ex){
                    ApexPages.addMessage(new ApexPages.message(ApexPages.severity.ERROR,'Error uploading attachment'));
                    return null;
             
            }
            
            
            ApexPages.addMessage(new ApexPages.message(ApexPages.severity.INFO,'Attachment uploaded successfully'));
            
            string Attid= attch.id;
            string attachmentid=Attid.substring(0,15);
            String sfdcBaseURL = URL.getSalesforceBaseUrl().toExternalForm();
            extFile.File_Public_URL__c = sfdcBaseURL+'/servlet/servlet.FileDownload?file='+attachmentid;
            update extFile;
            sec2 = false;
            sec1 = true;
            init();
          
      }
      
      }else{
      
          ApexPages.addMessage(new ApexPages.message(ApexPages.severity.ERROR, AttchName +' is too large - please choose a file that is 25Mb or less'));
      
      }
        return null;
          
      }
      
      public void init(){
           List<External_File__c> lst = [Select URL__c, CreatedDate  from  External__c where CaseId__c =: RecordId];
           listOfFiles  = lst;
      }
      
     public PageReference Upload() {
       sec1 = false;
       sec2 = true;
       
       return null;
         
    
    }

}

when i add spinner or Loding then, this move to case tab with inline visualforce page.


Please suggest, what i am doing wrong

Regards
Mukesh
 

Hi Expert,

I am using below code in my lightning componant but facing error "Jquery_File/jquery-3.3.1.min.js 404 (Not Found)" in browser console.

here "Jquery_File" is static resources name and 
 <ltng:require scripts="{!$Resource.Jquery_File + '/jquery-3.3.1.min'}" />

https://testnewdomian-dev-ed.livepreview.salesforce-communities.com/sfsites/c/resource/1535093740000/Jquery_File/jquery-3.3.1.min.js 404 (Not Found)

Thanks
Mukesh

 

Hi Expert,

I want to create some demo on marketing cloud  journey builder. Can any one share about how to acces journey builder in markeing cloud.

Thanks
Mukesh

Hi Expert,

I need to create an application for me to send SMS directly from Salesforce. Please suggest.

Hi Expert,

I am using a test class for coverage 75% code, but few things are not covered. Can any one suggest what is going wrong.

this my test Class: --

@isTest
public class TestProfessorSelectCourse {
    @isTest static void ProfessorCourse(){
       
        
        Professor__c prof = new Professor__c(Name ='JP',Email__c='jp@gmail.com');
        insert prof;
        
        Class__c cls = new Class__c(name='12G', Class_Teacher__c = prof.id);
        insert cls;
        
        Course__c cors = new Course__c(Professor__c=prof.id,Class__c =cls.id, name='Ruby', Start_Date__c= Date.today() , End_date__c= Date.newInstance(2017,03,20));
       	//Professor__c prof = new Professor__c(Name ='JP');
        //cors.Professor__c = prof.Name;
        insert cors;
    }
}

and below is my main class




Thanks 
Mukesh

I am using a process buider:- 

if user cloned any opportunity then one of my process builder should not execute, after creation of this opportunity if user edit this opportunity then process builder should execute.

Please suggest

Need help counting the number of files atatched to a custom object.
Should I be looking at ContentDocumentLinks
 

if ( Trigger.isInsert || Trigger.isDelete ){
            Set<Id> FileCount = new Set<Id>();

            for(SObject cdl : Trigger.new){
                ContentDocumentLink cdls = ( ContentDocumentLink ) cdl;

                FileCount.add(cdls.LinkedEntityId);
            }

            List<File_c> fileList = [SELECT Id, (SELECT Id FROM ContentDocumentLinks) 
            FROM File_c WHERE Id IN :FileCount];

            for(File_c fl : fileList){

                fl.Number_of_Files__c = fileList.size();

            }
        }

 

I tried on off everything but still getting --

Hi All,

I am clueless to locating or telling my salesforce endpoint url. Would anyone know how to tell please? Any documentation?

Thanks!

i want to save my metadata so i have created an unmanaged package. but when i upload it, i get a few error messages. See attached screenshot
I didnt write these triggers - can i solve the test coverage myself?
thanks

Hi All,

I am trying to build a summary report formula for our funding report but receive the Syntax Error. Missing ")". appreciate your advise on this.

Hello,

I am trying to create a trigger to uncheck a checkbox field on Account called "Active Order".
Basically when an Order has benn deleted from an account and there is no Order remaining for the Account, the trigger should uncheck Active Order. 

No Order:

Uncheck Active Order on Account


Can't get my trigger working properly
 

trigger AccountActiveOrderTrigger on Account (after delete) {
    
    List<Order> lstOrder = new List<Order>();
    
    //Get Accounts with orders 
    Map<Id, Account> accWithOrders = new Map<Id, Account>([SELECT Id, Name, Active_Order__c, (SELECT Id FROM Orders)
                                                          FROM Account WHERE Id IN: Trigger.old]);
    
    //Iterate through each Accounts
    for(account a : Trigger.old) {
        System.debug('Accounts with orders' +accWithOrders.get(a.Id).Orders.size());
        
        //Check if an Account has an order
        if(accWithOrders.get(a.Id).Orders.size() == 0) {
            a.Active_Order__c = False;
           	
        } 
        
     update a;
    }
 
}

Thank you

Hi Expert ,

I am creating dynamic check boxes that's crated perfect, change event is not working for created check boxes;

when i select any check box then get error
getting error :- Unable to find action 'handleSelectedOLI' on the controller 
 

for(var i = 0; i<5; i++){
 $A.createComponent(
            "ui:inputCheckbox",
            {
                "aura:id": "checkBoxOLI",
                "value":chekboxVal,
                "change": component.getReference("c.handleSelectedOLI")
            },
            function(newButton, status, errorMessage){
                //Add the new button to the body array
                if (status === "SUCCESS") {
                    var body = component.get("v.body");
                    //body.push(newButton);
                    component.set("v.body", newButton);
                }
                else if (status === "INCOMPLETE") {
                    console.log("No response from server or client is offline.")
                    // Show offline error
                }
                else if (status === "ERROR") {
                    console.log("Error: " + errorMessage);
                    // Show error message
                }
            }
        );  
		
handleSelectedOLI: function(component, event, helper) {
        alert('change ecevt ');
    
    },

Please suggest

Regards
Mukesh

Hi there,

Below is my test class where the SearchMembers method fails: System.AssertException: Assertion Failed: Expected: 4, Actual: 0

The testLoadData method passes....

Any help appreciated....
==
@isTest
private class MembershipDirectoryControllerTest {

    @testSetup static void createData() {
        List<Account> accounts = new List<Account>();
        Account a1 = new Account();
        a1.Name = 'Test 1';
        a1.Membership_Level__c = 'Catalyst';
        a1.Category__c = 'Farms';
        a1.Keywords__c = 'farm';
        a1.BillingPostalCode = '11111';
        a1.Directory_Display_Override__c = true;
        accounts.add(a1);

        Account a2 = new Account();
        a2.Name = 'Test 2';
        a2.Membership_Level__c = 'Champion';
        a2.Category__c = 'Education';
        a2.Keywords__c = 'test';
        a2.BillingPostalCode = '22222';
        a2.Directory_Display_Override__c = true;
        accounts.add(a2);

        Account a3 = new Account();
        a3.Name = 'Test 3';
        a3.Membership_Level__c = 'Catalyst';
        a3.Category__c = 'Farms';
        a3.Keywords__c = 'farm';
        a3.BillingPostalCode = '11111';
        a3.Directory_Display_Override__c = true;
        accounts.add(a3);

        Account a4 = new Account();
        a4.Name = 'Test 4';
        a4.Membership_Level__c = 'Champion';
        a4.Category__c = 'Business Supplies';
        a4.Keywords__c = 'farm';
        a4.BillingPostalCode = '22222';
        a4.Directory_Display_Override__c = true;
        accounts.add(a4);

        Account a5 = new Account();
        a5.Name = 'Test 5';
        a5.Membership_Level__c = 'Catalyst';
        a5.Category__c = 'Farms';
        a5.Keywords__c = 'test';
        a5.BillingPostalCode = '11111';
        a5.Directory_Display_Override__c = true;
        accounts.add(a5);

        Account a6 = new Account();
        a6.Name = 'Test 6';
        a6.Membership_Level__c = 'Champion';
        a6.Category__c = 'Personal Services';
        a6.Keywords__c = 'farm';
        a6.BillingPostalCode = '22222';
        a6.Directory_Display_Override__c = true;
        accounts.add(a6);

        Account a7 = new Account();
        a7.Name = 'Test 7';
        a7.Membership_Level__c = 'Business';
        a7.Category__c = 'Farms';
        a7.Keywords__c = 'test';
        a7.BillingPostalCode = '11111';
        a7.Directory_Display_Override__c = true;
        accounts.add(a7);

        insert accounts;
    }
  
  @isTest static void testLoadData() {
    Test.startTest();
        MembershipDirectoryModels.FormData fd = MembershipDirectoryController.loadData();
        Test.stopTest();

        System.assertNotEquals(null, fd.categories);
        System.assertEquals(6, fd.spotlightMembers.size());
  }
  
  @isTest static void testSearchMembers() {
    Test.startTest();
        List<Account> categorySearch = MembershipDirectoryController.searchMembers('category', 'Farms');
        List<Account> nameLetterSearch = MembershipDirectoryController.searchMembers('name', 'T');
        List<Account> nameSearch = MembershipDirectoryController.searchMembers('nameSearch', 'Test 3');
        List<Account> keywordSearch = MembershipDirectoryController.searchMembers('keyword', 'test');
        List<Account> zipCodeSearch = MembershipDirectoryController.searchMembers('zipCode', '11111');
        Test.stopTest();

        System.assertEquals(4, categorySearch.size());
        System.assertEquals(7, nameLetterSearch.size());
        System.assertEquals(1, nameSearch.size());
        System.assertEquals(3, keywordSearch.size());
        System.assertEquals(4, zipCodeSearch.size());
  }
  
}


 

Hi I am getting the error on Account Record Page while editing Account record from UI  Error: First exception on row 0; first error: MISSING_ARGUMENT, Id not specified in an update call: []: Trigger.AccConTestTrigger and trigger code is as below

trigger AccConTestTrigger on Account (After update) {
  
    if(trigger.isAfter && trigger.isUpdate){
        System.debug('this is in isAfter and isUpdate context');
     List<Contact> conList=new List<Contact>();
     for(Account acc : trigger.new ){
         Contact con=new Contact();
         con.AccountId = acc.Id;
         System.debug('Account Id value is --->'+con.AccountId);
         System.debug('Account Id value from the screen --->'+acc.Id);
         con.Department = 'The Last Dep';
        conList.add(con);
     }
    update conList;
  }
}
Could some one please help me in this,how to solve this

I have built a scheduler test class that tests if the batch runs successfully.
When I test manually I can see the data gets populated as expected but the assertion in the scheduler test class fails.
 

Here is the code
        @isTest
public with sharing class ScheduleEmployeeBatchTest {
    static testmethod void schedulerTest() 
    {
        String CRON_EXP = '0 0 0 15 3 ? 2022';
        
        // Create test data
          Employee__c emp =TestData.getNewEmployee();
          emp.EmployeeNumber__c = ‘Emp001’;
          insert emp;
        
        Test.startTest();  
        String jobId = System.schedule('ScheduleEmployeeBatchTest',  CRON_EXP, new ScheduleEmployeeBatch());
        CronTrigger ct = [SELECT Id, CronExpression, TimesTriggered, NextFireTime FROM CronTrigger WHERE id = :jobId];
            System.assertEquals(CRON_EXP, ct.CronExpression);
            System.assertEquals(0, ct.TimesTriggered);
        

        Test.stopTest();
        
         // verify that the employee was created successfully
        System.assertEquals(
            1,
            [
                select Id
                from EmpTeam__C
                where Employee__r.Name = ‘Emp001’
            ].size()
        );
    }
}

 

Hello,

I have a code coverage of 100% for my trigger but uploading my packages to production I have an error 
Code Coverage Failure
Your code coverage is 74%. You need at least 75% coverage to complete this deployment.

I really don't understand why when my code is covered 100%



my Trigger:
 

trigger CaseConcernAircallDateTrigger on Task (after insert) {
   
    List<Case>  cList = new List<Case>();
    for(Task t: Trigger.New) {
        if(t.WhatId!=Null && t.whatId.getsObjectType() == Case.sObjectType){
            Case c = new Case();
            c.Id = t.whatId;
            c.Last_Aircall_Logged__c = t.CreatedDate;
            cList.add(c);
        }
    }
   
    if(cList.size() > 0) update cList;
}

my Test class:
 

@isTest
public class CaseConcernAircallDateTriggerTest {
    @isTest static void testAircallDateUpdate() {
        
        
        Contact con = new Contact (FirstName = 'First Name',LastName = 'Test');
        insert con;
        
        Case c = new Case(Status = 'New',ContactId = con.Id,Phone_Number__c = '123456789');
        insert c;
        
        Task t = new Task(Subject = 'Test', WhatId = c.Id);
        insert t;
       
        c.Id = t.WhatId;
        c.Last_Aircall_Logged__c = t.CreatedDate;
        update c;
       
    }
}

Thank you
 

Hi All,

Need a help,

1) want to run the class from 8 Am to 2 PM everyday
2) and want to run the class from 5PM to 3 AM Everyday.
any ideas on cron expression. 

Thanks,
Billing
    

Hello guys,
I’m working on my first ever apex class and currently facing the following issue.
In the class, which I wrote I use getInstance() method as follow:
Id mdrQueueId = (Id)User_Id__c.getInstance().get('mdr_queue_id__c');

to query Custom Settings and get the Id of a queue, which I use later on to update a Case Owner.

When I test the relevant functionality via GUI (as SysAdmin & regular user), everything is working perfect. The query returns the correct queue Id and the Case owner gets updated.

But, if I run the relevant test class, it fails!
I saw that the reason for this is that in case of test class execution the same query returns null instead of the actual Id.
I ran the test both as SysAdmin and as regular user. In both cases I get mdrQueueId = null.
I get the same result (null) if I use the query directly in (another) test class.

Please can you help me understand what causes such different behaviour?
Is there any principle difference by the use of getInstance() method in regular apex classes and test classes?

Thank you in advance!

Ventzi
 

  Map<String,Object> results = (Map<String,Object>)JSON.deserializeUntyped(response.getBody());
              
                list<object> attchlist;
                list<ContentVersion> CV = new list<ContentVersion>();
                list<ContentDocumentLink> CDLink = new list<ContentDocumentLink>();
                Set<Id> contentDocumentIds = new Set<Id>();
                Set<FileData> fileFromSAP = new Set<FileData>();
                
                for(Object mapa:results.values() ){
                    Map<String,Object> tempMap = (Map<String,Object>)mapa;
                    map<string,object> attc = (Map<String,Object>)tempMap.get('Attachment');
}

This exception is coming while running the code...someone please help

I have a requirement wherein I have to create batch class that picks all the contacts which has “Eligible” checkbox true. Batch execution should perform below operation :
•All the opportunities which has these contacts as a Ship To contact roles , update its stage as “Qualified”.
but I am unable to fetch the contact roles from the opportunity

Hello there,
my batch getting failed to update some records and I gets following error message.

Apex script unhandled exception by user/organization: 0098d000007tvRV/00Db002ef00HO6N

Failed to process batch for class 'CalcFirstInvoice' for job id '7070X5640CQtuKf'

caused by: System.DmlException: Update failed. First exception on row 0 with id 001b000000OlwatAAB; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record: []

Class.CalcFirstInvoice.execute: line 26, column 1

Please help me

IF(  ROI_No_of_Months__c  < 13,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFeo", "green", 30, 30)
IF( ROI_No_of_Months__c  > 24,
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFee", "yellow", 30, 30),
IMAGE("//c.na139.content.force.com/servlet/servlet.FileDownload?file=0154W00000BiFej", "red", 30, 30),
))

Any help would be appreciated.  Thanks!