How can we help?
{{docApp.searchError}}
{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
You have an odd number of " characters in your search terms - each one needs closing with a matching " character!-
{{resultItem.title}}
{{resultItem.url}}
{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}
{{docApp.libraryHomeViewProduct.description}}
{{group.title || group.id}}
{{group.description}}
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
Search
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_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 |
Result Columns
h_category_id
h_customer_type
h_datelogged
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 |
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 |
|
||||||||||||||||||||||||||||
Customer |
h_customer_type |
h_fk_user_id |
|
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