I have a dynamic query which has the where condition like this:
' 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'+' AND ( No_of_Days_to_Expire__c = 30 or No_of_Days_to_Expire__c = 45 or No_of_Days_to_Expire__c = 60 or No_of_Days_to_Expire__c = 90 )'
I have a custom setting called Batch criteria which is of list type. My question is how to add this where query part in the custom setting field. If I copy and paste this, it is not taking the whole part as it is exceeding from 255 characters. How can I do this?