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
Eric Anderson 54Eric Anderson 54 

Visualforce display on all items in related list

I have a Visualforce page that I need to display summary data of objects within a parent. As part of the Child object, there is an activity object. That Activity object might include:
Running
Sleeping
Eating
Studying
Recreating

I am required to create an output that shows how many TOTAL hours, each object did. I am required to show, each activity even if there were no hours related to that related list entry. So if the parent object had no hours related to 'Recreating' for instance, I need to show on the display '0' hours. I've tried doing this with a SOQL statement, but it keeps telling me that Activity__c is not valid. I'm trying a 'Select Name from Activity__c' to drive a second SOQL Statement that then goes against the parent oject which in this case is 'Requests' in the form of something like 'Select hours__c from Requests__c where Actvity__c=:Activity__c.id' or something like that. .

I understand why this may not be possible, but I want to know if I am missing something.

Thanks for your time in regards to this!

- Eric Anderson -

Thanks!