Salesforce Developer Community

Chatter

Feed
1

Best Answers
0

Likes Received
0

Likes Given
10

Questions
44

Replies

I want to create a pdf from a cutom button click and then attach it to the correspondening Object record. I have the following code for the apex controller for this:

public class attachPDFToTimeRecord {
	
	private final TimeRecords__c a; //TimeRecords object
	
	//constructor
	public attachPDFToTimeRecord(ApexPages.StandardController standardPageController) {
		a = (TimeRecords__c)standardPageController.getRecord(); //instantiate the TimeRecord object for the current record
	}
	
	//method called from the Visualforce's action attribute
	public PageReference attachPDF() {
		//generate and attach the PDF document
		PageReference pdfPage = Page.Invoice_Matter; //create a page reference to our Invoice_Matter Visualforce page
		Blob pdfBlob = pdfPage.getContent(); //get the output of the page, as displayed to a user in a browser
        
		Attachment attach = new Attachment(parentId = a.Id, Name = 'pdfAttachmentRecord.pdf', body = pdfBlob); //create the attachment object
		insert attach; //insert the attachment
		//redirect the user
		PageReference pageWhereWeWantToGo = new ApexPages.StandardController(a).view(); //we want to redirect the User back to the TimeRecord detail page
		pageWhereWeWantToGo.setRedirect(true); //indicate that the redirect should be performed on the client side
		return pageWhereWeWantToGo; //send the User on their way
	}

}

I get List has no rows for assignment to sObject error in the line

Blob pdfBlob = pdfPage.getContent();

Can anyone help my resolve this error?

SFMani
March 02, 2017
Like
0
Continue reading or reply

SOLVED

14 replies

List has no rows for assignment to SObject error

I have a custom Object TimeRecords__c and I want to display the VF Page as a pdf in the object using a custom Button. I created a Visualforce page and a controller class for the Custom Button. On clicking the custom button I get the 'List has no rows to SObject error'.
My VF Page Code is as below:

<apex:page standardController="TimeRecords__c" showHeader="false" renderas="pdf" extensions="TimeRecord">

<table border="0" cellspacing="0" cellpadding="0" width="100%" id="table1">


<tr>
    <td >
        <img src='{!URLFOR($Resource.VinasLogo)}'  title="logo" />
    </td>
    
    <td  align="right"><font face="Arial" >
    <b>Invoice for {!con.Name}</b>
   </font><br/>
   </td>
  
  
    
</tr>

 
<hr/>

</table>
<table border="0" cellspacing="0" cellpadding="0" width="100%" id="table1">
<tr>    <td><font face="Arial" >
        {!$Organization.Name}<br/>
        {!$Organization.Street}<br/>
        {!$Organization.PostalCode} {!$Organization.City}<br/>
        {!$Organization.Country}<br/>
        </font></td> 
        <td width="60%">&nbsp;</td>
   <!--<td ><font face="Arial">Invoice number: <apex:repeat value="{!Opportunity.Invoices__r}" var="line2">
   {!line2.name}</apex:repeat></font><br/>
  
   
   <font face="Arial">Invoice Date: <apex:repeat value="{!Opportunity.Invoices__r}" var="line2">
   {!line2.Invoice_Date__c}  </apex:repeat></font></td>-->
 
   
  
</tr>
</table>
<br/>
<hr/>
<p><b><font face="Arial" color="#000080">Address Information</font></b></p>

<table border="0" width="100%" id="table2">


<tr>
       <td>          
           <font face="Arial">Bill To:<br/>
                             {!con.MailingStreet}<br/>
                             {!con.MailingCity}{!con.MailingState}{!con.MailingPostalCode}<br/>
                                                          
           </font>
        </td>
        <td width="50%"></td>        
</tr>


</table>
<br/>
<hr/>
<p>&nbsp;</p>
<hr/>
<p align="center"><font face="Arial"><i>Copyright {!$Organization.Name}.</i></font></p>
</apex:page>

Controller Class:

global with sharing class TimeRecord {

    

     public Contact con{get;set;}
    public TimeRecords__c TR{get;set;}
    
    
   
    
    public TimeRecord(ApexPages.StandardController cntrl){
        
     
       this.TR = (TimeRecords__c) cntrl.getRecord();
        TR=[SELECT Billable__c, Activity__c, Client__c, Client_Name__c,Date_of_Work__c, Entry_Type__c, Exclude_From_Invoice__c, Fees_Time__c, Matter__c, Overtime__c, Private_Description__c, Rate__c FROM TimeRecords__c WHERE Name=: ApexPages.currentPage().getParameters().get('id') ];
        
        con=[SELECT Id, Name, MailingStreet, MailingCity, MailingState, MailingPostalCode FROM Contact ];
       
   
    }
    
}

Could someone of you folks help me sort out this error. I have tried many solutions but they don't seem to work.
Thanks in Advance.

SFMani
February 21, 2017
Like
0
Continue reading or reply

39 replies

Error: Unknown constructor 'CustomInv.CustomInv()'

I have a custom controller CustomInv. The Code for this is as below:

public with sharing class CustomInv {
public Opportunity opp{get;set;}

 public List<npe01__OppPayment__c> Rec {get; set;}
 public List<Contact> Contact {get; set;}
 public List<Contact> Contact1 {get; set;}
 public List<Contact> Contact2 {get; set;}

 ApexPages.StandardController standrdCntrl;


 public CustomInv(ApexPages.StandardController cntrl){
 standrdCntrl=cntrl;
 this.opp = (Opportunity) standrdCntrl.getRecord();

Contact = [SELECT Name, AccountId FROM Contact WHERE AccountId=: opp.AccountId and (Title='Primary_M' or Title='Primary_D') limit 1] ;
Contact1 = [SELECT Name, AccountId FROM Contact WHERE AccountId=: opp.AccountId and (Title='Primary_M') limit 1] ;
Contact2 = [SELECT Name, AccountId FROM Contact WHERE AccountId=: opp.AccountId and (Title='Primary_D') limit 1] ;
 Rec =[Select CreatedDate, SystemModstamp,npe01__Payment_Amount__c, npe01__Opportunity__c, npe01__Paid__c, npe01__Scheduled_Date__c FROM npe01__OppPayment__c WHERE npe01__Paid__c = true and npe01__Opportunity__c = : ApexPages.currentPage().getParameters().get('id') limit 200];

}
}

I am using this controller in a Visualforce Component CustComp.vfc with the code:

<apex:component controller="CustomInv" access="global">
<table border="0" cellspacing="0" cellpadding="0" width="100%" id="table1">
<tr>
<td>
<img src='{!URLFOR($Resource.Logo4567687)}' title="logo" />

</td>
{!$Organization.Name} 
{!$Organization.Street} 
{!$Organization.City}
,{!$Organization.State}
{!$Organization.PostalCode}




</tr>

<hr/>

</table>
<table border="0" cellspacing="0" cellpadding="0" width="100%" id="table1">
<tr> <td width="65%">
Federal Tax ID: 27-0580207 
</td>

<td width="50%">Invoice number: <apex:repeat value="{!Opportunity.Invoices__r}" var="line2">
{!line2.name}</apex:repeat> 


Invoice Date: <apex:repeat value="{!Opportunity.Invoices__r}" var="line2">
{!line2.Invoice_Date__c} </apex:repeat></td>


</tr>
</table>

 
<hr/>
Account Information

<table border="0" width="100%" id="table2">
<tr>
<td colspan="3">
Child name: {!Opportunity.Account.Name} 
</td>
</tr>
Parent Name:



<apex:repeat value="{!Contact1}" var="con1">

<apex:repeat value="{!Contact2}" var="con2">
<tr>
<td colspan="3">
 {!IF(((Opportunity.Description=='Mother')||(Opportunity.Description=='mother')||(Opportunity.Description=='Mom')||(Opportunity.Description=='mom')),con1.Name,IF((Opportunity.Description=='Father')||(Opportunity.Description=='father')||(Opportunity.Description=='Dad')||(Opportunity.Description=='dad'),con2.Name, 'con.Name'))} 

{!Opportunity.Account.BillingStreet} 
{!Opportunity.Account.BillingPostalCode} {!Opportunity.Account.BillingCity}

</td>

</tr>

</apex:repeat>
</apex:repeat>

</table>
 
<hr/>
Invoice Detail
<table border="0" width="100%" id="table4">
<tr>
<td bgcolor="#C0C0C0">Item</td>
<td bgcolor="#C0C0C0">Description</td>
<td bgcolor="#C0C0C0">List Price</td>
<td bgcolor="#C0C0C0">Qty</td>
<td bgcolor="#C0C0C0">Total Price</td>
</tr>

<tr>
<apex:repeat value="{!Opportunity.OpportunityLineItems}" var="line">

<tr>
<td>{!line.PricebookEntry.Name}</td>
<td>{!line.Description}</td>
<td>{!line.ListPrice}</td>
<td>{!line.Quantity}</td>
<td><apex:OutputField value="{!line.SubTotal_Price__c}"/></td>
</tr>
</apex:repeat>
</tr>

<tr>

<td bgcolor="#C0C0C0" align="right" colspan="4">
Total: <apex:OutputField value="{!Opportunity.Total_Amount__c}"/></td>
</tr>

</table>
<table border="0" width="100%" id="table4">
<tr>
<td bgcolor="#C0C0C0">Post Date</td>
<td bgcolor="#C0C0C0">Due Date</td>

<td bgcolor="#C0C0C0">Credit</td>

</tr>
<apex:variable value="{!1}" var="rowNum"/>
<apex:repeat value="{!Rec}" var="Pay">
<tr>

<td> {!Pay.npe01__Scheduled_Date__c}
<apex:variable var="rowNum" value="{!rowNum + 1}" /></td>
<td>{!Pay.npe01__Scheduled_Date__c}</td>

<td><apex:OutputField value="{!Pay.npe01__Payment_Amount__c}"/></td>


</tr>
</apex:repeat>

<tr>

<td bgcolor="#C0C0C0" align="right" colspan="2">
Total Credit: <apex:OutputField value="{!Opportunity.npe01__Payments_Made__c}"/></td>
<td bgcolor="#C0C0C0" align="right" colspan="4">
Balance: <apex:OutputField value="{!Opportunity.Balance_Remaining__c}"/></td>
</tr>

</table>
 
<hr/>

Copyright {!$Organization.Name}.
</apex:component>

I need to use this VF Component in a Visualforce Email Template..

But I get the error Unknown constructor 'CustomInv.CustomInv()' in CustComp.vfc

I am unable to identify why it gives this error. Can someone please help?

SFMani
March 15, 2016
Like
0
Continue reading or reply

List has no rows for assignment to SObject with getContent() from pdf

List has no rows for assignment to SObject error

Error: Unknown constructor 'CustomInv.CustomInv()'

Unable to deploy the code into production

Error: Constructor not defined: [ApexPages.StandardController].<Constructor>(List<npe01OppPaymentc>)

Error:Unknown property 'OpportunityStandardController.npe01OppPaymentc'

Trigger for creating automatically creating an invoice when an opportunity is created with amount field filled.

Getting Error while adding AggregateList values to another List

Getting Error while adding AggregateList values to another List

Click to dial within salesforce

List has no rows for assignment to SObject with getContent() from pdf

List has no rows for assignment to SObject error

Error: Unknown constructor 'CustomInv.CustomInv()'