Apex Code Development You need to sign in to do that
Don't have an account?
MartinK OpportunityLineItems Not Displaying on a Public Site (okay in regular VF Page)
Hello, I have a very simple VF Page that displays an opportunity and the opportunity line items. It works great when run within Salesforce, but when run on a public site the opportunity line items do not show up. I have checked the public access settings and do not see Opportunity Line Items as standard object that I can grant permissions to. Is this implied since I have granted permissions on the Opportunity? Are public sites able to display opportunity products? Any suggestions on how to trobleshoot this. A simplified version of the VF page is below. Thank you so much for your help!
<apex:page standardController="Opportunity">
<apex:pageBlock >
<apex:pageBlockSection columns="2" >
<apex:outputField value="{!Opportunity.name}"/>
</apex:pageBlockSection>
<apex:pageBlockSection >
<apex:pageBlockTable value="{!Opportunity.OpportunityLineItems}" var="item">
<apex:column value="{!item.Description}"/>
</apex:pageBlockTable>
</apex:pageBlockSection>
</apex:pageBlock>
Ankit,
I solved the problem, thank you so much for your help. In order to have access to opportunity line items, pricebooks must have access. Thank you for your help!
All Answers
Hi MartinK,
I am unable to understand what exactly you want to say but I tried this on my org.I changed the code a bit.
I have given name to this visualforce page "OppShow" . Then I just added the page in my Site Profile (Setup > App Setup > Develop > Sites > Click on your site > Edit "Site Visualforce Page" > Add "OppShow").
After this just hit the site URL apending
yourSiteURL/apex/ShowOpp?id="any opportunityId which have line item"
And it shows me opportunity name and its line items.
<apex:page standardController="Opportunity"> <apex:pageBlock > <apex:pageBlockSection columns="2" > <apex:outputField value="{!Opportunity.name}"/> </apex:pageBlockSection> <apex:pageBlockSection> <apex:pageBlockTable value="{!Opportunity.OpportunityLineItems}" var="item"> <apex:column value="{!item.TotalPrice}"/> </apex:pageBlockTable> </apex:pageBlockSection> </apex:pageBlock> </apex:page>Hope this will resolve your problem.
Thanks
Ankit Arora
Blog | Facebook | Blog Page
Ankit,
Thank you so much. The suggestion you gave has the same problem where the Opportunity Line Items renders when the VF page is run in the Salesforce App but does not render when accessed via a public site (the rest of the page renders fine).
Since it is working for you, it leads me to believe the problem is in my access or security settings. I have the Opportunity and Products Objects all given read access to the Guest User Profile and all fields are marked as visible.
The only clue I have is that I do not see a way to give explicit read access to the OpportunityLineItems object in the public access settings. With this in mind I would think that public access on the OportunityLineItem just matches that on the Opportunity. My guess is that I am missing a checkbox configuration parameter somewhere, I just don't know where else to look.
Again thanks so much for your help.
Best Regards,
Martin
I hope you have not missed these step I want you to verify it again.
1) Custom page should be enabled for Guest Profile
2) Field-Level Security > Opportunity Line Item > All fields should have visible rights for Guest Profile
3) Opportunity have "Read" , "Create" rights for Guest Profile
Thanks
Ankit Arora
Blog | Facebook | Blog Page
Ankit,
Step 1 and 3 I have done. I do not have the option to do step 2:
2) Field-Level Security > Opportunity Line Item > All fields should have visible rights for Guest Profile
I can set field level security (and standard object permissions) for Opportunity Product and Product but not OpportunityLineItems. My profile is Systems Administrator. Can you confirm that you have the ability to see/modify the OpportunityLineItem field visibility. If you do this is my problem.
Yes, I can see/Modify opportunity line item FLS. Please make sure on which edition you are working. Is it Developer Edition of Enterprise Edition.
Thanks
Ankit Arora
Blog | Facebook | Blog Page
Ankit,
I solved the problem, thank you so much for your help. In order to have access to opportunity line items, pricebooks must have access. Thank you for your help!