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 History

  • Article
  • 1 minutes to read

Details

Table ID: h_sm_reports_history

Users history of reports within Service Manager's Reports module.

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Category ID
h_category_id
 The category ID of the report
Nullable false
Type INTEGER
Indexed true
Category Name
h_category_name
 The category name of the report
Nullable true
Type VARCHAR
Size 128
Indexed true
Document ID
h_doc_id
 ID of the Report Document in Document Manager
Nullable true
Type VARCHAR
Size 32
Indexed true
Document Revision
h_doc_revision
 Revision of the Report Document in Document Manager
Nullable true
Type INTEGER
Instance ID
h_instance_id
 The report instance ID
Nullable true
Type INTEGER
Indexed true
Instance Name
h_instance_name
 The report instance name
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
Query Params
h_query_params
 Additional params to run against the report
Nullable true
Type LONGTEXT
Report History Id
h_id
 The unique Id for the report
Primary Key true
Nullable false
Type INTEGER
Report ID
h_report_id
 The report ID
Nullable false
Type INTEGER
Indexed true
Report Name
h_report_name
 The report name
Nullable true
Type VARCHAR
Size 128
Indexed true
Report timestamp
h_timestamp
 The time this report has been saved
Nullable false
Type DATETIME
Indexed true
User ID
h_user_id
 The ID of the user that run the report
Nullable false
Type VARCHAR
Size 100
Indexed true
User name
h_user_name
 The name of the user that run the report
Nullable true
Type VARCHAR
Size 190
Indexed true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document