You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ROQL report on Holiday table in report

Accepted answer
33
Views
8
Comments
edited Dec 11, 2018 1:13PM in Integrations and APIs 8 comments

Summary

SELECT H.Name, H.HolidayDate FROM Holiday H

Content

Hi there.

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.

Initialisation

require_once(get_cfg_var('doc_root')."/ConnectPHP/Connect_init.php");
initConnectAPI();

Process

$roql_result = RightNow\Connect\v1_3\ROQL::query( "SELECT H.Name, H.HolidayDate FROM Holiday H" )->next();
while($holiday =  $roql_result->next())
{
$rows[0][0]->val = $holiday['Name'];

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!