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