function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Kumar GKumar G 

How to join WhereClause query and make it as Single query

How to join WhereClause query and make it as Single query , please find the query in code sample.
query = 'SELECT Id,UserRecordAccess.HasEditAccess,Name,Customer__c,Vendor_Site_ID_1__c,TM_Offer_Number__c,Program_Status__c,Currency__c,Tier_1_Customer__c,Program_Amount__c,Program_Amount_in__c,Committed_Amount__c,Committed_Amount_in__c,NTGR_Sub_Budget__c,NTGR_Oracle_Exchange_Rate__r.Conversion_Rate__c FROM NTGR_Marketing_Programs__c';
			
            whereClause = ' WHERE RecordType.Name =: LUMPSUM_RECORD_TYPE and Program_Status__c in : PROGRAM_STATUS_SET ';  
            whereClause += String.isNotBlank(dummyMarketingProgram.Business_Unit__c) ? ' AND Business_Unit__c = \'' + dummyMarketingProgram.Business_Unit__c + '\'' : ' AND Business_Unit__c = null';
			
            whereClause += String.isNotBlank(dummyMarketingProgram.Quarter__c) ? ' AND Quarter__c = \'' + dummyMarketingProgram.Quarter__c + '\'' : ' AND Quarter__c = null';
			
            whereClause += String.isNotBlank(dummyMarketingProgram.Year__c) ? ' AND Year__c = \'' + dummyMarketingProgram.Year__c + '\'' : ' AND Year__c = null';
			
            whereClause += String.isNotBlank(dummyMarketingProgram.Budget_Holder__c) ? ' AND OwnerId = \'' + dummyMarketingProgram.Budget_Holder__c+'\'': ' ';
			
            whereClause += String.isNotBlank(dummyMarketingProgram.NET_Company__c) ? ' AND NET_Company__c= \'' + dummyMarketingProgram.NET_Company__c+'\'': ' ';
			
            whereClause += String.isNotBlank(dummyMarketingProgram.Program_Type__c) ? ' AND Program_Type__c= \'' + dummyMarketingProgram.Program_Type__c+'\'': ' ';

Thanks in advance..
Waqar Hussain SFWaqar Hussain SF
List<NTGR_Marketing_Programs__c> sobjList = Database.query(query + whereClause );