Query records where lastmodifieddate should be between 01-08-2017 and 01-10-2017 and Createddate should not equal to LAstmodifieddate? Is it possible through SOQL? If not what can i do get this?
I want to add 5 days to today's date. Example : Suppose i have a date field Collection_date__c which is having a date of 24th may 2017 and I am quering it today(19th May 2017). It should display this 24th Mau record.
Select Id, Collection_date__c from Custom_Object__c where Collection_date__c = today + 5;
Hi , In the below written code , Lst has nothing, hence recentLoanCycle variable is not getting initialized, but it is still entering the if statement where i am checking if string is null or blank. Please help!!
list<Lead> lst = new list<Lead>(); lst = [select Id ,Status, Loan_Cycle__c, client__c from lead where (Product_code__c = 891 OR product_code__c = 894 OR product_code__c = 915) AND client__c = '0018A000008XOQ4' order by createddate DESC LIMIT 1]; if(lst.size() > 0 && lst != null) { string recentLoanCycle = lst[0].loan_cycle__c.substring(1,2);
I am comparing two fields but validation rule fires even if the fields are empty. I want to skip the condition when fields are empty. It should only compare when fields have values.
Hi, I have written a batch class for sending SMSs using SMS Magic. Everything seems fine but it is failing while insertion. Please help. Below is the batch class.
Global class BatchSmsAfterSevenDaysOFDisburmentEFS implements Database.Batchable<sObject> { Public date varDate = date.today(); Public string str = 'Disbursed'; list<smagicinteract__smsMagic__c> lstSmsMagic = new list<smagicinteract__smsMagic__c>(); smagicinteract__smsMagic__c objSmsMagic = new smagicinteract__smsMagic__c(); string Query = 'Select Id, Client_Name_EFS__c, Actual_Disbursement_date__c,(Select id, Account.phone, Account.Name from opportunities__r) from Application__c where Application_Status__c =\'' + str + '\''; global Database.QueryLocator start(Database.batchableContext bc) { system.debug('inside start'); return database.getQueryLocator(Query); }
Unfortunately, there was a problem. Please try again. If the problem continues, get in touch with your administrator with the error ID shown here and any other related details. Error ID: 969321508-14233 (357396811).
Above is the error i am getting when i am trying to activate the process in process builder. Below is the screenshot of my process in process builder.
I am using SMS Magic for sending SMS. I am sending SMS when status is Submitted. Now i am stuck at where i need to send an SMS after 7 days from the date when the application was submitted. I have written a trigger to send SMS for submitted status. How it can be achieved? Please help.
global class Batch_ABC implements Database.Batchable<sObject> { list<lead> lstLeads = new list<Lead>(); global string CISNumber; public string str='closed'; string Query ='select name, CIS_No__c, Status__c from opportunity where PRODUCT_CODE_FORMULA__c IN (891, 894, 915) AND Status__c =\'' + str + '\'';
global database.QueryLocator start(Database.batchableContext bc) { System.debug(Query); system.debug('inside start');
return database.getQueryLocator(Query); }
global void execute(database.batchableContext bc, list<Opportunity> scope) { system.debug('inside Execute start'); for(Opportunity o : scope) { system.debug('inside For loop of execute');
for(Account a : [select name, (Select ID, Name from Leads__r where Status = 'Closed - Converted' AND Loan_Cycle__c = 'K1' AND Product_Code__c IN (891, 894, 915)) from account where CNumber =: CSNumber]) { system.debug('Inside second loop of execute...');
for(lead l : a.Leads__r) { system.debug('inside nested loop of execute...'); lstLeads.add(l); } } system.debug('Leads' + lstLeads); delete lstLeads ; }
global void finish(database.batchableContext bc) {
I want to add 5 days to today's date. Example : Suppose i have a date field Collection_date__c which is having a date of 24th may 2017 and I am quering it today(19th May 2017). It should display this 24th Mau record.
Select Id, Collection_date__c from Custom_Object__c where Collection_date__c = today + 5;
Hi , In the below written code , Lst has nothing, hence recentLoanCycle variable is not getting initialized, but it is still entering the if statement where i am checking if string is null or blank. Please help!!
list<Lead> lst = new list<Lead>(); lst = [select Id ,Status, Loan_Cycle__c, client__c from lead where (Product_code__c = 891 OR product_code__c = 894 OR product_code__c = 915) AND client__c = '0018A000008XOQ4' order by createddate DESC LIMIT 1]; if(lst.size() > 0 && lst != null) { string recentLoanCycle = lst[0].loan_cycle__c.substring(1,2);
Hi, I have written a batch class for sending SMSs using SMS Magic. Everything seems fine but it is failing while insertion. Please help. Below is the batch class.
Global class BatchSmsAfterSevenDaysOFDisburmentEFS implements Database.Batchable<sObject> { Public date varDate = date.today(); Public string str = 'Disbursed'; list<smagicinteract__smsMagic__c> lstSmsMagic = new list<smagicinteract__smsMagic__c>(); smagicinteract__smsMagic__c objSmsMagic = new smagicinteract__smsMagic__c(); string Query = 'Select Id, Client_Name_EFS__c, Actual_Disbursement_date__c,(Select id, Account.phone, Account.Name from opportunities__r) from Application__c where Application_Status__c =\'' + str + '\''; global Database.QueryLocator start(Database.batchableContext bc) { system.debug('inside start'); return database.getQueryLocator(Query); }
