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

Charts

  • Article
  • 1 minutes to read

Details

Table ID: h_itsm_charts

Stores the definition of Charts used on the request list and in app reporting.

Table Attributes

Name Value
Primary Key h_pk_id

Columns

Name & ID Description Column Attributes Relationships
Chart Axis
h_chart_axis
 The chart axis. This value is the column that will be used to group the results of a filter by.
Type VARCHAR
Size 100
Nullable true
Chart Definition
h_chart
 The definition of the Fusion Chart.
Type LONGTEXT
Nullable true
Chart Order
h_chart_index
 Order of the chart (Used in "reportsFilter" feature).
Type INTEGER
Nullable true
Chart Type
h_chart_type
 The chart type. For example, column2d, column3rd or bar2d.
Type VARCHAR
Size 64
Nullable true
Chart Visibilty
h_chart_visible
 Determines whether the chart is visible in the view user.
Type INTEGER
Nullable true
Created On
h_datelogged
 Creation date of the record.
Type DATETIME
Nullable true
Feature
h_feature
 The feature that the chart will be used in. The options are "requestListFilter" and "reportsFilter".
Type VARCHAR
Size 20
Nullable true
Indexed true
Filter Id
h_filter_id
 Id of the filter (h_itsm_genericfilters.h_pk_id for "requestsListFeature" feature and h_sm_reports_instances.h_id for "reportsFeature" feature) for the respective feature.
Type INTEGER
Nullable true
Indexed true
Id
h_pk_id
 Id
Type INTEGER
Nullable false
Primary Key true
One to Many
DashboardCharts
h_sm_dashboard_charts.h_chart_id
Owner Id
h_chart_owner
 Id of the user who owns the chart.
Type VARCHAR
Size 100
Nullable true
Indexed true
Title
h_chart_title
 Title of the chart.
Type VARCHAR
Size 150
Nullable true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document