function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
khushbu dubeykhushbu dubey 

is it correct??

<apex:page standardController="account" recordSetVar="acc">
<apex:pageBlock title="list views">
<apex:pageBlockTable value="{!acc}" var="a6">
<apex:column value="{!a6.industry}"/>
<apex:column value="{!a6.annualrevenue}"/>
<apex:column value="{!a6.website}"/>
<apex:column value="{!a6.fax}"/>
<apex:column value="{!a6.billingaddress}"/>
<apex:column value="{!a6.shippingaddress}"/>
<apex:column value="{!a6.accountowner}"/>
<apex:column value="{!a6.parentaccount}"/>
<apex:column value="{!a6.tickersymbol}"/>
</apex:pageBlockTable>
</apex:pageBlock>
  
</apex:page>

User-added image
Pankaj_GanwaniPankaj_Ganwani
Hi Khushbu,

BillingAddress and MailingAddress are not actual fields on Account or Contact objects. These fields are combination of street, city, state, country and postalcode fields. To access address field values in code you will have to refer each of these fields separately in vf page.

<apex:column value="{!a6.BillingCountry}"/>
<apex:column value="{!a6.BillingCity}"/>
---
---
and so on and same will be applied for Mailing and Shipping addresses as well.
Tavva Sai KrishnaTavva Sai Krishna
Dear Khushbu,

Billing address is not supported field in account object. Find the below code
  
<apex:page standardController="account" recordSetVar="acc">
<apex:pageBlock title="list views">
<apex:pageBlockTable value="{!acc}" var="a6">
<apex:column value="{!a6.industry}"/>
<apex:column value="{!a6.annualrevenue}"/>
<apex:column value="{!a6.website}"/>
<apex:column value="{!a6.fax}"/>
<apex:column value="{!a6.billingstreet}+{! a6.billingstate}+{! a6.billingCountry}" headerValue=" BillingAddress"/>
<apex:column value="{!a6.shippingstreet}+{! a6.shippingstate}+{! a6.shippingCountry}" headerValue="ShippingAddress"/>
<apex:column value="{!a6.owner.name}"/>
<apex:column value="{!a6.parent.name}"/>
<apex:column value="{!a6.tickersymbol}"/>
</apex:pageBlockTable>
</apex:pageBlock>
  
</apex:page>

Regards,
Sai Krishna Tavva
Amit Chaudhary 8Amit Chaudhary 8
Please check below post to see Account field API name. Please check below post for Account field API name
1) https://developer.salesforce.com/docs/atlas.en-us.api.meta/api/sforce_api_objects_account.htm

Please try below code. i hope that will help you 
<apex:page standardController="account" recordSetVar="acc">
	<apex:pageBlock title="list views">
		<apex:pageBlockTable value="{!acc}" var="accObj">
			<apex:column value="{!accObj.industry}"/>
			<apex:column value="{!accObj.annualrevenue}"/>
			<apex:column value="{!accObj.website}"/>
			<apex:column value="{!accObj.fax}"/>
			<apex:column value="{!accObj.ownerid}"/>
			<apex:column value="{!accObj.ParentId}"/>

			<apex:column value="{!accObj.BillingStreet}"/>
			<apex:column value="{!accObj.BillingState}"/>
			<apex:column value="{!accObj.BillingCity}"/>
			<apex:column value="{!accObj.BillingCountry}"/>
			<apex:column value="{!accObj.BillingPostalCode}"/>

			<apex:column value="{!accObj.ShippingStreet}"/>
			<apex:column value="{!accObj.ShippingState}"/>
			<apex:column value="{!accObj.ShippingCity}"/>
			<apex:column value="{!accObj.ShippingCountry}"/>
			<apex:column value="{!accObj.ShippingPostalCode}"/>
		</apex:pageBlockTable>
	</apex:pageBlock>
</apex:page>

I see you are facing same issue in multipe post due to invalid field name. It better Search Object API field Name from Google.

How can I find the API name of a field?
https://help.salesforce.com/apex/HTViewSolution?id=000007594&language=en_US

To find a field's API name for custom objects, please follow these steps:
      1. Go to Setup | Create | Objects | <Object> | Fields 
      2. And check for "API name" column name value

Let us know if this will help you

Thanks
Amit Chaudhary
 
Nagendra ChinchinadaNagendra Chinchinada
You can't access billingaddress, ShippingAddress fields from VF page since they are compound fields.

1) Access fields individually for both billing, shipping addresses like below,
  
<apex:column value="{!a6.billingStreet}"/>
<apex:column value="{!a6.billingCity}"/>
<apex:column value="{!a6.billingState}"/> 
<apex:column value="{!a6.billingPostalCode}"/> 



<apex:column value="{!a6.shippingStreet}"/>
<apex:column value="{!a6.shippingCity}"/>
<apex:column value="{!a6.shippingState}"/> 
<apex:column value="{!a6.shippingPostalCode}"/>



2) You can give concatinated string in Value also, 
​<apex:column value="{!a6.shippingStreet +', '+ a6.shippingCity +', '+ a6.shippingState +', '+ !a6.shippingPostalCode}"/>