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 Instances

  • Article
  • 2 minutes to read

Details

Table ID: h_sm_reports_instances

Users custom reports within Service Manager's Reports module.

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Created By
h_created_by
 The user who created the record.
Nullable true
Type VARCHAR
Size 100
Indexed true
Date Created
h_date_created
 The creation date of the record.
Nullable true
Type DATETIME
Date Last Modified
h_date_last_modified
 The last updated date of the record.
Nullable true
Type DATETIME
Group By Field
h_groupby_field
 For list charts, this will be the field the list is grouped by (optional)
Nullable true
Type VARCHAR
Size 30
Id
h_id
 Id
Primary Key true
Nullable false
Type INTEGER
One to Many
ReportFavourites
h_sm_reports_favourites.h_instance_id
ReportHistory
h_sm_reports_history.h_instance_id
Last Modified By
h_last_modified_by
 The user who last updated the record.
Nullable true
Type VARCHAR
Size 100
Name
h_name
 The name of a Custom Report.
Nullable true
Type VARCHAR
Size 128
Indexed true
Report Columns
h_query_columns
 Columns that will be presented when viewing a Custom Report.
Nullable true
Type LONGTEXT
Report Id
h_report_id
 Id of the default report that a Custom Report is based on.
Nullable true
Type INTEGER
Report Order
h_query_order
 Column and direction that will be applied when viewing a Custom Report.
Nullable true
Type LONGTEXT
Report Params
h_query_params
 Parameters that will be applied to filter the results.
Nullable true
Type LONGTEXT
Show Reports Configuration section
h_show_config
 Determines whether Reports Configuration section is shown.
Nullable true
Type INTEGER
Show Subtotal
h_show_subtotal
 For list charts, whether to show a subtotal row count per group
Nullable true
Type INTEGER
Show Total
h_show_total
 For list charts, whether to show a total row count
Nullable true
Type INTEGER
Status
h_status
 The status of a Custom Report.
Nullable true
Type VARCHAR
Size 30
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document