-
Dynamic query field values to custom setting fields?
Problem in dynamic query:
‘ WHERE (Contract_State__c=\”+’Complete Activated’+’\”+’OR Contract_State__c=\”+’Partially Terminated’+’\”+’)’+’ AND Original_Term__c = true ‘+’ AND Program__c = NULL ‘+’ AND Originating_Location__c IN: XXX’)’
their is a custom setting called Batch criteria of list type.How to add this where query part in the custom setting field. How can I do this?
-
This discussion was modified 9 years, 11 months ago by
Nitish.
-
This discussion was modified 9 years, 11 months ago by
-
1 Reply
-
You add the fields to the custom setting through the Setup UI or through other tools. Then you use the “Manage” option to edit the setting. To reference it in code (assuming it is a list custom setting that you need a key for):
BatchCriteria__c bc = BatchCriteria__c.getInstance(keyValue);
String whereTerm = ”;
if (!String.isEmpty(bc.Where1__c)) whereTerm += bc.Where1__c;
if (!String.isEmpty(bc.Where2__c)) whereTerm += bc.Where2__c;
if (!String.isEmpty(bc.Where3__c)) whereTerm += bc.Where3__c;
if (!String.isEmpty(bc.Where4__c)) whereTerm += bc.Where4__c;
Log In to reply.
