I need to retrieve some data using a nested SOQL, but I can't get the needed data. The SOQL is the following:
SELECT (SELECT Name, Unit_Price__c, Quantity__c, Time__c FROM Valitut_Tuotteet__r) FROM Service_Reservation__c WHERE Room_Reservation__c =: roomRes
I need to extract the Name, Unit_Price__c, Quantity__c and Time__c and show them on a table (apex:repeat). Do you have any idea of how can I access that data?
Using <apex:repeat> and retrieving the fields doesn't work, I guess is because the data structure that the query creates is not a simple List<Service_Reservation__c>.
Any idea on this?