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}}

Connect an AI assistant

Your AI assistant can read this documentation directly, so it answers from the current content instead of guessing. Add one of the servers below to your client — they use the Model Context Protocol (MCP). Each one covers a different body of content, so add the one you need.

The catalog did not load. Refresh the page to try again.

Loading…

How can we help?

{{docApp.searchError}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

 {{docApp.currentResultsSearchText}}  in {{docApp.searchFilterBySpecificBookTitle}}
Found {{docApp.searchResponse.totalResultsAvailable}} matches. Showing the top {{docApp.searchResponse.results ? docApp.searchResponse.results.length : 0}}. Use a more specific search to further narrow down the results.
No documentation pages match this search, so all content types are shown. Most matches are in {{docApp.searchDocTypeRescue.best.name}}.
There is no book with the ID "{{docApp.searchBookRescue.bid}}", so the book filter from this link was ignored and results from all books are shown.

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

  • {{resultItem.title}} {{resultItem.matchedBy === 'semantic' ? 'semantic' : (resultItem.matchedBy === 'both' ? 'keyword + semantic' : 'keyword')}}

    {{resultItem.url}}

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

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

Report Instances

  • Article
  • 1 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