+ Start a Discussion
Mattias NordinMattias Nordin 

Is it possible to create a visual force page containing information from three different objects?

Is it possible to create a visual force page containing information from three different objects?

 

I want to show some details from the Opportunity.

Some details from SAP__c

Some details from SFDC_520_Quote__c

 

The SAP__c object has a reference to the SFDC_520_quote__c object BUT there is no reference between the quote object and the opportunity (except the opportunity id). A script populate the opportunity with data when the quote is saved (custom solution).

 

 

SAP_id is the only input i have. I guess the other data would be accessable via something like...

 

SAP info --> SELECT A, quote_id FROM SAP__c WHERE SAP_ID = "123"

 

Quote info --> SELECT A, opportunity_id FROM SFDC_520_quote__c WHERE quote_id = variableQuoteId

 

Opportunity info --> SELECT A, B, C FROM Opportunity WHERE opportunity_id = variableOpportunityId

 


My goal is to display the following information on my visual force email template:

 

{!SAP.name}

{!SAP.created_date}

 

{!QUOTE.name}

{!QUOTE.created_date}

 

{!OPPORTUNITY.name}

{!OPPORTUNITY.created_date}

cl0s3rcl0s3r

You would have to create a custom controller that contains sets created by soql statements.