February 6, 2013

How to fetch data from Controller and display it in Visualforce page without using button?

To fetch data from Controller and display it in Visualforce page without using button, retrieve the record in the constructor.

Sample code:

Visualforce page:

<apex:page controller="Sample" >
    <apex:form >
       <apex:pageblock id="account" title="Account Details(Standard Object)" >
            <apex:pageblockTable value="{!acc}" var="a">
                <apex:column value="{!a.Name}"/>
                <apex:column value="{!a.AccountNumber}"/>
            </apex:pageblockTable>
        </apex:pageblock>
       <apex:pageblock id="member" title="Member Details(Custom Object)">
            <apex:pageblockTable value="{!mem}" var="m">
                <apex:column value="{!m.Name}"/>
            </apex:pageblockTable>         
        </apex:pageblock>          
    </apex:form>
</apex:page>


Controller:

public with Sharing class Sample
{   
    public List<Account> acc {get;set;}
    public List<Member__c> mem {get;set;}   
      
    public sample()
    {
        acc = [SELECT Name, AccountNumber FROM Account];
        mem = [SELECT Name FROM Member__c];
    }
}


Output:

10 comments:

  1. hi
    i have one request
    search the picklist value get the data on table formade using bootstrup method

    ReplyDelete
    Replies
    1. Yes. Once you get the result from the apex convert it to JSON and use bootstrap methods to show it. Let me know if that works.

      Delete
  2. I want to know about the how to fetch data in custom object can you please share some suggestions about it. Thanks

    ReplyDelete
    Replies
    1. In the example used, Member__c is a custom object.

      Delete
  3. Can i know to display the data in another Vf page by clicking on button

    ReplyDelete
    Replies
    1. Try this - https://blogs.perficient.com/2015/03/16/how-to-embed-visualforce-pages-in-visualforce-pages-issues-and-solution/

      Delete
  4. Hi, Is it possible to display the related records below the record name which is selected/clicked. Let's say I am displaying List of Accounts based on search string. From the results if I clicked one record below the record name I need to display related contacts.

    ReplyDelete
    Replies
    1. I haven't done this in VF and Apex.
      You can try lightning-tree-grid with row level action in Salesforce Lightning - https://www.infallibletechie.com/2020/07/lightning-tree-grid-with-row-level.html. In the above example, I have shown Account and it's related Contacts.

      Delete
    2. Hi, Thanks for your response.. Isn't it possible to achieve the same functionality using normal apex class and vf page. Since I'm not aware of Salesforce Lightning I am trying to achieve in that way.

      Delete
    3. Check this - https://www.infallibletechie.com/2021/02/collapsible-and-expandable-sections.html

      Delete