Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Bodhtree1Bodhtree1 

Is there any possibility to pull a field and display it in a graphical format?

For Example:::

 

Can we display all the activities(events,tasks) in a graphical manner..Like which activity should be completed in which month.All the completed activities with one symbol...

Pradeep_NavatarPradeep_Navatar

This can be achieved by creating a custom visualforce page.
Bodhtree1Bodhtree1

Hi Pradeep,

 

Thanks for the Response.Is it possible to get the field Values from the activity history and open activities? Can u provide me simple guide lines regarding how to get those values and use them in a visual force page and display them in a graphical manner.

 

 

Regards,

Vamsi
Pradeep_NavatarPradeep_Navatar

Try the following query :

 

SELECT (SELECT ActivityDate, Description from ActivityHistories) FROM Account WHERE Id = 'xxxxxxxxxxxxxxxxxx'

or

SELECT (SELECT ActivityDate, Description from ActivityHistories) FROM Account WHERE Name Like 'XYZ%'

 

For more details please visit the following links :

 

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_objects_activityhistory.htm

http://www.salesforce.com/us/developer/docs/api/Content/sforce_api_guidelines_archive.htm

 

You can also create custom visualforce dashboard. Please see the following link :

 

http://www.salesforce.com/us/developer/docs/pages/Content/pages_quick_start_basic_dashboard_components.htm

 

Did this answer your question? if so, please mark it solved.