You need to sign in to do that
Don't have an account?
Iqra Tech
i need to query two values stored in my custom field in my query dynamically
i need to query two values stored in my custom field in my query dynamically
In my custom object i am having custom field that stores single value like XYZ or multiple values like xyz,ABC now i need to query both values how?
In my custom object i am having custom field that stores single value like XYZ or multiple values like xyz,ABC now i need to query both values how?
ex :- i user might be insert single value or having more than one values seprated by quama than what to do my current query working fine one single value but when i am getting more than two values it is not working please see this my query
return Database.getQueryLocator(
'select Id,Edition__c,Object__c,Opportunity__c,Opportunity_Id__c,Stage__c,Banner_Name__c,Stand_no__c,Edition_Event_Name__c,Additional_field_3__c,' +
'Additional_field_2__c,Type_of_Stand__c,Customer_Product__c,Additional_field_4__c,Additional_field_1__c,Contractual_Sq_M__c,Hall__c,Height__c,Width__c,' +
'Open_Sides__c,Additional_field_6__c,Additional_field_5__c,Phone__c,Website__c,Fax__c,PO_Box__c,Floor_Plan_Stage__c from ' +
'Floor_Plan_Mapping__c order by createdDate DESC limit 1');
can you please make correction in this query
Edition_Event_Name__c in this field i am getting values sometimes xyz or sometimes xyz,ABC or PQR,LMN,EFG like this