Difference between revisions of "Entity Explorer"
Jump to navigation
Jump to search
| (11 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
| + | This document can now be found at its new location in the [https://docs.hornbill.com/esp-config/advanced-tools-and-settings/entity-explorer/ Hornbill Document Library]. | ||
| + | |||
| + | [[file:hornbill-document-library.png|Entity Explorer|link=https://docs.hornbill.com/esp-config/advanced-tools-and-settings/entity-explorer/]] | ||
| + | <!-- | ||
<div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | <div style="border:1px solid #90C0FF; background:#D0E0FF; width:99%; padding:4px; margin-bottom:10px;"> | ||
| − | __NOTOC__[[Main Page|Home]] > [[Administration]] > Hornbill Application > | + | __NOTOC__[[Main Page|Home]] > [[Administration]] > Hornbill Application > Entity Explorer |
</div> | </div> | ||
{|style="width: 100%" | {|style="width: 100%" | ||
| Line 8: | Line 12: | ||
Each Hornbill application is delivered with access to its database schema and entity relationships. This is useful when trying to understand where to identify tables, table columns, primary keys, and suitable fields for making your table joins. This functionality is intended to make your quest for information that little bit easier when constructing those all important analytics and management reports. | Each Hornbill application is delivered with access to its database schema and entity relationships. This is useful when trying to understand where to identify tables, table columns, primary keys, and suitable fields for making your table joins. This functionality is intended to make your quest for information that little bit easier when constructing those all important analytics and management reports. | ||
| − | Accessing the Entity | + | Accessing the Entity Explorer in the Administration Tool is only open to users who are assigned the '''Advanced Reporting Admin''' role and a '''secondary role''' that has the ''Execute Stored Queries'' and ''Update Records'' system rights. Apart from high security roles, the latter can be a default role (which has these system rights) or custom created role. |
|style="width:5%"| | |style="width:5%"| | ||
| | | | ||
| Line 14: | Line 18: | ||
== Related Articles == | == Related Articles == | ||
| − | :* [ | + | :* [https://docs.hornbill.com/esp-config/advanced-tools-and-settings/database-direct Database Direct] |
:* [[View_Table_Structure|Hornbill How To: Viewing Table Structures]] | :* [[View_Table_Structure|Hornbill How To: Viewing Table Structures]] | ||
|} | |} | ||
| Line 23: | Line 27: | ||
* '''Database Schema Information''' - a simple description of each application table. Understand more about the columns contained in the tables including a supporting description, type, and information on which columns are indexed. | * '''Database Schema Information''' - a simple description of each application table. Understand more about the columns contained in the tables including a supporting description, type, and information on which columns are indexed. | ||
| + | --> | ||
| + | [[Category:HDOC]] | ||
Latest revision as of 18:43, 11 April 2024
This document can now be found at its new location in the Hornbill Document Library.
