function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
AHAMMEDAHAMMED 

Visual

list of records
Pankaj_GanwaniPankaj_Ganwani
Hi,

Can you please share the code of vf page here?
AHAMMEDAHAMMED
HI Pankaj
VF Page

<apex:page controller="ObjectRelatedQuery" tabStyle="Account">
    <apex:form >
        <apex:pageBlock >
            <apex:pageBlockButtons >
                <apex:commandButton value="Query Accounts" action="{!fetch}"/>
            </apex:pageBlockButtons>
            <apex:pageBlockSection columns="1" title="Account  Related SOQL Query" collapsible="false">
                <apex:outputText value="{!query}">
                </apex:outputText>
            </apex:pageBlockSection>

            <apex:pageBlockSection title="Account Object Records" columns="1" collapsible="false">
                <apex:pageBlockTable value="{!accList}" var="acc">
                    <apex:column value="{!acc.name}"/>
                    <apex:column value="{!acc.phone}"/>
                    <apex:column value="{!acc.rating}"/>
                    <apex:column value="{!acc.industry}"/>
                    <apex:column value="{!acc.accountnumber}"/>
                </apex:pageBlockTable>

            </apex:pageBlockSection>
        </apex:pageBlock>
    </apex:form>
</apex:page>
------------------------------------------------------

Controller
------------------------

public class ObjectRelatedQuery{

    
    public String ObjectRelatedQueryDetails { get; set; }
    public List<Account> accList{get;set;}
    public String query{get;set;}
     Public String searchStr{get;set;}
    
    public ObjectRelatedQuery(){
    }
    public PageReference fetch(){
        String SobjectApiName = 'Account';
       // string SobjectApiName = 'Contact';
        Map<String, Schema.SObjectType> schemaMap = Schema.getGlobalDescribe();
        Map<String, Schema.SObjectField> fieldMap = schemaMap.get(SobjectApiName).getDescribe().fields.getMap();
 
        String commaSepratedFields = '';
        for(String fieldName : fieldMap.keyset()){
            if(commaSepratedFields == null || commaSepratedFields == ''){
                commaSepratedFields = fieldName;
            }else{
                commaSepratedFields = commaSepratedFields + ', ' + fieldName;
            }
        }
 
        query = 'select ' + commaSepratedFields + ' from ' + SobjectApiName ;
 
        accList = Database.query(query);
        //conlist = Database.query(query);
        return null;
    }
}
 
Pankaj_GanwaniPankaj_Ganwani
Hi,

Please change the pageBlockSection title to this:

<apex:pageBlockSection title="List of Records" columns="1" collapsible="false">