SOQL Scenario -4

-
Fetch the records Parent records from Child Object

 public class SoqlQuery4 {
    public List<Contact> con{set;get;}
    public SoqlQuery4(){
        con=[select id, lastname, firstname, Account.name, Account.phone from contact]; 
    }
}

 <apex:page controller="SoqlQuery4" >
    <apex:form >
    <apex:pageBlock >
        <apex:pageBlockTable value="{!con}" var="c">
                <apex:column headerValue="Con Name" value="{!c.lastname}" />
                <apex:column headerValue="Con Fname" value="{!c.firstname}" />
                <apex:column headerValue="Acc Name" value="{!c.Account.Name}" />
                <apex:column headerValue="Acc Phone" value="{!c.Account.phone}" />
            </apex:pageBlockTable>
        </apex:pageBlock>
    </apex:form>
</apex:page>

Comments

Post a Comment

Popular posts from this blog

Page Layouts

-
1. What is PageLayout? A: Pagelayout controls which fields will be displays in which order they will displayed ,which formate that field should be displayed. 2.How many pageLayouts can be assigned to a profile on a object? A: For every profile only one pagelayout is define. 3. What we can controll using pageLayout? A:Fields. 4. How to add Custom button on the PageLayout? A: Drag and drop 5. How to add Custom button relateed list in the pageLayout? A: 6. Find out what type of access is provided on the field when we have following combination             Field Level Security           Page Layout                    output?       Visable   Read     Required     Visable   Read   Required  1.     Ok         No            No                No       No        No 2.     Ok         No            No                 Ok       No      No 3.     Ok         No            NO                Ok       OK     No 4.     Ok          No           NO                OK      No       OK
Read more

SOQL Scenario-1

-
Image
Fetch the Name Fields from Account Object public class SoqlQuery1 {     public List<Account> acc{set;get;}     public SoqlQuery1(){         acc=[select id, name from Account];     } } <apex:page controller="SoqlQuery1" >     <apex:form >     <apex:pageBlock >         <apex:pageBlockSection >             <apex:pageBlockTable value="{!acc}" var="a">                     <apex:column headerValue="Name" value="{!a.name}" />                 </apex:pageBlockTable>             </apex:pageBlockSection>         </apex:pageBlock>     </apex:form> </apex:page>
Read more