{"id":2223,"date":"2010-04-15T23:56:09","date_gmt":"2010-04-15T18:56:09","guid":{"rendered":"http:\/\/www.chiragmehta.info\/chirag\/?p=2223"},"modified":"2010-04-16T00:02:02","modified_gmt":"2010-04-15T19:02:02","slug":"visualforce-adding-history-related-list-to-tabbed-account","status":"publish","type":"post","link":"https:\/\/www.chiragmehta.info\/chirag\/2010\/04\/15\/visualforce-adding-history-related-list-to-tabbed-account\/","title":{"rendered":"Visualforce – Adding History related list to Tabbed Account"},"content":{"rendered":"

Problem Statement<\/strong>
\nHas anyone been able to generate the “account history” tab in visualforce page? If i try using “Histories” in <apex:relatedList>, I get error msg saying it is not valid child relation name..<\/p>\n

Solution1<\/strong>
\nThis works for me to add a link to the account field history:<\/p>\n

\n<apex:tab label=”Field History” name=”Field History” id=”fieldhistory”>
\n<apex:outputLink value=”https:\/\/na1.salesforce.com\/_ui\/common\/history\/ui\/EntityHistoryFilterPage?id={!account.id}”>
\nclick to view field history
\n<\/apex:outputLink>
\n<\/apex:tab><\/p><\/blockquote>\n

Not optimum as user has to click the link but you dont need to do a lot of work.<\/p>\n

Solution2<\/strong>
\nI also figured out how to access the Account History data. It is NOT a related list. Instead, use the code <apex:dataTable> to pull from the account.histories table. Below is rough code that will pull the Account History into a separate tab. The HTML formating is not very clean, but the data query works!:<\/p>\n

\n<apex:tab label=”Field History” name=”Account History” id=”fieldhistory” >
\n<apex:dataTable value=”{!account.histories}” var=”accounthistory” id=”HistTable” rowClasses=”odd,even”
\nstyleClass=”tableClass” cellspacing=”15″ width=”80%”>
\n<apex:facet name=”caption”><\/apex:facet>
\n<apex:facet name=”header”>Field History<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<apex:column>
\n<apex:facet name=”header”>Edit Date<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<apex:outputText value=”{0,date,MM\/dd\/yyyy HH:mm }”>
\n<apex:param value=”{!accounthistory.createddate}” \/>
\n<\/apex:outputText>
\n<\/apex:column>
\n<apex:column>
\n<apex:facet name=”header”>Field<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<b> <apex:outputText value=”{!accounthistory.field}”\/><\/b>
\n<\/apex:column>
\n<apex:column>
\n<apex:facet name=”header”>Edited By<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<apex:outputText value=”{!accounthistory.createdby.name}”\/>
\n<\/apex:column>
\n<apex:column>
\n<apex:facet name=”header”>Old Value<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<apex:outputText value=”{!accounthistory.oldvalue}”\/>
\n<\/apex:column>
\n<apex:column>
\n<apex:facet name=”header”>New Value<\/apex:facet>
\n<apex:facet name=”footer”><\/apex:facet>
\n<apex:outputText value=”{!accounthistory.newvalue}”\/>
\n<\/apex:column>
\n<\/apex:dataTable>
\n<\/apex:tab><\/p><\/blockquote>\n

Source : Salesforce Community<\/p>\n","protected":false},"excerpt":{"rendered":"

Problem Statement Has anyone been able to generate the “account history” tab in visualforce page? If i try using “Histories” in <apex:relatedList>, I get error msg saying it is not valid child relation name.. Solution1 This works for me to add a link to the account field history: <apex:tab label=”Field History” name=”Field History” id=”fieldhistory”> <apex:outputLink […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32],"tags":[169],"class_list":["post-2223","post","type-post","status-publish","format-standard","hentry","category-salesforce","tag-salesforce","post-preview"],"_links":{"self":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/comments?post=2223"}],"version-history":[{"count":6,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2223\/revisions"}],"predecessor-version":[{"id":2225,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/posts\/2223\/revisions\/2225"}],"wp:attachment":[{"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/media?parent=2223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/categories?post=2223"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chiragmehta.info\/chirag\/wp-json\/wp\/v2\/tags?post=2223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}