ROQL report on Holiday table in report
SummarySELECT H.Name, H.HolidayDate FROM Holiday H
Since the Holiday table is not available for analytics by default, I'm trying to create a report on this through ROQL.
I have the query working in the Connect Object Explorer but I'm having dificulties creating a new report that soly exsists out of a ROQL query.
$roql_result = RightNow\Connect\v1_3\ROQL::query( "SELECT H.Name, H.HolidayDate FROM Holiday H" )->next();
while($holiday = $roql_result->next())
$rows->val = $holiday['Name'];