SOQL Scenario -3

-
Parent to child Relationship
fetch the Contact fields from Account

 // parent to child relationship

 public class SoqlQuery3 {
    public List<Account> acc{set;get;}
    public SoqlQuery3(){
        acc=[select id, name, phone,(select id, lastname, firstname from contacts) from Account];
    }
}

 <apex:page controller="SoqlQuery3" >
    <apex:form >
    <apex:pageBlock >
        <apex:pageBlockTable value="{!acc}" var="a">
                <apex:column headerValue="Acc Name" value="{!a.name}" />
                <apex:column headerValue="Acc Phone" value="{!a.phone}" />
                <apex:column headerValue="Con Details">
                <table>
                        <apex:repeat value="{!a.contacts}" var="b">
                    <tr>
                        <td>{!b.lastname}</td><td>{!b.firstname}</td>
                            </tr>
                    </apex:repeat>
                        
                    </table>
                </apex:column>
            </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