Documentation
    {{docApp.userSession.userId}}
    {{docApp.userSession.userName}}
    {{docApp.userSession.email}}
    Issuer : {{docApp.userSession.issuerInstance}}
    Expires : {{new Date(docApp.userSession.validUntil).toLocaleDateString()}}

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

{{book.title}}
More...

Report Schedule

  • Article
  • 1 minutes to read

Details

Table ID: h_sm_reports_schedule

Scheduling of reports within Service Manager's Reports module.

Table Attributes

Name Value
Primary Key h_job_id

Columns

Name & ID Description Column Attributes Relationships
Category ID
h_category_id
 The category ID of the report
Nullable false
Type INTEGER
Document Manager
h_flg_dm
 Whether to store the Report in Document Manager
Nullable true
Type VARCHAR
Size 128
Email Details
h_email_details
 The configuration of email details of a scheduled in-app report
Type LONGTEXT
Nullable true
Flag Email
h_flg_email
 Whether to email the Report to Enterprise Users
Nullable true
Type VARCHAR
Size 128
Instance ID
h_instance_id
 The report instance ID
Nullable true
Type INTEGER
One to One
ReportInstances
h_sm_reports_instances.h_id
Query
h_query
 This is the name of the query of the report
Nullable true
Type VARCHAR
Size 128
Report ID
h_report_id
 The report ID
Nullable false
Type INTEGER
One to One
Reports
h_sm_reports.h_id
Schedule Job Id
h_job_id
 The Id for the scheduled job
Primary Key true
Nullable false
Type INTEGER
Type
h_type
 Whether the job creates pdf/html
Nullable false
Type VARCHAR
Size 128
User ID
h_user_id
 This is the id of the user who scheduled the report
Nullable true
Type VARCHAR
Size 100
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document