[SalesForce] Filter Visualforce List Dynamically Using Picklist

I am trying to create a visualforce page that has a list of field values in a table that uses a picklist that on change will reRender the list by filtering by a specific field value. My problem is that, I can't seem to connect the picklist value with the field in the table that I want filtered. Can someone show me how I could fix this? Thanks!

Controller

    public with sharing class DynamicCasesExtension {

    public Case c { get; set; }
    public String objectName { get; set; }
    public List<String> objectFields { get; set; }
    public List<Case> SObjectListToShow { get; set; }

    public DynamicCasesExtension(){
        objectName = 'Case';
        SObjectListToShow = getSObjectList();
    }

    // Getting field list for the sObject
    public List<Case> getSObjectList(){
        objectFields = new List<String>();
        Map<String, Schema.SObjectType> globalDescription = Schema.getGlobalDescribe();
        Schema.sObjectType sObjType = globalDescription.get(objectName);
        Schema.DescribeSObjectResult res = sObjType.getDescribe();

        Map<String , Schema.SObjectField> mapFieldList = res.fields.getMap();
        for(Schema.SObjectField field : mapFieldList.values())
        {
            Schema.DescribeFieldResult fieldResult = field.getDescribe();
            if(fieldResult.isAccessible() && (fieldResult.getName() == 'CaseNumber' || fieldResult.getName() == 'Assigned_To__c' || fieldResult.getName() == 'Subject' || fieldResult.getName() == 'Priority' || fieldResult.getName() == 'Status' || fieldResult.getName() == 'CreatedDate')) 
            {
                objectFields.add(fieldResult.getName());
            }
        }

        //Building Query with the fields
        Integer i = 0;
        String fieldsToFetch = '';
        Integer len = objectFields.size();

        for(String temp: objectFields){
            if(i==len-1){
                  fieldsToFetch = fieldsToFetch + temp;
            } else {
                  fieldsToFetch = fieldsToFetch + temp + ',';
            }
            i++;
        }

        ID MerchantTypeRecordType = [SELECT Id FROM RecordType WHERE sObjectType = 'Case' AND DeveloperName = 'Merchant_Support' LIMIT 1].id;
        String caseStatus = ApexPages.currentPage().getParameters().get('c.Status');

        String qryStr = 'Select ' + fieldsToFetch + ' From ' + objectName + ' WHERE (RecordTypeId = :MerchantTypeRecordType and Case.Status = ' + caseStatus + ') Limit ' + 20; 
        return Database.Query(qryStr);

    }

}

===============================================================================

Visualforce Page

<apex:page controller="DynamicCasesExtension">

<apex:form >
    <apex:pageMessages />

    <apex:pageBlock title="Filter Based on Case Status: ">
        <apex:outputText value="Filter Based on Case Status"></apex:outputText>
        <apex:actionRegion >
            <apex:selectList value="{!c.status}" multiselect="false" size="1" required="true">
                <apex:selectOption itemValue="None" itemLabel="-None-"/>
                <apex:selectOption itemValue="New" itemLabel="New" />
                <apex:selectOption itemValue="Closed" itemLabel="Closed"/>
                <apex:selectOption itemValue="In Progress" itemLabel="In Progress"/>
                <apex:actionSupport event="onchange" rerender="result"/>
            </apex:selectList>
        </apex:actionRegion>
    </apex:pageBlock>

    <apex:pageBlock >
        <apex:outputPanel>
            <apex:pageBlockTable value="{!sObjectList}" var="res" id="result">
                <apex:repeat value="{!objectFields}" var="field" >
                    <apex:column value="{!res[field]}" id="results"/>
                </apex:repeat>
                <apex:actionPoller rerender="results" interval="10" status="state"/>
                <apex:actionStatus id="state" startText="Refreshing" stopText=""/> 
            </apex:pageBlockTable>
        </apex:outputPanel>
    </apex:pageBlock>
</apex:form>

Best Answer

I have changed the below controller. I initially didn't see that you're not calling any method from the apex:actionSupport tag. I have changed the below code (Apex / VF) and added some comments.

public with sharing class DynamicCasesExtension {

    public Case c { get; set; }
    public String objectName { get; set; }
    public List<String> objectFields { get; set; }
    public List<Case> SObjectListToShow { get; set; }

    public DynamicCasesExtension(){
        objectName = 'Case';
        //set the status to the value you need. In your case I assume it is coming in as a parameter. This is to be set only for the first load. 
        c.Status = ApexPages.currentPage().getParameters().get('c.Status');
        //SObjectListToShow = getSObjectList();
        generateList();
    }

    // a new method which will be called everytime the value in the picklist is changed
    public void generateList() {
        SObjectListToShow = caseSObjectList();
    }

    // Getting field list for the sObject. Changed the name of the method.
    public List<Case> caseSObjectList(){
        .
        .
        .
        //Change it to c.Status so that it gets set to the value selected from the page.
        String caseStatus = c.Status;
        .
        .
        .
    }

}

VF Page:

<apex:actionSupport event="onchange" rerender="result" action="{!generateList}"/>

Related Solutions

[SalesForce] Add more than 1000 picklist values in visualforce page (controller 1000 list items limit)

I'd say "you're doing it wrong" ;)

Every time you're hitting a limit like that you should stop and ask if that's really what you need to do. Even if you'd be able to input 50K contacts here - what would usability of such monster be? How is user expected to scroll through this? I'd say a lookup with a search function is really the way to go, that's what it is for.

Have you considered using an autocomplete? Jeff Douglas's blog contains a really nice example on dynamic search - it's not exactly autocompletion but you shouldn't have too much trouble modifying it.

An alternative might be @BobBuzzard's VF lookup

Or simply marry jqueryUI autocomplete and a @RemoteAction

But if you insist on reading further... ;)

public class picklistTest{
    public String selectedVal {get;set;}
    public List<SelectOption> getOptions1(){
        List<SelectOption> retVal = new List<SelectOption>();
        for(Integer i = 0; i < 1000; ++i){
            retVal.add(new SelectOption(String.valueOf(i+1), String.valueOf(i+1)));
        }
        return retVal;
    }
    public List<SelectOption> getOptions2(){
        List<SelectOption> retVal = new List<SelectOption>();
        for(Account a : [SELECT Id, Name FROM Account]){
            retVal.add(new SelectOption(a.Id, a.Name));
        }
        return retVal;
    }
    public List<SelectOption> getOptions3(){
        List<SelectOption> retVal = new List<SelectOption>();
        for(Contact c : [SELECT Id, LastName FROM Contact]){
            retVal.add(new SelectOption(c.Id, c.LastName));
        }
        return retVal;
    }
}

<apex:page controller="picklistTest">
<apex:form>
    <apex:selectList value="{!selectedVal}" size="1">
        <apex:selectOptions value="{!options1}"/>
        <apex:selectOption itemValue="Hi StackExchange" itemLabel="Hi StackExchange"/>
        <apex:selectOptions value="{!options2}"/>
        <apex:selectOptions value="{!options3}"/>
    </apex:selectList> 
</apex:form>
</apex:page>

So you can get your query results, build a <List<List<SelectOption>> for example and then have a combo of <apex:repeat> + <apex:selectOptions>... I still advise against doing this though ;)

[SalesForce] lookup filter using multiselect picklist

Hi you can have trigger on Child object to check if value selected in Child picklist is present in parent object's MultiSelect Picklist or not.

Giving you example using Account as Parent and contact as child

Account has Multi_version__c field as multi Select, While Contact has Version__C as picklist

trigger TgrPreventVersionSelection on Contact (after Insert, before update) {

   // first find Accounts to get multi Select pickList values 
   Set<Id> AccIds = new set<Id>();
   For(Contact c : Trigger.new) 
      {
        if(c.AccountId != null)
        AccIds.add(c.AccountID);
      }

   // Thsis map will  have parent object Id( Account here) and values of multiSelectPicKlist in Set. 
   Map<Id, set<string>> mpAcWithMultiPickList = new map<Id, set<string>>();
   List<Account> AccList = new list<Account>(); 



   AccList =  [select id, name, Multi_version__c from Account where Id = :AccIds];

  // once We have Accounts, we'll populate a map having Account ID and set of string present in multi Select piclist

   For(Account acc : Acclist)
    {
     if(acc.Multi_version__c != null)
       { 
          list<String> slist = acc.Multi_version__c.split(';');
          set<String> versionStringSet = new set<string>(slist);
           mpAcWithMultiPickList.put(acc.id, versionStringSet); //converting list to set
        }// end of If condition
    }// for loop

   // Once we've map of Account and Set, we can ran check to see value selected in child is present in parent's multiselect(set of string) or not
    For(contact c : trigger.new) 
      {
        if(c.AccountId != null)
          { 
            Set<string> SettoCompare =mpAcWithMultiPickList.get(c.AccountId);

              If(!SettoCompare.contains(c.version__c))
                c.addError('Version doesn\'t Exist in Parent');
          }

      }   
}

Best Answer

Related Solutions

[SalesForce] Add more than 1000 picklist values in visualforce page (controller 1000 list items limit)

[SalesForce] lookup filter using multiselect picklist

Related Topic