Create a Visualforce page that displays a list of opportunities and allows users to filter them based on criteria such as stage and amount.?

Question

can you provide me solution for this.i have tried many times but could not solve it.

Divya Chauhan · Accepted Answer

Hello @Ayush Singhal https://trailblazers.salesforce.com/profileView?u=0054S0000032t8cQAA ,   Please check,  https://stackoverflow.com/questions/31250924/visualforce-page-custom-filter

Ayush Singhal · Answer

Thank @Divya Chauhan https://trailblazers.salesforce.com/profileView?u=0053000000BmdE5AAJ solved this problem but i have some doubt.. visualForce.Page apex.cls public with sharing class opportunityClass { public String FilterStage {get;set;} public Decimal FilterAmount {get;set;} public ListfilteredOpportunity {get;set;} public List getFilteredList(){ if(FilterAmount!=null && FilterStage !=null) return [select Name,StageName,Amount from Opportunity where StageName =:FilterStage AND Amount >=:FilterAmount]; else if(FilterAmount==null&&FilterStage==null){ return [select Name,StageName,Amount from Opportunity]; } else if(FilterAmount!=null){ return [select Name,StageName,Amount from Opportunity where Amount >=:FilterAmount]; } return [select Name,StageName,Amount from Opportunity where StageName =:FilterStage]; } public List getStageOptions(){ List options = new List(); options.add(new SelectOption('Prospecting','Prospecting')); options.add(new SelectOption('','Null')); options.add(new SelectOption('Qualification','Qualification')); options.add(new SelectOption('Needs Analysis','Needs Analysis')); options.add(new SelectOption('Value Proposition','Value Proposition')); options.add(new SelectOption('Id. Decision Makers','Id. Decision Makers')); options.add(new SelectOption('Perception Analysis','Perception Analysis')); options.add(new SelectOption('Proposal/Price Quote','Proposal/Price Quote')); options.add(new SelectOption('Negotiation/Review','Negotiation/Review')); options.add(new SelectOption('Closed Won','Closed Won')); return options; } public void ApplyFilter(){ getFilteredList(); } } I have add manually options in selectOption list..but if there more then 100 options so what to do..i am thinking load picklist values directly in vf page but could not find the way for it..it can be done in standard Controller..but in custom Controller i can not.

Create a Visualforce page that displays a list of opportunities and allows users to filter them based on criteria such as stage and amount.?

Salesfoce Developer

Verwandte Lerninhalte

Weitere Hilfe