Documentation

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

Favourite Reports

Details

Table ID: h_sm_reports_favourites

Users favourite 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_user_id
The user who created the record.
Nullable true
Type VARCHAR
Size 100
Date Created
h_date_created
The creation date of the record.
Nullable true
Type DATETIME
Report Favourite Id
h_id
The unique Id for the favourited report
Primary Key true
Nullable false
Type INTEGER
Report Id
h_report_id
The favourited report's primary key
Nullable true
Type INTEGER
Report Instance Id
h_instance_id
The unique Id for the report istance
Nullable true
Type INTEGER
In This Document