Apex Code Development You need to sign in to do that
Don't have an account?
swapna muthiyalu how to convert the following query into dynamic query?
set<string>mEmpId = new set<string>();
set<string>hEmpId = new set<string>();
if (mEmpId .size() == 0){
list<Contact> mgrHrRecs = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : hEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];
} else if(hEmpId.size() == 0){
list<Contact> mgrHrRecs = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : mEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];
}else if (mEmpId.size() > 0 && hEmpId.size() > 0)
{list<contact>listcon = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : mEmpId and AccountId IN :accountids and indexm__c = ‘yes’) or (empid__c IN : hEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];} ;
set<string>hEmpId = new set<string>();
if (mEmpId .size() == 0){
list<Contact> mgrHrRecs = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : hEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];
} else if(hEmpId.size() == 0){
list<Contact> mgrHrRecs = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : mEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];
}else if (mEmpId.size() > 0 && hEmpId.size() > 0)
{list<contact>listcon = [select id, empid__c,AccountId, Type__c from contact where (empid__c IN : mEmpId and AccountId IN :accountids and indexm__c = ‘yes’) or (empid__c IN : hEmpId and AccountId IN :accountids and indexh__c = ‘yes’) ];} ;
set<string>mEmpId = new set<string>(); set<string>hEmpId = new set<string>(); String query ='' if (mEmpId .size() == 0){ query = 'select id, empid__c,AccountId, Type__c from contact where (empid__c IN : hEmpId and AccountId IN :'+accountids +'and indexh__c = '\yes'\’; } else if(hEmpId.size() == 0){ query = }else if (mEmpId.size() > 0 && hEmpId.size() > 0) { ; query = } ; Datebase.execute(query);All Answers
set<string>mEmpId = new set<string>(); set<string>hEmpId = new set<string>(); String query ='' if (mEmpId .size() == 0){ query = 'select id, empid__c,AccountId, Type__c from contact where (empid__c IN : hEmpId and AccountId IN :'+accountids +'and indexh__c = '\yes'\’; } else if(hEmpId.size() == 0){ query = }else if (mEmpId.size() > 0 && hEmpId.size() > 0) { ; query = } ; Datebase.execute(query);what will be the impact?