Possible to have "room type name" in ical feed?

Hi,
I've managed to customize the ical feed to display reservations in a Google Calendar. I'm able to find first name, last name, etc. inside of the $reservation array in the file:
/plugins/solidres/ical/components/com_solidres/controllers/ical.php
...but I'm unable to find the "room_type_name", or the room number that the guest is assigned to. (This would also be the room number found in "Room/Extra Info" under a guest's reservation: cloudup.com/cP4Tod7Exv0 )

Could you provide a hint or point me in the correct direction for adding this data into the ical feed please?
Thank you!
~J.

Hi,

The room type name is stored in a different table "#__sr_reservation_room_xref" therefore you need to query from it to retrieve the room type info, each reservation could have one or multiple assigned room types.

Regards,

Great. I got it. In the file:
/plugins/solidres/ical/components/com_solidres/controllers/ical.php
...in the function:
getReservations()
...I changed the select query from:...to:
I was then able to access room_label in the $reservations array.

Thanks for the help!

Hi,

It is great to see you got it!

We will consider adding support for it soon.

Regards,