• KoellerD
  • NEWBIE
  • 5 Points
  • Member since 2013

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 4
    Replies

Hi,

 

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?

 

Greetings,

 

MGA.

I use a dark color scheme with debian and it's made it difficult to see the eclipse IDE (force IDE). Is there no way to customize the color settings? Seems silly, as *every* other editor I use allows this.