Skip to main content

Creating a multilevel dependent picklist on Visualforce inside a Data table

Recently on working on a project I cam across a serious issue, creating a multilevel picklist with N-Level dependency.
e.g., Picklist one, select option, picklist two displays related values, select a value and the data for Picklist 3 are filtered based on picklist 1 and 2 and this goes on.
Lets increase the complexity a bit, you want to have this functionality in a data table with multiple rows.

The code for this seems tricky, but I did manage to write some.

The trick is create a wrapper class within you Apex:Class and bind it with the SelectList.

VF Page:

<apex:actionRegion >
<apex:pageBlockSection id="theSection" rendered="{!noLob}"> 
<apex:dataTable value="{!packages}" var="field" id="thetable" cellpadding="3px" id="dt">
<apex:column headerValue="Action">
<apex:CommandButton action="{!copyRow}" value="Copy" rerender="theSection" status="pleasewait">
<apex:param name="Assignment" Assignto="{!SelIndex}" value="{!field.index}"/>
</apex:CommandButton> 
</apex:column> 
<apex:column headerValue="Product Group">
<apex:selectList value="{!field.level1}" size="1" >
<apex:selectOptions value="{!field.level1Options}" /> 
<apex:actionSupport event="onchange" reRender="level2" status="pleasewait"> 
</apex:actionSupport>               
</apex:selectList>   
</apex:column>   
<apex:column headerValue="Products" >  
<apex:selectList id="level2" value="{!field.level2}" size="1" disabled="{!field.disable_level2}">
<apex:selectOptions value="{!field.level2Options}"/>     
</apex:selectList>  
</apex:dataTable>

And now the controller:

public class AddNewProductsController { 
public class myObject{
 public string level1 {get;set;} // The selected Level1 value in the Product Picklist on the modal panel
 public string level2 {get;set;}// The selected Level2 value in the Product Picklist on the modal panel
 public boolean disable_level2{get;set;}// The determines if Level2 value in the Product Picklist is disabled
 public boolean disable_level3{get;set;}// The determines if Level3 value in the Product Picklist is disabled
 public boolean FormRendered{get;set;}
 public myObject(){
 }
 public List getLevel1Options(){
 List options = new List();
 Options.add(new SelectOption('','--None--'));
 Options.add(new SelectOption('Product Group 1','Product Group 1')); 
Options.add(new SelectOption('Product Group 2','Product Group 2')); 
 Options.add(new SelectOption('Product Group 3','Product Group 3')); 
 Options.add(new SelectOption('Product Group 4','Product Group 4')); 
 return options;
 }
 
 public List getLevel2Options(){
 List options = new List();
 System.debug('==========='+level1+'%%%%%%%%%');
 options.add(new SelectOption('', '--None--')); 
 disable_level2=false;
 
 if(level1 == 'Product Group 1'){
 options.add(new SelectOption('Product1', 'Product1'));
 options.add(new SelectOption('Product2', 'Product2'));
 }else if(level1 == 'Product Group 2'){
 options.add(new SelectOption('Product1', 'Product1'));
 options.add(new SelectOption('Product15', 'Product15'));
 }else if(level1 == 'Product Group 3'){
 options.add(new SelectOption('Product2', 'Product2'));
 options.add(new SelectOption('Product23', 'Product23'));
 }else if(level1 == 'Product Group 4'){
 options.add(new SelectOption('Product16', 'Product16'));
 options.add(new SelectOption('Product12', 'Product12'));
 }else if(level1 == 'Product Group 5'){
 options.add(new SelectOption('Product16', 'Product16'));
 options.add(new SelectOption('Product1', 'Product1'));
 }else{
 disable_level2=true;
 }
 return options;
 }
}

This code will do your trick.

Hope it helps,
Cheers.
SiD

Popular posts from this blog

The curious case of the custom redirection on Salesforce Console

Every developer worth their salt knows that the easiest way of redirection from a page to another is by using everyone's favorite function

public PageReference redirect() { PageReference pageRef = page.peskyProblemRedirection; pageRef.setRedirect(true); return pageRef; }
And the method is called by adding it to the Action attribute of the CommandButton or link, which works like charm and the user is redirected to the page after completion of the action.
So why am I going back to the basics? Because this way of redirection causes a pesky little problem in using the Service Cloud or Sales Cloud console.

Let's illustrate the problem, let's say you have a visualforce page as follows:

<apex:page sidebar="false" showHeader="false" controller="myExampleController"> <apex:form > <apex:pageBlock > <apex:pageBlockButtons > <apex:commandButton action="{!Redirect}&qu…

Some PDF tricks on Visualforce: Landscape, A4, page number and more

The beauty of Visualforce is simplicity. Remember the shock you received when you were told the entire page renders as PDF if you just add renderAs=PDF to the Page tag.

For those who thought I spoke alien language right now, here is the trick, to render a page as PDF, we add a simple attribute to the <apex: page> tag

<apex: page renderAs='pdf'> This will render the entire page as PDF.

Now, say we need to add some extra features to the PDF. Like a page number in the footer or we need to render the page in landscape mode. Faced with this problem, I put on my Indiana Jones hat and went hunting for it in the vast hay-sack of the internet (read: googled extensively). Imagine my happiness when i found a big big page with many big big examples to solve the problem. The document I am referring to is from W3C, paged Box media.

Long story short, I now possess the ultimate secret of rendering the page in any format I want. So here are few tricks I learned from the page. To p…

Cache me if you can: What you should know before daring to set URL parameter on visualforce

If someone gave me a pence for every time there was an SOQL query in an APEX Class without using Limit or a condition during a code review, I could afford a Lamborgini this month. Sigh. If only. We make it a habit of going digging for data, at the very moment we need it. The crux of this problem happens when you have chain classes which are independent of each other. Each class needs the reference from a single record and we have to query for that record every single time.

While we don't see it, every SOQL query has a cost to it, and it does not go in my Lamborghini fund, however, it should. In a recent project, we had to construct an Account 360 page that could fetch information from different integration points. The page was also called using a live telephony integration, which could pass the phone number for the account. This required an ability to keep in context the Account that was on call.

Passing the Account id in URL parameter was a valid option, however, any manipulatio…