You need to sign in to do that
Don't have an account?
Eric 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!
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!