Thanks in advance!Johnpublic with sharing class AllSpotController{
public List <Job_Number__c> SPOT {get;set;}
public String[] campaigns {get;set;}
public void load() {
SPOT = [Select id, name, Thumbnail_URL__c, ISCI__c, Title__c, Project__c, Campaign__r.Name, Nets_Running__c, View_Link__c, Internal_Title__c, Legal__c from Job_Number__c where ISCI__c <> null];
Set<String> campaignSet = new Set<String>();
for (Job_Number__c j : SPOT)
campaignSet.add(j.Campaign__r.Name);
campaigns = new String[campaignSet.size()];
Integer i = 0;
for (String campaign : campaignSet) {
campaigns[i] = campaign;
i++;
}
}
}
i forgot to initialize the list ! :)public with sharing class AllSpotController
{
public List <Job_Number__c> SPOT {get;set;}
public list<String> campaigns {get;set;}
public void load()
{
campaigns= new List<String>();
SPOT = [Select id, name, Thumbnail_URL__c, ISCI__c, Title__c, Project__c, Campaign__r.Name, Nets_Running__c, View_Link__c, Internal_Title__c, Legal__c from Job_Number__c where ISCI__c <> null];
Set<String> campaignSet = new Set<String>();
for (Job_Number__c j : SPOT)
campaignSet.add(j.Campaign__r.Name);
for (String campaign : campaignSet)
{
campaigns.add(campaign);
}
campaigns.sort();
}
}