You need to sign in to do that
Don't have an account?
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}
You would have to create a custom controller that contains sets created by soql statements.