Apex Code Development You need to sign in to do that
Don't have an account?
Sumesh Chandran How to filter rows from a list
I have a list here which has city name as a column, how to filter the rows by values from the city name column.
global Database.QueryLocator start(Database.BatchableContext BC) {
return Database.getQueryLocator('SELECT CITY_NAME__c,PROVINCE_CODE__c,STATUS__c,INTERNET_SERVICE__c,VIDEO_SERVICE__c,PHONE_SERVICE__c FROM MDU_Squad_Data_min__c');
}
// Execute method
global void execute(Database.BatchableContext BC, List<MDU_Squad_Data_min__c> cityStats) {
// Here I am trying to filter the values of the cityStats list
}
You can use the map to get all the records based on the city name as shown below
global Database.QueryLocator start(Database.BatchableContext BC) { return Database.getQueryLocator('SELECT CITY_NAME__c,PROVINCE_CODE__c,STATUS__c,INTERNET_SERVICE__c,VIDEO_SERVICE__c,PHONE_SERVICE__c FROM MDU_Squad_Data_min__c'); } // Execute method global void execute(Database.BatchableContext BC, List<MDU_Squad_Data_min__c> cityStats) { // Here I am trying to filter the values of the cityStats list Map<String, List<MDU_Squad_Data_min__c>> cityMduMap = new Map<String,List<MDU_Squad_Data_min__c>>(); for (MDU_Squad_Data_min__c m : cityStats ) { if (!cityMduMap.containsKey(m.CITY_NAME__c) { cityMduMap.put(m.CITY_NAME__c, new List<MDU_Squad_Data_min__c>()); } cityMduMap.get(m.CITY_NAME__c).add(m); } }All Answers
You can use the map to get all the records based on the city name as shown below
global Database.QueryLocator start(Database.BatchableContext BC) { return Database.getQueryLocator('SELECT CITY_NAME__c,PROVINCE_CODE__c,STATUS__c,INTERNET_SERVICE__c,VIDEO_SERVICE__c,PHONE_SERVICE__c FROM MDU_Squad_Data_min__c'); } // Execute method global void execute(Database.BatchableContext BC, List<MDU_Squad_Data_min__c> cityStats) { // Here I am trying to filter the values of the cityStats list Map<String, List<MDU_Squad_Data_min__c>> cityMduMap = new Map<String,List<MDU_Squad_Data_min__c>>(); for (MDU_Squad_Data_min__c m : cityStats ) { if (!cityMduMap.containsKey(m.CITY_NAME__c) { cityMduMap.put(m.CITY_NAME__c, new List<MDU_Squad_Data_min__c>()); } cityMduMap.get(m.CITY_NAME__c).add(m); } }visit my blog for CPS Test (https://albertmartin.bcz.com/5-best-click-speed-test-to-check-your-click-speed/)