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

Reports

  • Article
  • 1 minutes to read

Details

Table ID: h_sm_reports

The available reports within Service Manager's Reports module.

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Allow Configuring Columns
h_allow_columns_config
 Determines whether columns can be configured for this report.
Nullable false
Type INTEGER
Chart type
h_chart_type
 The chart type of the report
Nullable true
Type VARCHAR
Size 50
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
 This is the last modified date of the report
Nullable true
Type DATETIME
Display Columns
h_display_columns
 A list of column metadata to display for the report, held in a JSON string
Nullable true
Type VARCHAR
Size 1024
Last Modified By
h_last_modified_by
 The user id of the user who last modified the report
Nullable true
Type VARCHAR
Size 100
Name
h_name
 This is the name of the report
Nullable true
Type VARCHAR
Size 128
Indexed true
Query
h_query
 This is the name of the query of the report
Nullable true
Type VARCHAR
Size 128
Report Category Id
h_report_category_id
 The report category's primary key
Nullable true
Type INTEGER
Report Id
h_id
 The unique Id for the report
Primary Key true
Nullable false
Type INTEGER
Status
h_status
 This is the status of the report
Nullable true
Type VARCHAR
Size 30
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document