public class BatchHealthcareJourneyLastSyncedDate implements Schedulable, Database.Batchable<sObject>{
    
    public void execute(SchedulableContext sc) {
        Id batchProcessId = Database.executeBatch(this);
    }
    
    public Database.QueryLocator start(Database.BatchableContext bc) {
        Map<Id, HealthCare_Journey_Template__c> hcjTempMap = new Map<Id, HealthCare_Journey_Template__c>(
            [SELECT Name, Template_Last_Modified__c, 
            (SELECT Field, NewValue, OldValue, ParentId FROM Histories WHERE Field = 'Template_Last_Modified__c')
             FROM HealthCare_Journey_Template__c]);
        
        Set<Id> hcjTempIds = new Set<Id>();
        for(HealthCare_Journey_Template__c hcjTmp : hcjTempMap.values()) {
            for(HealthCare_Journey_Template__History hcjhist : hcjTmp.Histories) {
                if(hcjhist.Field == 'Template_Last_Modified__c' 
                   && (hcjhist.OldValue != hcjhist.NewValue) && (hcjhist.ParentId == hcjTmp.Id)) {
                    hcjTempIds.add(hcjTmp.Id);
                }
            }
        }
        System.debug('hcjTempIds ' +hcjTempIds);
        return Database.getQueryLocator([SELECT Name, Healthcare_Journey_Template__c, Last_Synced_Date__c FROM HealthCare_Journey__c 
                                         WHERE Journey_out_of_date__c = true AND Healthcare_Journey_Template__c IN :hcjTempIds]); 
        
        
    }
    
    public void execute(Database.BatchableContext bc, List<HealthCare_Journey__c> scope) {
        System.debug('#### UPDATED Scope Size ' + scope.size());

        List<HealthCare_Journey__c> hcjToUpdate = new List<HealthCare_Journey__c>();        
        for(HealthCare_Journey__c hcj : scope) {
            hcj.Last_Synced_Date__c = System.now();
            hcjToUpdate.add(hcj);
        }
        if(hcjToUpdate.size() > 0) {
            update hcjToUpdate;
        }
        
        
    }
    
    public void finish(Database.BatchableContext info) {
        System.debug('Done'); 
    }

}

@isTest
public class BatchHealthcareJourneyLastSyncedDateTest {
    
    @testSetup
    static void setup() {
        Indication__c ind = new Indication__c(Name = 'test Indication');
        insert ind;
        
        Account acc = new Account(Name = 'test Account');
        insert acc;
       
        Healthcare_Journey_Template__c hcjTemp = new Healthcare_Journey_Template__c(Name = 'testHcjTemplate', 
                                                                                    Template_Last_Modified__c = System.now().addDays(-1),                                                              
                                                                                    Indication__c = ind.Id);
        insert hcjTemp;
        
        Step_Master__c stpMaster = new Step_Master__c(Name = 'test Step Master');
        insert stpMaster;
        
        Sub_Step_Master__c subStpMaster = new Sub_Step_Master__c(Name = 'Bilan sanguin',
                                                                 Step_Master__c = stpMaster.Id);
        insert subStpMaster;
        
        Template_Step__c tstep = new Template_Step__c(Name = 'testTemplateStep', 
                                                      Step_Number__c = 1,
                                                      Step_Master__c = stpMaster.Id,
                                                      HealthCare_Journey_Template__c = hcjTemp.Id);
        insert tstep;
        
        Template_Sub_Step__c tsubstep = new Template_Sub_Step__c(Name = 'sub Step',
                                                                 Sub_Step_Number__c = 1,
                                                                 Sub_Step_Master__c = subStpMaster.Id,
                                                                 Template_Step__c = tstep.Id);
        insert tsubstep;
        
        List<Healthcare_Journey__c> hcjList = new List<Healthcare_Journey__c>();
        for(Integer i=0; i<200; i++) {
            hcjList.add(new Healthcare_Journey__c(Name = 'test journey ' +i, Last_Synced_Date__c = System.now().addDays(-1),
                                                  Healthcare_Journey_Template__c = hcjTemp.Id));
        }
        insert hcjList;
        
        List<Healthcare_Journey__c> hcjToUpdate = new List<Healthcare_Journey__c>();
        for(Healthcare_Journey__c hcj : hcjList) {
            hcj.Last_Synced_Date__c = System.now();
            hcjToUpdate.add(hcj);
        }
        update hcjToUpdate;
        
        Test.startTest();
        BatchHealthcareJourneyLastSyncedDateTest batchClass = new BatchHealthcareJourneyLastSyncedDateTest();
        batchClass.processTemplateUpdate(hcjTemp.Id);
        
       
        HealthCare_Journey_Template__History[] hcjHist = batchClass.retrieveTemplateHistory(hcjTemp.Id);
        Test.stopTest();
        System.debug('hcjHist History ' +hcjHist);
        System.assertEquals(1, hcjHist.size());
        
    }
    
    public void processTemplateUpdate(Id hcjTempId) {
        Healthcare_Journey_Template__c hcjTemp = new Healthcare_Journey_Template__c(Id = hcjTempId, Template_Last_Modified__c = System.now());
        update hcjTemp;
    }
    
    public HealthCare_Journey_Template__History[] retrieveTemplateHistory(Id hcjTempId) {
        List<HealthCare_Journey_Template__History> hcjHist;
        if(Test.isRunningTest()) {
            hcjHist = new List<HealthCare_Journey_Template__History>{}; //OldValue, NewValue not writeable
            hcjHist.add(new HealthCare_Journey_Template__History(ParentId = hcjTempId, Field = 'Template_Last_Modified__c'));
        } else 
            hcjHist = [SELECT ParentId, Field, NewValue, OldValue FROM HealthCare_Journey_Template__History
                       WHERE ParentId = :hcjTempId];
        
        return hcjHist;
    }
    
    @isTest static void test() {
        Test.startTest();
        BatchHealthcareJourneyLastSyncedDate hcj = new BatchHealthcareJourneyLastSyncedDate();
        Id batchId = Database.executeBatch(hcj);
        Test.stopTest();
    }


}

public class QueueableSubStepMaster implements Queueable, Database.AllowsCallouts {
    
    //class variable of type List
    private List<Sub_Step_Master__c> subStepMasterList;
    
    //Constructor
	public QueueableSubStepMaster(List<Sub_Step_Master__c> listSubStepMaster){
		this.subStepMasterList = listSubStepMaster;
	}
	
	public void execute(QueueableContext qc){
		for(Sub_Step_Master__c subStepMaster : subStepMasterList){
            //Map<String,String> layoutFieldMap = new Map<String,String>{'Sub_Step__c'=> 'String'}; to test batch (batch seems to work OK)!!!
			Map<String,String> layoutFieldMap = getFieldsOnLayoutForRecordType('Sub_Step__c',subStepMaster.RecordTypeName__c);
            subStepMaster.Layout_Field__c = prettyPrintLayoutFields(layoutFieldMap);
		}
		update subStepMasterList;
	}
    
    private String prettyPrintLayoutFields(Map<String,String> layoutFieldMap){
        
        //Print Map Key-Value pairs using toString();
        String result;
        result = layoutFieldMap.toString();
        
        //Print keys from Map using String.join(); //string.join(map.keyset(),',');
        /*String result = '';
        set<string> strSet = layoutFieldMap.keySet();
        List<String> StrList = new List<String>();
        StrList.addall(strSet);
        result = String.join(StrList , ',');*/
	
        System.debug('String result ' +result);
        return result;
    }
    
	private static Map<String,String> getFieldsOnLayoutForRecordType(String sobjectName, String recordTypeName){
		Map<String,String> result = new Map<String,String>();
		
		String url = system.URL.getSalesforceBaseUrl().toExternalForm() 
				   + '/services/data/v52.0/sobjects/'
				   + sObjectName
				   + '/describe/layouts/' 
				   + getRecordTypeId(sobjectName, recordTypeName);
        system.debug(url);
		httprequest req = buildRequest(url);
		try{
			http h = new http();
			httpresponse res = h.send(req);
			if(res.getStatusCode() == 200){
				result = getFieldsFromLayoutString(res.getBody());
			}
		}catch(exception ex){
			system.debug('ERROR: ' + ex.getMessage());
		}
		return result;
	}
	private static Map<String,String> getFieldsFromLayoutString(String jsonString){
		Map<String,String> result = new Map<String,String>();
        
        Map<String,Object> layoutMap = (Map<String,Object>)JSON.deserializeUntyped(jsonString);
        
        List<Map<String, Object>> data = new List<Map<String, Object>>();
        
		List<Object> detailSectionList = (List<Object>)layoutMap.get('detailLayoutSections'); //added H.O
        
		for(Object section : detailSectionList){
			Map<String,Object> sectionMap = (Map<String,Object>)section;
			for(Object sectionLayoutRow : (List<Object>)sectionMap.get('layoutRows')){
				Map<String,Object> sectionLayoutRowMap = (Map<String,Object>)sectionLayoutRow;
				for(Object liObject : (List<Object>)sectionLayoutRowMap.get('layoutItems')){
                    LayoutItem li = new LayoutItem((Map<String,Object>)liObject);
					String label = li.label;
					if(label != null && label != ''){
                        for(Object lc : li.layoutComponents){
                            Map<String,Object> lcMap = (Map<String,Object>)lc;
                            if((String)lcMap.get('type') == 'field'){
                            	String field = (String)lcMap.get('value');
                                result.put(field,label);
                            }
                        }
					}
				}
			}
		}
		return result;
	}
    
	private static String getRecordTypeId(String sobjectName, String recordTypeName){
        //use condition to avoid RecordType returning null
        if(Schema.getGlobalDescribe().get(sObjectName).getDescribe().getRecordTypeInfosByName().get(recordTypeName) != null) {
            return Schema.getGlobalDescribe().get(sObjectName).getDescribe().getRecordTypeInfosByName().get(recordTypeName).getRecordTypeId();

        } else {
            return null;
        }
	}

	private static HttpRequest buildRequest(String url){
		HttpRequest result = new HttpRequest();
		system.debug(url);
		result.setendpoint(url);
		result.setmethod('GET');
		result.setHeader('Authorization', 'OAuth ' + UserInfo.getSessionId());       
		result.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
		return result;
	}
	
	private class LayoutItem{
		public boolean editableForNew;
		public boolean editableForUpdate;
		public string label;
		public List<Object> layoutComponents;
		public boolean placeholder;
		public boolean required;
        
        public LayoutItem(Map<String,Object> liMap){
            editableForNew = (Boolean)liMap.get('editableForNew');
            editableForUpdate = (Boolean)liMap.get('editableForUpdate');
            label = (String)liMap.get('label');
            layoutComponents = (List<Object>)liMap.get('layoutComponents');
            placeholder = (Boolean)liMap.get('placeholder');
            required = (Boolean)liMap.get('required');
        }
	}
	
}

public class BatchSubStepMasterProcessor implements Schedulable, Database.Batchable<sObject> {
    
    public void execute(SchedulableContext sc) {
        Id batchProcessId = Database.executeBatch(this);
    }
    
    public Database.QueryLocator start(Database.BatchableContext bc) {
        return Database.getQueryLocator('SELECT Id, Name, Layout_Field__c, RecordTypeName__c FROM Sub_Step_Master__c');  
    }
    
    public void execute(Database.BatchableContext bc, List<Sub_Step_Master__c > scope) {
        System.enqueueJob(new QueueableSubStepMaster(new List<Sub_Step_Master__c>(scope)));
        System.debug('#### UPDATED Scope Size ' + scope.size());
    }
    
    public void finish(Database.BatchableContext info) {
       System.debug('Done'); 
    }

}

//Database.executeBatch(new BatchSubStepMasterProcessor());

<aura:component controller="ActionDescriptionFieldShowHideController" implements="flexipage:availableForRecordHome,force:hasRecordId" access="global" >
    
    <aura:attribute name="recordId" type="String"/>
    <aura:attribute name="actionRec" type="Action__c" default="{'sObjectType':'Action__c'}"/>
    <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
    <lightning:spinner alternativeText="Loading" size="large" aura:id="spinner" class="slds-hide" />
    
    <aura:attribute name="CurrentUser" type="Object"/>
    <force:recordData recordId="{!$SObjectType.CurrentUser.Id}"
                      fields="Profile.Name"
                      targetFields="{!v.CurrentUser}"/>
    
    
    <form class="slds-form_stacked">
    
        
    <aura:if isTrue="{!and(v.actionRec.Commercial__c == true, v.CurrentUser.Profile.Name == 'Sales')}">
        <lightning:textarea label="Description" name="desc" value="{!v.actionRec.Description__c }"/>  
        <aura:set attribute="else">
            <aura:if isTrue="{!and(v.actionRec.Commercial__c == true, v.CurrentUser.Profile.Name != 'Sales')}">
                <lightning:textarea label="Description" name="desc" disabled="true" value="{!v.actionRec.Description__c }"/> 
            </aura:if>
        </aura:set>  
    </aura:if>
        
    <footer class="slds-modal__footer">
        <lightning:button variant="brand"
                          label="Save"
                          title="Save"
                          onclick="{! c.actionSave}" />
    </footer>
    </form>
</aura:component>

private String prettyPrintLayoutFields(Map<String,String> layoutFieldMap){
        String result;
        result = layoutFieldMap.toString(); 
        System.debug('String result ' +result);
        return result;
    }

{Performance_Level__c=Performance Level, CreatedById=Created By, CreatedDate=Created By, LastModifiedById=Last Modified By, LastModifiedDate=Last Modified By, Name=Sub-Step Name, Level_of_details__c=Level of details, OwnerId=Owner, RecordTypeId=Record Type, ...}

string.join(map.keyset(),',');

Hello,
I am getting a System null pointer because of the RecordTypeId.
Could someone help me understand why I can't insert the record.
Thanks

 

List<Sub_Step__c> subStepList = new List<Sub_Step__c>();
        for(List<Template_Step__c> tStepList : hcJvsTempStepMap.values()) {
            for(Template_Step__c tStep : tStepList ){
                for(Template_Sub_Step__c temSubStepInst : tstep.Template_Sub_Steps__r){
                    subStepList.add(new Sub_Step__c(Name=temSubStepInst.Sub_Step_Master__r.Name,
                                                    RecordTypeId = Schema.SObjectType.Sub_Step__c.getRecordTypeInfosByName().get(temSubStepInst.Sub_Step_Master__r.Name).getRecordTypeId(),
                                                    Sub_Step_Number__c = temSubStepInst.Sub_Step_Number__c,
                                                    Step__c =tempStepIdvsStepMap.get(tStep.id).Id,
                                                    Template_Sub_Step__c = temSubStepInst.Id));
                }

            }
        }
        
        if(!subStepList.isEmpty())
           insert subStepList;

trigger AccountRelationsTrigger on Account_Relation__c (before insert, after insert) {
    
    
    if(Trigger.isAfter) {
       if(!AccountRelationHandler.isRecursion)
    	AccountRelationHandler.createAccountRelation(Trigger.New); 
    }
    
    if(Trigger.isBefore && Trigger.isInsert) {
        Set<Id> relatedAccIds = new Set<Id>();
        for(Account_Relation__c ar : Trigger.New) {
            relatedAccIds.add(ar.Related_Account__c);
        }
        List<Account_Relation__c> arList = [SELECT Related_Account__c FROM Account_Relation__c WHERE Related_Account__c = :relatedAccIds];
                                           
        
        for(Account_Relation__c relAcc : Trigger.New) {
            if(arList.size() > 0) {
                relAcc.Related_Account__c.addError('A relation already exists between the 2 Accounts');
            }
        }
     	
    }
    
}

public class AccountRelationHandler {
    
    public static Boolean isRecursion = false;
    public static void createAccountRelation(List<Account_Relation__c> accRelationList) {
        // We are creating the inverse records, so return now
        if(isRecursion) {
            return;
        }
        isRecursion = true;
        
        Map<Id, Account> accRelatedToAccount = new Map<Id, Account>(
        [SELECT Id, Name, (SELECT Account__c, Related_Account__c FROM Account_Relations__r) 
         FROM Account]);
        
        Account_Relation__c[] newRelations = new Account_Relation__c[0];
        for(Account_Relation__c acc : accRelationList) {
            newRelations.add(new Account_Relation__c(Name=acc.Name, Account__c=acc.Related_Account__c, Related_Account__c=acc.Account__c));
        
        }
        insert newRelations;
        isRecursion = false;
        
    }
}

Hello,
I am trying to write a trigger to stop user creating contact with the same email address. But I keep getting an error
 System.NullPointerException: Attempt to de-reference a null object
on line 8 for:

conMap.get(c.Id).Email

trigger ContactDuplicate on Contact (before insert) {
    
    Map<Id, Contact> conMap = new Map<Id, Contact>([SELECT Id, Email FROM Contact WHERE Email != null]);
    System.debug('Map ' +conMap);
      
    if(Trigger.isBefore && Trigger.isInsert) {
        for(Contact c : Trigger.New) {
            if(c.Email != null && c.Email == conMap.get(c.Id).Email) {
                c.Email.addError('Duplicate Contact');
            }
        }
    }
}

Hello,
I wrote a batch and I am trying to reference a Set<Id> in the WHERE clause but I have an error:
System.QueryException: expecting a colon, found '{kA09E0000005mCySAI}'

How can I fix the error and reference my Set kesIds in the Dynamic SOQL?
Thanks

global class BatchArticleEmail implements Schedulable, Database.Batchable<SObject> {
    
    global string query;
    
    // To schedule batch 
    global void execute(SchedulableContext sc) {
		Id batchProcessId = Database.executeBatch(this);
	}

    // Constructor to query articles
    global BatchArticleEmail() {
        
        Set<Id> kesIds = new Set<Id>();
       
        List<Known_Error_Subscription__c> kesList = [SELECT KnowledgeKA__c FROM Known_Error_Subscription__c];
        for(Known_Error_Subscription__c kes : kesList) {
            kesIds.add(kes.KnowledgeKA__c);
        }
        
        query = 'Select Id, KnowledgeArticleId, Known_Error_Status__c FROM Knowledge__kav WHERE PublishStatus=\'Online\'' + 
                ' AND KnowledgeArticleId IN \''+kesIds+'\'';     
        System.debug('query BatchArticleEmail ' +query);
    }

trigger Knowledge_kavTrigger on Knowledge__kav (after update) {
    
    List<Known_Error_Subscription__c> kesListToDelete = new List<Known_Error_Subscription__c>();
    
    for(Knowledge__kav kav : [SELECT KnowledgeArticleId, PublishStatus, (SELECT Knowledge__c FROM Known_Errors_Subscriptions__r) FROM Knowledge__kav 
             WHERE PublishStatus = 'Archived' AND Id IN :Trigger.New]) {
                 
        kesListToDelete.add(kav.Known_Errors_Subscriptions__r);
       
    }
    delete kesListToDelete;
    
}

trigger Knowledge_kavKnownErrorSubscription on Knowledge__kav (after insert, after update) {
    
    List<Known_Error_Subscription__c> kesList = new List<Known_Error_Subscription__c>();
    
    for(Knowledge__kav kav : [SELECT KnowledgeArticleId, Known_Error_Status__c, VersionNumber, (SELECT Knowledge__c FROM Known_Errors_Subscriptions__r)
                              FROM Knowledge__kav WHERE Id IN :Trigger.New]) {
                                                                              
            if(kav.KnowledgeArticleId != null && (Trigger.oldMap.get(kav.Id).LastPublishedDate != Trigger.newMap.get(kav.Id).LastPublishedDate)) {
            Known_Error_Subscription__c kes = kav.Known_Errors_Subscriptions__r;
            kes.Knowledge__c = kav.KnowledgeArticleId;
            kesList.add(kes);
            
        }
                                  
    }
    if(kesList.size() > 0) {
        update kesList;
    }
    

}

<aura:component controller="KnownErrorSubscriptionController" implements="forceCommunity:availableForAllPageTypes,flexipage:availableForAllPageTypes,force:hasRecordId" access="global">

<aura:attribute name="recordId" type="String"/>
    <aura:attribute name="isFollowed" type="Boolean" default="false"/>
    <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
    
    <lightning:buttonStateful
        labelWhenOff="Subscribe"
        labelWhenOn="Subscribed"
        labelWhenHover="Unsubscribe"
        iconNameWhenOff="utility:add"
        iconNameWhenOn="utility:check"
        iconNameWhenHover="utility:close"
        state="{! v.isFollowed }"
        onclick="{! c.handleClick }"/>
	
</aura:component>

({
       doInit: function(component, event, helper) {
             let search = window.location.pathname;
             let result = search.substring(search.lastIndexOf("/") + 1);
             let action = component.get("c.isRecordExist");

             action.setParams({
                     urlNames : result
              });
              action.setCallback(this, function(data) {
                    let result = data.getReturnValue();
                     if(result){
                         component.set('v.isFollowed', 'true');
                      }
             });
             $A.enqueueAction(action);
         },

         handleClick : function(component, event, helper) {

              let search = window.location.pathname;
              let result = search.substring(search.lastIndexOf("/") + 1);
              let action = component.get("c.saveKnownIssue");
              
             action.setParams({
                  urlNames : result
             });

             action.setCallback(this, function(data) {
                  let result = data.getReturnValue();
                  if(result){
                        component.set('v.isFollowed', 'true');
                    }
              });
             $A.enqueueAction(action);
       }
})

public class KnownErrorSubscriptionController {
    
    @AuraEnabled
    public static Boolean isRecordExist(String urlNames) {
        List<User> userList = [SELECT Id, Name, ContactId, Contact.Name FROM User WHERE Id = :UserInfo.getUserId()];
        List<Knowledge__kav> kavList = new List<Knowledge__kav>();
        if(urlNames != null) {
            kavList = [SELECT Id, LastPublishedDate, Title, ArticleBody__c FROM Knowledge__kav WHERE UrlName =:urlNames];
        }
        
        if(userList.size() > 0 && kavList.size() > 0) {
        	List<Known_Error_Subscription__c> kESubscriptionList = [SELECT Contact__c, Knowledge__c FROM Known_Error_Subscription__c
                                                                    WHERE Contact__c =:userList[0].ContactId AND Knowledge__c =:kavList[0].Id];
            if(kESubscriptionList.size() > 0) {
            	return true;
            } else {
            	return false;
            }
                
        } else {
        	return false;
        }        
    } 
    
    @AuraEnabled
    public static Boolean saveKnownIssue(String urlNames, Boolean isFollowed) {
        List<User> userList = [SELECT Id, Name, ContactId, Contact.Name FROM User WHERE Id =:UserInfo.getUserId()];
        List<Knowledge__kav> kavList = new List<Knowledge__kav>();
        
        if(urlNames != null) {
            kavList = [SELECT Id, LastPublishedDate, Title, ArticleBody__c FROM Knowledge__kav WHERE UrlName =:urlNames];
        }
        Known_Error_Subscription__c kes = new Known_Error_Subscription__c();
        if(userList.size() > 0 && userList[0].ContactId != null) {
            kes.Contact__c = userList[0].ContactId;
        }
        
        if(kavList.size() > 0) {
            kes.Knowledge__c = kavList[0].Id;
            kes.Subscribed__c = true;
        }
        
        insert kes;
        return true;
        
    }
    

}

public static String setSlackUserNickName(String businessUnit) {
        String channelName;
        Set<ID> headOfService_ids = new Set<ID>();
        
        Map<Id, Application_Parameters__c> headOfService = New Map<Id, Application_Parameters__c>(
            [SELECT Id, Head_of_Service__c FROM Application_Parameters__c WHERE Business_Unit__c = :businessUnit]);
     
        for(Application_Parameters__c app : headOfService.values()) {
            headOfService_ids.add(app.Head_of_Service__c);
        }
       
         
        channelName = ''+headOfService_ids.get(Id).CommunityNickname+'';

public without sharing class SlackNotificationSupport{
       
    public class slackRequest { 
        @InvocableVariable(label='caseNumber')
        public String caseNumber;
        @InvocableVariable(label='status')
        public String status;
        @InvocableVariable(label='nickName')
        public String nickname;
        @InvocableVariable(label='queue')
        public String queue;
        @InvocableVariable(label='accountTier')
        public String accountTier;
        @InvocableVariable(label='accountName')
        public String accountName;
        @InvocableVariable(label='subject')
        public String subject;
        @InvocableVariable(label='businessUnit')
    	public String businessUnit;
    } 
    

    public static String setChannelName(String queue) {

        String channelName;

        channelName = '#'+queue;
        channelName = channelName.toLowerCase('en');
        channelName = channelName.replaceAll('queue', 'bot');
        channelName = channelName.replaceAll('[_]', '-');
        return channelName;
    }

    @InvocableMethod(label='Publish to Slack')
    public static void publishToSlack(List<slackRequest> requests) {

        String webhookURL = system.label.Param_Slack_Token;
        String msg;
        String channelName;

        for(slackRequest r:requests){

            if (r.queue == 'internal'){
                System.debug('### SlackNotificationSupport new internal case');
                channelName = '#'+Label.Slack_Internal_Case_Channel;
                msg = 'A new internal case has been created : *'+r.caseNumber+'* - By User : (*'+r.accountName+'*) - Subject : (*'+r.subject+'*)';                
            }
            else if (r.queue == 'caseconcern'){
                System.debug('### SlackNotificationSupport new case concern');
                channelName = '#'+Label.Slack_Case_Concern_Channel;
                
                msg = 'A new Case Concern has been created : *'+r.caseNumber+'* - By User : (*'+r.nickName+' '+r.accountName+'* From *'+r.accountTier+'*) - Category : (*'+r.subject+'*)';
				msg += '\nLink to Case Concern : '+URL.getOrgDomainUrl().toExternalForm()+'/'+r.status;
                
            }
            // Team Leads
            else if (r.queue == 'Queue Team Leads') {
                channelName = setChannelName(r.queue);
                msg = 'A customer has opened a new case.\n>>>*'+
                    r.caseNumber+'* - '+r.subject;
                    System.debug('### SlackNotificationSupport Queue Team Leads');
            } // New Tier 1 Ticker
            else if (r.accountTier == 'Tier 1' && r.accountName != null && r.queue != null) {
                System.debug('### SlackNotificationSupport New Tier 1');
                channelName = setChannelName(r.queue);
                msg = 'The customer '+r.accountTier+' - *'+r.accountName+'* has opened a new case.\n>>>*'+
                    r.caseNumber+'* - '+r.subject;
            }// Assigned ticket, status to Open - Internal notification for awaiting feedback cases
            else if (r.nickname != null && r.status != null && r.caseNumber != null) {
                System.debug('### SlackNotificationSupport  Status x to Open');
                channelName = '@'+r.nickname;
                if(r.queue == 'internal_notification')msg = 'Salesforce Internal Case number *'+r.caseNumber+'* related to : *'+r.subject+'* - Status changed to : *'+r.status+'*.';
                else msg = 'Case number *'+r.caseNumber+'* has become '+r.status+'.';
            }

            // Generate JSON for request
            try {
                if (r.queue != null || r.nickname != null) {
                    System.debug('### SlackNotificationSupport Sending message');
                    JSONGenerator gen = JSON.createGenerator(true);
                    gen.writeStartObject(); //Inserts {
                    gen.writeStringField('text', msg);
                    gen.writeStringField('channel', channelName);
                    gen.writeStringField('username', 'bot-support');
                    gen.writeStringField('icon_emoji', ':smartplus:');
                    gen.writeEndObject(); //Inserts }
                    String body = gen.getAsString(); //Translates JSONGenerator to string to be passed to callout
                    System.debug('### SlackNotificationSupport body: '+ body);
                    System.enqueueJob(new qCallOut(webhookURL, 'POST', body)); // Send request
                }
                else {
                    System.debug('### SlackNotificationSupport Queue = '+ r.queue);
                    return;
                }
            } // try    
            catch (exception e){
                system.debug('### SlackNotificationSupport error:' + e);
            }
        } 
    }
   

    public class qCallOut implements System.Queueable, Database.AllowsCallouts {
         
        private final String url;
        private final String method;
        private final String body;
         
        public qCallOut(String url, String method, String body) {
            this.url = url;
            this.method = method;
            this.body = body;
        }
         
        public void execute(System.QueueableContext ctx) {
            HttpRequest req = new HttpRequest();
            req.setEndpoint(url);
            req.setMethod(method);
            req.setBody(body);
            Http http = new Http();
            // to pass when process builder is invoked by another test class
            if(!Test.isRunningTest()){  
              HttpResponse res = http.send(req);
            }
        }
    }
}

Hello,
I am trying to include a Case Number of an email template for an email-to-case.
Basically, when a client sent an email to a closed case, he received an automatic email reply.
On the template I have added the merge field value {!Case.CaseNumber}
but the Case Number does not appear on the email reply sent to the client



I believe that, to add the Case Number in the automatic email reply, I need to reference the CaseId somewhere in my code. But I have figured out how.
The tried to do 

mail.setTargetObjectId(c.Id);

public class EmailManager {
    @future
    public static void sendEmailToCaseDeactivated(Set<Id> caseIds){
    
        List<Messaging.SingleEmailMessage> allmsg = new List<Messaging.SingleEmailMessage>();
        List<Case> lstCase = [SELECT Id, Status,ContactEmail FROM Case WHERE 
                              Status = 'Closed' AND
                              ContactEmail != Null AND
                              Id IN: caseIds];
        EmailTemplate templateId = [SELECT Id FROM EmailTemplate WHERE DeveloperName =:'Email_to_Case_Closed'];
       
        for(Case c : lstCase) {
            Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
            mail.setTargetObjectId(UserInfo.getUserId());
            mail.setTemplateId(templateId.Id);
            String[] sendingTo = new String[]{c.ContactEmail}; 
            mail.setToAddresses(sendingTo); 
            mail.setSaveAsActivity(false);
            allmsg.add(mail);
        }               
        Messaging.sendEmail(allmsg, false);
    }
    
}

trigger IncomingEmailClosedCase on EmailMessage (before insert,after insert) {
    
    if(trigger.isBefore) { 
        Set<Id> sCaseIds = new Set<Id>();
        for(EmailMessage em: Trigger.New) {
            if (em.Incoming)
                 sCaseIds.add(em.parentId);   
        }
        if(!sCaseIds.isEmpty())
            EmailManager.sendEmailToCaseDeactivated(sCaseIds);
    }
    if(trigger.isAfter){
        Map<Id,Id> caseIdsToEmailMessageIds = new Map<Id,Id>();
        for(EmailMessage em: Trigger.New) {
            if (em.Incoming)
                caseIdsToEmailMessageIds.put(em.parentId,em.Id);   
        }
        set<Id> sMessageIdsToDelete = new Set<Id>();
        if(caseIdsToEmailMessageIds.isEmpty()) return;
        for(Case lstCase : [SELECT Id, Status,ContactEmail FROM Case WHERE 
                          Status = 'Closed' AND
                          ContactEmail != Null AND
                          Id IN: caseIdsToEmailMessageIds.keyset()]){
            if(caseIdsToEmailMessageIds.containsKey(lstCase.Id)){
                Id emId = caseIdsToEmailMessageIds.get(lstCase.Id);
                sMessageIdsToDelete.add(emId);
            } 
        } 
        if(!sMessageIdsToDelete.isEmpty())   delete [ select Id from EmailMessage where id in :sMessageIdsToDelete];
    }
}

public class EmailManager {
@future
public static void sendEmailToCaseDeactivated(Set<Id> caseIds){

    List<Messaging.SingleEmailMessage> allmsg = new List<Messaging.SingleEmailMessage>();
    List<Case> lstCase = [SELECT Id, Status,ContactEmail FROM Case WHERE 
                          Status = 'Closed' AND
                          ContactEmail != Null AND
                          Id IN: caseIds];
    EmailTemplate templateId = [SELECT Id FROM EmailTemplate WHERE DeveloperName =:'Smart_Community_Email_to_Case_Deactivated'];
   
    for(Case cas :  lstCase) {
        Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
        mail.setTargetObjectId(UserInfo.getUserId());
        mail.setTemplateId(templateId.Id);
        String[] sendingTo = new String[]{cas.ContactEmail}; 
        mail.setToAddresses(sendingTo); 
        mail.setSaveAsActivity(false);
        allmsg.add(mail);
    }               
    Messaging.sendEmail(allmsg, false);
}

}

trigger IncomingEmailClosedCase on EmailMessage (before insert,after insert) {

if(trigger.isBefore) { 
    Set<Id> caseIds = new Set<Id>();
    for(EmailMessage em: Trigger.New) {
        if (em.Incoming)
             caseIds.add(em.parentId);   
    }
    if(!caseIds.isEmpty())
        EmailManager.sendEmailToCaseDeactivated(caseIds);
}
if(trigger.isAfter){
    Map<Id,Id> mapOfCaseVsEM = new Map<Id,Id>();
    for(EmailMessage em: Trigger.New) {
        if (em.Incoming)
            mapOfCaseVsEM.put(em.parentId,em.Id);   
    }
    set<Id> todeleteEM = new Set<Id>();
    if(mapOfCaseVsEM.isEmpty()) return;
    for(Case lstCase : [SELECT Id, Status,ContactEmail FROM Case WHERE 
                      Status = 'Closed' AND
                      ContactEmail != Null AND
                      Id IN: mapOfCaseVsEM.keyset()]){
        if(mapOfCaseVsEM.containsKey(lstCase.Id)){
            Id emId = mapOfCaseVsEM.get(lstCase.Id);
            todeleteEM.add(emId);
        } 
    } 
    if(!todeleteEM.isEmpty())   delete [ select Id from EmailMessage where id in :todeleteEM];
}
}

<aura:component implements="flexipage:availableForRecordHome,force:hasRecordId" access="global" >
    
    <aura:attribute name="recordId" type="Id"/>
    
    
     <lightning:recordViewForm recordId="{!v.recordId}" objectApiName="Account">
        <div class="slds-box slds-theme_default">
            <lightning:outputField fieldName="Tip_To_Smarties__c" />
        </div>
    </lightning:recordViewForm>
    
</aura:component>

Hello, 
I am trying to create a trigger to stop clients from sending emails on Case closed. But it doesn't work.
Could someone help?
Thanks,

Apex Class:

public class EmailManager {
    
    public static void sendEmailToCaseDeactivated(){
        
        //Use classic email template
        EmailTemplate templateId = [SELECT Id FROM EmailTemplate WHERE DeveloperName =:'Smart_Community_Email_to_Case_Deactivated'];
        List<Messaging.SingleEmailMessage> allmsg = new List<Messaging.SingleEmailMessage>();
        Messaging.SingleEmailMessage mail = new Messaging.SingleEmailMessage();
        
        mail.setTargetObjectId(UserInfo.getUserId());
        mail.setTemplateId(templateId.Id);
        mail.setSaveAsActivity(false);
        allmsg.add(mail);
        
        Messaging.sendEmail(allmsg, false);
        
    }
        
}

trigger IncomingEmailClosedCase on EmailMessage (before insert) {
   
    Set<Id> caseIds = new Set<Id>();
    
    for(EmailMessage em: Trigger.New) {
        if (em.Incoming == true) caseIds.add(em.Id);   
    }
    
    List<Case> lstCase = new List<Case>([SELECT Id, Status FROM Case WHERE Status = 'Closed' AND Id In: caseIds]);
    
    if(lstCase.size() > 0) {
        EmailManager.sendEmailToCaseDeactivated();
    }
   
}

Map<Id, Case> caseMap = new Map<Id, Case>([SELECT Id, First_JIRA_Issue_Number__c, (SELECT Id FROM Knowledge__kavs) FROM Case WHERE Id IN :caseIdJiraIssueId.keyset()]);

Hello,

I have a lookup field (First_JIRA_Issue_Number__c) on Case object that needs to be updated with the Jira Number when the related issue is created.

Basically from a Case, I have the possibility to create a Jira Issue (object: JIRA_Issue__c).


When the Jira Issue is created, the field First_JIRA_Issue_Number__c needs to be updated with the Jira Number. In this example the field First Jira Issue Number on Case is updated with JIRA000692


I have created a class and a trigger but it does work.
Could someone help.
Thanks

Apex Class

public class CaseManager {
    
    public static void updateJiraIssue(List<JIRA_Issue__c> lstJira) {
        Set<Id> jiraIds = new Set<Id>();
       
        for(JIRA_Issue__c jissue : lstJira){
            if(jissue.Case__c != null){
                jiraIds.add(jissue.Id);  
            }
        }
        
        List<Case> lstCase = new List<Case>([SELECT Id, First_JIRA_Issue_Number__c,(SELECT Id, Case__c FROM JIRA_Issues__r) FROM Case WHERE First_JIRA_Issue_Number__c IN: jiraIds]);
        System.debug('##### lstCase ' + lstCase.Size());
        
        if(lstCase.size()>0){
            for(Case c: lstCase){
                List<JIRA_Issue__c> lstJiraIssue = new List<JIRA_Issue__c>();
                lstJiraIssue = c.JIRA_Issues__r;
                if(lstJiraIssue.size() > 0){
                    for(JIRA_Issue__c ji: lstJiraIssue){
                        if(ji.Case__c == c.Id){
                            c.First_JIRA_Issue_Number__c = ji.Id;
                        }
                        
                    }
                    
                }
    
       		}
            update lstCase;
        }
        
      
    }

}

trigger CaseJiraIssueNumber on JIRA_Issue__c (after insert) {
    if(trigger.isAfter){
        CaseManager.updateJiraIssue(Trigger.New);
    }

}

public class QueueableSubStepMaster implements Queueable, Database.AllowsCallouts {
    
    //class variable of type List
    private List<Sub_Step_Master__c> subStepMasterList;
    
    //Constructor
	public QueueableSubStepMaster(List<Sub_Step_Master__c> listSubStepMaster){
		this.subStepMasterList = listSubStepMaster;
	}
	
	public void execute(QueueableContext qc){
		for(Sub_Step_Master__c subStepMaster : subStepMasterList){
            //Map<String,String> layoutFieldMap = new Map<String,String>{'Sub_Step__c'=> 'String'}; to test batch (batch seems to work OK)!!!
			Map<String,String> layoutFieldMap = getFieldsOnLayoutForRecordType('Sub_Step__c',subStepMaster.RecordTypeName__c);
            subStepMaster.Layout_Field__c = prettyPrintLayoutFields(layoutFieldMap);
		}
		update subStepMasterList;
	}
    
    private String prettyPrintLayoutFields(Map<String,String> layoutFieldMap){
        
        //Print Map Key-Value pairs using toString();
        String result;
        result = layoutFieldMap.toString();
        
        //Print keys from Map using String.join(); //string.join(map.keyset(),',');
        /*String result = '';
        set<string> strSet = layoutFieldMap.keySet();
        List<String> StrList = new List<String>();
        StrList.addall(strSet);
        result = String.join(StrList , ',');*/
	
        System.debug('String result ' +result);
        return result;
    }
    
	private static Map<String,String> getFieldsOnLayoutForRecordType(String sobjectName, String recordTypeName){
		Map<String,String> result = new Map<String,String>();
		
		String url = system.URL.getSalesforceBaseUrl().toExternalForm() 
				   + '/services/data/v52.0/sobjects/'
				   + sObjectName
				   + '/describe/layouts/' 
				   + getRecordTypeId(sobjectName, recordTypeName);
        system.debug(url);
		httprequest req = buildRequest(url);
		try{
			http h = new http();
			httpresponse res = h.send(req);
			if(res.getStatusCode() == 200){
				result = getFieldsFromLayoutString(res.getBody());
			}
		}catch(exception ex){
			system.debug('ERROR: ' + ex.getMessage());
		}
		return result;
	}
	private static Map<String,String> getFieldsFromLayoutString(String jsonString){
		Map<String,String> result = new Map<String,String>();
        
        Map<String,Object> layoutMap = (Map<String,Object>)JSON.deserializeUntyped(jsonString);
        
        List<Map<String, Object>> data = new List<Map<String, Object>>();
        
		List<Object> detailSectionList = (List<Object>)layoutMap.get('detailLayoutSections'); //added H.O
        
		for(Object section : detailSectionList){
			Map<String,Object> sectionMap = (Map<String,Object>)section;
			for(Object sectionLayoutRow : (List<Object>)sectionMap.get('layoutRows')){
				Map<String,Object> sectionLayoutRowMap = (Map<String,Object>)sectionLayoutRow;
				for(Object liObject : (List<Object>)sectionLayoutRowMap.get('layoutItems')){
                    LayoutItem li = new LayoutItem((Map<String,Object>)liObject);
					String label = li.label;
					if(label != null && label != ''){
                        for(Object lc : li.layoutComponents){
                            Map<String,Object> lcMap = (Map<String,Object>)lc;
                            if((String)lcMap.get('type') == 'field'){
                            	String field = (String)lcMap.get('value');
                                result.put(field,label);
                            }
                        }
					}
				}
			}
		}
		return result;
	}
    
	private static String getRecordTypeId(String sobjectName, String recordTypeName){
        //use condition to avoid RecordType returning null
        if(Schema.getGlobalDescribe().get(sObjectName).getDescribe().getRecordTypeInfosByName().get(recordTypeName) != null) {
            return Schema.getGlobalDescribe().get(sObjectName).getDescribe().getRecordTypeInfosByName().get(recordTypeName).getRecordTypeId();

        } else {
            return null;
        }
	}

	private static HttpRequest buildRequest(String url){
		HttpRequest result = new HttpRequest();
		system.debug(url);
		result.setendpoint(url);
		result.setmethod('GET');
		result.setHeader('Authorization', 'OAuth ' + UserInfo.getSessionId());       
		result.setHeader('Authorization', 'Bearer ' + UserInfo.getSessionID());
		return result;
	}
	
	private class LayoutItem{
		public boolean editableForNew;
		public boolean editableForUpdate;
		public string label;
		public List<Object> layoutComponents;
		public boolean placeholder;
		public boolean required;
        
        public LayoutItem(Map<String,Object> liMap){
            editableForNew = (Boolean)liMap.get('editableForNew');
            editableForUpdate = (Boolean)liMap.get('editableForUpdate');
            label = (String)liMap.get('label');
            layoutComponents = (List<Object>)liMap.get('layoutComponents');
            placeholder = (Boolean)liMap.get('placeholder');
            required = (Boolean)liMap.get('required');
        }
	}
	
}

public class BatchSubStepMasterProcessor implements Schedulable, Database.Batchable<sObject> {
    
    public void execute(SchedulableContext sc) {
        Id batchProcessId = Database.executeBatch(this);
    }
    
    public Database.QueryLocator start(Database.BatchableContext bc) {
        return Database.getQueryLocator('SELECT Id, Name, Layout_Field__c, RecordTypeName__c FROM Sub_Step_Master__c');  
    }
    
    public void execute(Database.BatchableContext bc, List<Sub_Step_Master__c > scope) {
        System.enqueueJob(new QueueableSubStepMaster(new List<Sub_Step_Master__c>(scope)));
        System.debug('#### UPDATED Scope Size ' + scope.size());
    }
    
    public void finish(Database.BatchableContext info) {
       System.debug('Done'); 
    }

}

//Database.executeBatch(new BatchSubStepMasterProcessor());

<aura:component controller="ActionDescriptionFieldShowHideController" implements="flexipage:availableForRecordHome,force:hasRecordId" access="global" >
    
    <aura:attribute name="recordId" type="String"/>
    <aura:attribute name="actionRec" type="Action__c" default="{'sObjectType':'Action__c'}"/>
    <aura:handler name="init" value="{!this}" action="{!c.doInit}"/>
    <lightning:spinner alternativeText="Loading" size="large" aura:id="spinner" class="slds-hide" />
    
    <aura:attribute name="CurrentUser" type="Object"/>
    <force:recordData recordId="{!$SObjectType.CurrentUser.Id}"
                      fields="Profile.Name"
                      targetFields="{!v.CurrentUser}"/>
    
    
    <form class="slds-form_stacked">
    
        
    <aura:if isTrue="{!and(v.actionRec.Commercial__c == true, v.CurrentUser.Profile.Name == 'Sales')}">
        <lightning:textarea label="Description" name="desc" value="{!v.actionRec.Description__c }"/>  
        <aura:set attribute="else">
            <aura:if isTrue="{!and(v.actionRec.Commercial__c == true, v.CurrentUser.Profile.Name != 'Sales')}">
                <lightning:textarea label="Description" name="desc" disabled="true" value="{!v.actionRec.Description__c }"/> 
            </aura:if>
        </aura:set>  
    </aura:if>
        
    <footer class="slds-modal__footer">
        <lightning:button variant="brand"
                          label="Save"
                          title="Save"
                          onclick="{! c.actionSave}" />
    </footer>
    </form>
</aura:component>

trigger AccountRelationsTrigger on Account_Relation__c (before insert, after insert) {
    
    
    if(Trigger.isAfter) {
       if(!AccountRelationHandler.isRecursion)
    	AccountRelationHandler.createAccountRelation(Trigger.New); 
    }
    
    if(Trigger.isBefore && Trigger.isInsert) {
        Set<Id> relatedAccIds = new Set<Id>();
        for(Account_Relation__c ar : Trigger.New) {
            relatedAccIds.add(ar.Related_Account__c);
        }
        List<Account_Relation__c> arList = [SELECT Related_Account__c FROM Account_Relation__c WHERE Related_Account__c = :relatedAccIds];
                                           
        
        for(Account_Relation__c relAcc : Trigger.New) {
            if(arList.size() > 0) {
                relAcc.Related_Account__c.addError('A relation already exists between the 2 Accounts');
            }
        }
     	
    }
    
}

public class AccountRelationHandler {
    
    public static Boolean isRecursion = false;
    public static void createAccountRelation(List<Account_Relation__c> accRelationList) {
        // We are creating the inverse records, so return now
        if(isRecursion) {
            return;
        }
        isRecursion = true;
        
        Map<Id, Account> accRelatedToAccount = new Map<Id, Account>(
        [SELECT Id, Name, (SELECT Account__c, Related_Account__c FROM Account_Relations__r) 
         FROM Account]);
        
        Account_Relation__c[] newRelations = new Account_Relation__c[0];
        for(Account_Relation__c acc : accRelationList) {
            newRelations.add(new Account_Relation__c(Name=acc.Name, Account__c=acc.Related_Account__c, Related_Account__c=acc.Account__c));
        
        }
        insert newRelations;
        isRecursion = false;
        
    }
}

Hello,
I wrote a batch and I am trying to reference a Set<Id> in the WHERE clause but I have an error:
System.QueryException: expecting a colon, found '{kA09E0000005mCySAI}'

How can I fix the error and reference my Set kesIds in the Dynamic SOQL?
Thanks

global class BatchArticleEmail implements Schedulable, Database.Batchable<SObject> {
    
    global string query;
    
    // To schedule batch 
    global void execute(SchedulableContext sc) {
		Id batchProcessId = Database.executeBatch(this);
	}

    // Constructor to query articles
    global BatchArticleEmail() {
        
        Set<Id> kesIds = new Set<Id>();
       
        List<Known_Error_Subscription__c> kesList = [SELECT KnowledgeKA__c FROM Known_Error_Subscription__c];
        for(Known_Error_Subscription__c kes : kesList) {
            kesIds.add(kes.KnowledgeKA__c);
        }
        
        query = 'Select Id, KnowledgeArticleId, Known_Error_Status__c FROM Knowledge__kav WHERE PublishStatus=\'Online\'' + 
                ' AND KnowledgeArticleId IN \''+kesIds+'\'';     
        System.debug('query BatchArticleEmail ' +query);
    }

trigger Knowledge_kavTrigger on Knowledge__kav (after update) {
    
    List<Known_Error_Subscription__c> kesListToDelete = new List<Known_Error_Subscription__c>();
    
    for(Knowledge__kav kav : [SELECT KnowledgeArticleId, PublishStatus, (SELECT Knowledge__c FROM Known_Errors_Subscriptions__r) FROM Knowledge__kav 
             WHERE PublishStatus = 'Archived' AND Id IN :Trigger.New]) {
                 
        kesListToDelete.add(kav.Known_Errors_Subscriptions__r);
       
    }
    delete kesListToDelete;
    
}

trigger Knowledge_kavKnownErrorSubscription on Knowledge__kav (after insert, after update) {
    
    List<Known_Error_Subscription__c> kesList = new List<Known_Error_Subscription__c>();
    
    for(Knowledge__kav kav : [SELECT KnowledgeArticleId, Known_Error_Status__c, VersionNumber, (SELECT Knowledge__c FROM Known_Errors_Subscriptions__r)
                              FROM Knowledge__kav WHERE Id IN :Trigger.New]) {
                                                                              
            if(kav.KnowledgeArticleId != null && (Trigger.oldMap.get(kav.Id).LastPublishedDate != Trigger.newMap.get(kav.Id).LastPublishedDate)) {
            Known_Error_Subscription__c kes = kav.Known_Errors_Subscriptions__r;
            kes.Knowledge__c = kav.KnowledgeArticleId;
            kesList.add(kes);
            
        }
                                  
    }
    if(kesList.size() > 0) {
        update kesList;
    }
    

}

<aura:component implements="flexipage:availableForRecordHome,force:hasRecordId" access="global" >
    
    <aura:attribute name="recordId" type="Id"/>
    
    
     <lightning:recordViewForm recordId="{!v.recordId}" objectApiName="Account">
        <div class="slds-box slds-theme_default">
            <lightning:outputField fieldName="Tip_To_Smarties__c" />
        </div>
    </lightning:recordViewForm>
    
</aura:component>

Hello,

I have a lookup field (First_JIRA_Issue_Number__c) on Case object that needs to be updated with the Jira Number when the related issue is created.

Basically from a Case, I have the possibility to create a Jira Issue (object: JIRA_Issue__c).


When the Jira Issue is created, the field First_JIRA_Issue_Number__c needs to be updated with the Jira Number. In this example the field First Jira Issue Number on Case is updated with JIRA000692


I have created a class and a trigger but it does work.
Could someone help.
Thanks

Apex Class

public class CaseManager {
    
    public static void updateJiraIssue(List<JIRA_Issue__c> lstJira) {
        Set<Id> jiraIds = new Set<Id>();
       
        for(JIRA_Issue__c jissue : lstJira){
            if(jissue.Case__c != null){
                jiraIds.add(jissue.Id);  
            }
        }
        
        List<Case> lstCase = new List<Case>([SELECT Id, First_JIRA_Issue_Number__c,(SELECT Id, Case__c FROM JIRA_Issues__r) FROM Case WHERE First_JIRA_Issue_Number__c IN: jiraIds]);
        System.debug('##### lstCase ' + lstCase.Size());
        
        if(lstCase.size()>0){
            for(Case c: lstCase){
                List<JIRA_Issue__c> lstJiraIssue = new List<JIRA_Issue__c>();
                lstJiraIssue = c.JIRA_Issues__r;
                if(lstJiraIssue.size() > 0){
                    for(JIRA_Issue__c ji: lstJiraIssue){
                        if(ji.Case__c == c.Id){
                            c.First_JIRA_Issue_Number__c = ji.Id;
                        }
                        
                    }
                    
                }
    
       		}
            update lstCase;
        }
        
      
    }

}

trigger CaseJiraIssueNumber on JIRA_Issue__c (after insert) {
    if(trigger.isAfter){
        CaseManager.updateJiraIssue(Trigger.New);
    }

}

Jira Issue:


known error Article:

public class KnowledgeKavManager {
    
    public static void updateJiraIssue(List<JIRA_Issue__c> lstJira) {
        Set<Id> kavIds = new Set<Id>();
        //Id KnownErrorRecordTypeId = schema.SObjectType.Knowledge__kav.getRecordTypeInfosByName().get('Known_Error').getRecordTypeId();
        
        for(JIRA_Issue__c jissue : lstJira){
            if(jissue.Case__c != null){
                kavIds.add(jissue.Id);      
            }
        }
        
        //Get Articles where related problem Id = Jira case__c Id
        //Map<Id,Knowledge__kav> KavMap = new Map<Id,Knowledge__kav>([SELECT Id FROM Knowledge__kav WHERE Related_Problem__c IN: kavIds AND RecordTypeId =:KnownErrorRecordTypeId]);
        Map<Id,Knowledge__kav> KavMap = new Map<Id,Knowledge__kav>([SELECT Id FROM Knowledge__kav WHERE Related_Problem__c IN: kavIds]);
        
        List<Knowledge__kav> lstKav = new List<Knowledge__kav>();
        
        for(Knowledge__kav kav: KavMap.values()){
            System.debug('##### KavMap.values ' + KavMap.values() );
            
        	if(KavMap != null && KavMap.containskey(kav.Related_Problem__c)) {
            
                List<JIRA_Issue__c> lstJiraIssue = new List<JIRA_Issue__c>();
                for(JIRA_Issue__c ji: lstJiraIssue){
                    
                    if(ji.Case__c == kav.Related_Problem__c){
                        kav.JIRA_Issue__c = ji.Id;
                   		lstKav.add(kav);
                    }
                    
                }
            }
            update lstKav;           
        }
      
    }

}

trigger JiraLinkKnownErrorArticle on JIRA_Issue__c (after insert, after update) {
    if(trigger.isAfter){
        KnowledgeKavManager.updateJiraIssue(Trigger.New);
    }

}

Hello,
I have an approval process on on Custom object. And I would like to update a custom field "Approver Name" with the name of the "Actual Approver"
So let's say the name the of Actual Approver is "Frank Karl" I would like the custom field "Approver Name" to be automatically updated with "Frank Karl"

How can I do it with out of the box functionnality?
Thanks
 

Hello,
I am trying to stop clients from commenting on Closed Cases in client portal.

I am using a trigger on CaseComment. But the trigger does not work as clients can still comments on closed case.
Alternatively if someone has another suggestion that would stop clients from commenting on Closed Cases.
Please suggest alternatives.

Thanks
 

trigger ClosedCaseComment on CaseComment (before insert) {
    
    Set<Id> parentCase=new Set<Id>();
    
	Map<Id,Case> mapCase=new Map<Id,Case>();
	for (CaseComment t: Trigger.new) {
		parentCase.add(t.ParentId);
	}
    
	List<Case> lstCase=[Select Id,Status from case where Id in :parentCase ];
	for(case c: lstCase){
		mapCase.put(c.Id,c);
	}

	for (CaseComment t: Trigger.new){
		if(mapCase.containskey(t.ParentId)) {
        
			if(mapCase.get(t.ParentId).Status=='Closed' && System.Userinfo.getUserType() == 'Standard'){
				t.addError('You cannot add comments to closed cases.');		
			}
		}
	}

}

Hi,

I have created a lightning button called "Raise a concern" but I would like to change the color of the text and the Icon, but when using Style in the component style, I am unale to change the color.

Here is the bit of code 
</aura:if>
        <aura:if isTrue="{!v.currentCaseRecordType=='Incident'}"> 
             
            <lightning:button variant="destructive"
                              label="Raise a Concern" class="concern"
                              iconName="utility:priority"
                              iconPosition="left"
                              title="Raise a Concern"
                              onclick="{! c.concernModalOpen }" 
                              disabled="{!if(v.currentCaseCaseConcern>0,'true','false')}"/>
        </aura:if>      

Could someone Help?
Thanks