[SalesForce] Display Records Dynamically based on Date Filters

Using two date filters displayed in the VF page I would like to render the records in apex:pageblocktable.

I am pretty new to Visualforce and this is what I have built so far.

VF Page

<apex:page standardController="Expense__c" extensions="expense_extension" recordSetVar="expenses" sidebar="false" >
<apex:form >
 <apex:pageBlock >
 <b> {!Greeting} </b>
 <apex:pagemessages />
 <apex:pageblockButtons >
   <apex:commandButton action="{!save}" value="Save"/>
 </apex:pageblockButtons>

 <apex:pageBlockTable var="e" value="{!expenses}">
  <apex:column headerValue="Expense Amount">
   <apex:inputField value="{!e.Amount__c}"/>
  </apex:column>
  <apex:column headerValue="Date">
   <apex:inputField value="{!e.Expense_Date__c}"/>
  </apex:column>
  <apex:column headerValue="Expense Type">
   <apex:inputField value="{!e.Type__c}"/>
  </apex:column>

  <apex:column headervalue="Expense Sub Type">
   <apex:inputField value="{!e.Sub_Type__c}"/>
  </apex:column>

  <apex:column headervalue="Comments">
   <apex:inputField value="{!e.Comments__c}"/>
  </apex:column>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:form>
</apex:page>

Controller Extension

public class expense_extension {

private final Expense__c e;
public ApexPages.StandardSetController sc;

public expense_extension(ApexPages.StandardSetController exp)
{
this.sc = exp;
}

public String getGreeting()
{  
return 'Hello ';
}

public PageReference save()
{   
sc.save();
PageReference p = new PageReference('/apex/ExpenseList');
return p; 
}    
}

I have been able to display all the records so far.

enter image description here

The next step I believe is to display the date controls and based upon the selection display the records.

Can someone tell me how I can display date controls ("Start" & "End") ?.

Also I am interested to know how we can display date controls in VF without them being bound to any object columns.

Best Answer

To use the standard SFDC datepicker control, you need to add two fields of type Date to any SObject (for example, your Expense__c object, but could be an arbitrary object Foo__c

Name one field start_date_filter__c, type = date, the other end_date_filter__c

Then bind the VF page inputFields to the object containing these fields in your controller that is instantiated in your constructor. This object is NOT one of the objects fetched by the standard setController.getRecords().

In effect, you are just leveraging SFDC default VF control construction at the cost of burning up a couple of sobject fields that need never be displayed on a detail page

There are other solutions using custom datepickers via jQuery and the like but the above is easy and requires no new technology to learn

Related Solutions

[SalesForce] Dynamically create filters based on object fields

Depending on what you want to do, there are a couple of solutions.

If you want to display all Account fields I would suggest using getDescribe().fields.getMap().keySet() and then iterating over the result in an apex:repeat to build you page.

public with sharing class SearchPageController
{
    public final Account anAccount { get; set; }
    public List<String> searchFields { get; private set; }


    public SearchPageController()
    {
        anAccount = new Account();
        searchFields = new List<String>(Account.getSObjectType().getDescribe().fields.getMap().keySet());
    }
}

Then on your page (you'll want to adjust the 'look and feel', as this example doesn't look great!):

<apex:page controller="SearchPageController">
    <apex:form>
        <apex:repeat value="{!searchFields}" var="field">
            <apex:outputText value="{!field}"/>
            <apex:inputField value="{!anAccount[field]}"/>
            <br/>
        </apex:repeat>
    </apex:form>
</apex:page>

You can then use the values stored within the Account object inside your controller to build your dynamic SOQL query for your search.

If you only want to display some of the fields on Account then I would suggest using Field Sets, in which case you need to change your controller to something like the following:

public with sharing class SearchPageController
{
    public final Account anAccount { get; set; }
    public List<String> searchFields { get; private set; }


    public SearchPageController()
    {
        anAccount = new Account();
        searchFields = new List<String>();

        for(Schema.FieldSetMember f : SObjectType.Account.FieldSets.YourFieldSet.getFields()) 
        {
            searchFields.add(f.getFieldPath());
        }
    }
}

OR, you can change your apex:repeat to use the Field Set directly.

<apex:page controller="SearchPageController">
    <apex:form>
        <apex:repeat value="{!$ObjectType.Account.FieldSets.YourFieldSet}" var="field">
            <apex:outputText value="{!field.Label}"/>
            <apex:inputField value="{!anAccount[field]}"/>
            <br/>
        </apex:repeat>
    </apex:form>
</apex:page>

Again, you can then use the values stored within the Account object inside your controller to build your dynamic SOQL query (or whatever you're using) for your search.

[SalesForce] Dynamically display picklist values based on Record type in vf page

Kindly follow This Link. I've used this and its working now. Hope this would be useful.
Dont forget to add connection.js in includescript.

<apex:page >
 //use version according to org
    <script src="/soap/ajax/40.0/connection.js" type="text/javascript"></script>
    <script src="/soap/ajax/40.0/apex.js" type="text/javascript"></script>


    <script>
        sforce.connection.sessionId='{!GETSESSIONID()}';
        function init(){
           var result = sforce.connection.describeLayout('Opportunity'); //to do 
           console.log(result); //parse this object to find picklist values for each record type
        }
    </script>

    <body onload="init();">    
    </body>
</apex:page>

Best Answer

Related Solutions

[SalesForce] Dynamically create filters based on object fields

[SalesForce] Dynamically display picklist values based on Record type in vf page

Related Topic