How can we help?
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!
-
{{resultItem.title}}
{{resultItem.url}}
{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}
{{docApp.libraryHomeViewProduct.description}}
{{group.title || group.id}}
{{group.description}}
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 important analytics and management reports.
Accessing the Entity Explorer in Configuration 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.
Features
- Entity Information
Provides a visual interface to explore the application tables and how they relate to each other. A quick way to identify extended tables and the columns that create table links. Click on a table and use the “Description” and “Information” buttons at the top right of the graphical user interface to explore each table in more detail. - 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.
- Version {{docApp.book.version}}
- Node {{docApp.node}} / {{docApp.build}}