You need to sign in to do that
Don't have an account?
Shirley Maglio
How to display the result of a query onto the Quote Edit page?
Hi,
Can anyone advise on how to do this via Apex and Visualforce? Or other ways and means?
Any help is greatly appreciated!
Thanks,
Shirley Maglio
Can anyone advise on how to do this via Apex and Visualforce? Or other ways and means?
Any help is greatly appreciated!
Thanks,
Shirley Maglio
--Controller:
public with sharing class apxShowDataTable {
Account acc;
public apxShowDataTable(Apexpages.StandardController cont)
{
acc = (Account)cont.getRecord();
}
public List<Contact> getContacts()
{
List<Contact> lstCont = [select FirstName, LastName, Phone from Contact where AccountId=: acc.Id];
return lstCont;
}
}
--VF Page
<apex:page standardController="Account" extensions="apxShowDataTable">
<apex:form >
<apex:pageBlock title="Account">
<apex:pageBlockSection title="Information">
<apex:inputField value="{!Account.Name}"/>
<br></br>
<apex:pageBlockTable value="{!Contacts}" var="con">
<apex:column value="{!con.FirstName}"/>
<apex:column value="{!con.LastName}"/>
<apex:column value="{!con.Phone}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>
All Answers
--Controller:
public with sharing class apxShowDataTable {
Account acc;
public apxShowDataTable(Apexpages.StandardController cont)
{
acc = (Account)cont.getRecord();
}
public List<Contact> getContacts()
{
List<Contact> lstCont = [select FirstName, LastName, Phone from Contact where AccountId=: acc.Id];
return lstCont;
}
}
--VF Page
<apex:page standardController="Account" extensions="apxShowDataTable">
<apex:form >
<apex:pageBlock title="Account">
<apex:pageBlockSection title="Information">
<apex:inputField value="{!Account.Name}"/>
<br></br>
<apex:pageBlockTable value="{!Contacts}" var="con">
<apex:column value="{!con.FirstName}"/>
<apex:column value="{!con.LastName}"/>
<apex:column value="{!con.Phone}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
</apex:form>
</apex:page>