You need to sign in to do that
Don't have an account?
Visualforce page not showing data from one query in controller extension
Hi,
I have a custom object (contract_review__c) for which I have created a visualforce page. It uses contract_review__c as a standard controller with a custom controller extension (findings). I'm using PageBlockTable referencing the custom controller extension to iterate over data.
The first three classes of the attached code work fine (note that the related_findings__c object is a related table to Contract_review__c and Contract is the standard object.
The last class does not show any records on the visualforce page, even though in debug I can see it has found 12 rows which is the correct number. I've hard coded an account Id for the minute to eliminate that as an issue.
Any ideas? Thanks in advance
Controller Extension public class Findings { public Findings(ApexPages.StandardController controller) { } Public Review_findings__c [] getKeyfindings () { return [Select Name,Review_area__c,Status__c,What_was_the_finding__c,type__c,What_is_the_financial_Impact__c,related_to_review__c FROM Review_Findings__c where related_to_review__c = :System.currentPageReference().getParameters().get('id') and include_in_executive_summary__c='Yes' order by Name ASC]; } Public Review_findings__c [] getFailedfindings () { return [Select Name,Review_area__c,Status__c,What_was_the_finding__c,type__c,What_is_the_financial_Impact__c,related_to_review__c FROM Review_Findings__c where related_to_review__c = :System.currentPageReference().getParameters().get('id') and Status__c='Failed'order by Name ASC]; } Public Review_findings__c [] getPassedfindings () { return [Select Name,Review_area__c,Status__c,What_was_the_finding__c,type__c,What_is_the_financial_Impact__c,related_to_review__c FROM Review_Findings__c where related_to_review__c = :System.currentPageReference().getParameters().get('id') and Status__c!='Failed'order by Name ASC]; } Public Contract [] getContractListing() { return [Select AccountId,Agreement_type__c,StartDate,EndDate,ContractNumber FROM Contract where AccountID ='001Z0000003sLj4']; } } VF Page code for getContractlisting <apex:page standardcontroller="Contract_Review__c" showheader="false" contenttype="application/pdf" extensions="Findings" renderas="pdf" cache="true"> <apex:pageblock > <apex:pageBlockTable value="{!Contractlisting}" var="cl" cellpadding="10" rules="all" styleclass="pageblock" > <apex:outputField value="{!cl.StartDate}" /> <apex:outputField value="{!cl.EndDate}" /> </apex:pageblockTable> </apex:pageblock>
Try to use <apex:column> in the pageblocktable to see the values of your query.