+ Start a Discussion
mukesh khandve786mukesh khandve786 

Add Filter logic (1 And 2) Or 3 dyanmic Qurey How Add for example (city='indore' and name='ramesh') Or Price="200" how get in apex class AuraEnabled

@anilbathula@@anilbathula@
Hi Mukesh,

Use this query and change your_object__c with your object name.
 
String lstrecs='select id, Name ' +
    'from your_object__c ' +
    'where  ' +     
    '(City =\'indore\' AND Name =\'ramesh\') OR ' +
    'price>0';

System.debug('==>'+lstrecs);

Thanks
Anil.B​​​​​​​
mukesh khandve786mukesh khandve786

Save in   
1 =city='indore' 
2=name='ramesh' 
3=price='200'
Display on ui by entering data