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

Entity Details: Requests

  • Article
  • 3 minutes to read

Description

This defines the entity for the Requests

Details

  • Application Reference: com.hornbill.servicemanager
  • Table: h_itsm_requests
  • Display Name: Requests

Entity Options

  • Enable Webhooks: true
  • Visible To Reporting: false (default)
  • Enable Business Rules: false (default)
  • Disable Direct Access: false (default)

Entity Name List

  • ID Column: h_pk_reference
  • Filter: No filter
  • Columns:
    • No entity name list columns have been specified.

Access Control

No access controls have been defined.

Entity Access Control

  • Privilege Level: user

Browse

app.h.searchEntityRecords

Update

app.h.updateEntityRecord

Delete Record

app.h.deleteEntityRecord

Search and Browse Control

Filter

No search filter has been defined.

Searchable Columns

  • h_container_id
  • h_dateclosed
  • h_datelastmodified
  • h_datelogged
  • h_dateresolved
  • h_external_ref_number
  • h_fk_team_id
  • h_fk_user_id
  • h_fk_user_name
  • h_fk_serviceid
  • h_impact
  • h_urgency
  • h_ownerid
  • h_pk_reference
  • h_request_prefix
  • h_requesttype
  • h_status
  • h_source_id
  • h_source_type
  • h_sub_status
  • h_sub_status_id

Result Columns

  • h_actions_control
  • h_bpm_id
  • h_category
  • h_category_id
  • h_closure_category
  • h_closure_category_id
  • h_container_id
  • h_dateclosed
  • h_datelogged
  • h_dateresolved
  • h_date_submitted
  • h_description
  • h_fixby
  • h_fixtime
  • h_fixtimeid
  • h_fk_servicelevelname
  • h_fk_team_id
  • h_fk_user_id
  • h_fk_serviceid
  • h_historic
  • h_impact
  • h_impact_id
  • h_urgency
  • h_urgency_id
  • h_locked_details
  • h_ownerid
  • h_onholduntil
  • h_pk_reference
  • h_rating
  • h_request_prefix
  • h_requesttype
  • h_resolution
  • h_respondby
  • h_responsetime
  • h_responsetimeid
  • h_site
  • h_site_id
  • h_status
  • h_sub_status
  • h_sub_status_id
  • h_summary
  • h_withinfix
  • h_withinresponse
  • h_external_ref_number
  • h_source_id
  • h_source_type

Free Text Index

  • Index Storage: HornbillITSM
  • Index Document Reference Column: h_idx_ref

Indexed Columns

Name Tokenized Search Key
h_category_id false
h_customer_type false
h_datelogged false
h_datelastmodified false
h_dateclosed false
h_description false
h_external_ref_number false
h_fk_serviceid false
h_fk_servicename false
h_fk_team_id false
h_fk_team_name false
h_fk_user_id false
h_fk_user_name false
h_ownerid false
h_ownername false
h_pk_reference false
h_requesttype false
h_site_id false
h_status false
h_summary false
h_archived false

Result Columns

  • h_category_id
  • h_customer_type
  • h_datelogged
  • h_datelastmodified
  • h_dateclosed
  • h_description
  • h_external_ref_number
  • h_fk_serviceid
  • h_fk_servicename
  • h_fk_team_id
  • h_fk_team_name
  • h_fk_user_id
  • h_fk_user_name
  • h_ownerid
  • h_ownername
  • h_pk_reference
  • h_request_prefix
  • h_requesttype
  • h_site_id
  • h_status
  • h_summary

File Attachment Store

  • Store ID: fs_entity
  • Timeout: PT10S
  • Key Expression: Not specified

Activity Stream

  • Visibility: public
  • Record Display Name: {%h_requesttype%} {%h_pk_reference%}
  • Activity Stream Reference Column: h_activity_stream_id
  • Contact Reference Column: none
  • Access Token Timeout: P0DT4H0M0S

Data Change Log

  • Data Change Log Table: h_itsm_requests_change_log

Data Change Log Columns

  • h_fk_priorityid
  • h_fk_team_id
  • h_ownerid
  • h_urgency_id
  • h_impact_id
  • h_status
  • h_sub_status_id
  • h_hai_sentiment

Entity Relationships

One-to-One

Name Related Entity Reference Key Foreign Key Mandatory Managed
Extended Information RequestsExtended h_request_id h_pk_reference true true
owner Colleagues h_user_id h_ownerid false false
RaisedBy Colleagues h_user_id h_createdby false false
Organization Container h_id h_container_id false false
Customer Contact Contact h_pk_id h_fk_user_id false false
Customer Coworker Colleagues h_user_id h_fk_user_id false false
RequestLastActivity RequestLastActivity h_id h_last_update_activity_id false false
RequestSite Sites h_id h_site_id false false

One-to-Many

Name Related Entity Reference Key Foreign Key Mandatory Managed
Assignments RequestAssignments h_request_id h_pk_reference false true
Attachments RequestAttachments h_request_id h_pk_reference false true
BoardCards BoardCards h_request_id h_pk_reference false true
Connections RequestConnections h_request_id h_pk_reference false true
Members RequestMembers h_request_id h_pk_reference false true
HistoricUpdates RequestHistoricUpdates h_fk_reference h_pk_reference false true
HistoricUpdateAttachments RequestHistoricUpdateAttachments h_callref h_pk_reference false true
Published Requests PublishedRequests h_request_id h_pk_reference false true
ServiceLevelTargets RequestSLMTargets h_request_id h_pk_reference false true
Questions Questions h_entity_ref h_pk_reference false true
RequestFeedback RequestFeedback h_request_id h_pk_reference false true
RequestEmailContacts RequestEmailContacts h_request_id h_pk_reference false true
ServiceLevelEvents RequestSLMEvt h_request_id h_pk_reference false true
ServiceLevelArchive RequestSLMArchive h_request_id h_pk_reference false true
RequestTimers RequestTimers h_request_id h_pk_reference false true
RequestBPMEvt RequestBPMEvt h_request_id h_pk_reference false true
Team Assignment TeamAssignment h_request_id h_pk_reference false true
RequestApprovers RequestApprovers h_request_id h_pk_reference false true
Statuses Statuses h_status_id h_sub_status_id false false
Assessments RequestAssessments h_request_id h_pk_reference false true
RequestNotices RequestNotices h_request_id h_pk_reference false true

Many-to-One

Name Related Entity Reference Key Foreign Key Mandatory Managed Mapped Values
Team Team h_id h_fk_team_id false false No mapped values defined
Priority Priority h_pk_priorityid h_fk_priorityid false false No mapped values defined
Services Services h_pk_serviceid h_fk_serviceid false false No mapped values defined

Dynamic One-to-One

Name Dynamic Value Column Foreign Key Related Entities
Call Type h_requesttype h_pk_reference
Dynamic ValueReference KeyEntity NameManaged
Incidenth_fk_referenceIncidentstrue
Service Requesth_fk_referenceServiceRequeststrue
Change Requesth_fk_referenceChangeRequeststrue
Releaseh_fk_referenceReleasestrue
Problemh_fk_referenceProblemstrue
Known Errorh_fk_referenceKnownErrorstrue
Customer h_customer_type h_fk_user_id
Dynamic ValueReference KeyEntity NameManaged
0h_user_idColleaguesfalse
1h_pk_idContactfalse

Self Many-to-Many

Name Linking Table Left Column Right Column Managed
relatedRequests h_sm_relationship_entities h_entity_id h_linked_entity_id true
  • Version {{docApp.book.version}}
  • Node {{docApp.node}} / {{docApp.build}}
In This Document