Database Direct
Jump to navigation
Jump to search
Home > Configuration > Platform Configuration > Data > Database Direct | Index |
Using Database Direct
Once enabled, Database Direct can be found via Home > System > Data > Database Direct. The key features are outlined below.
- Query Editor - type your SQL query here
- Data Format menu - choose whether raw data values are displayed (e.g. boolean flags will appear as 0 or 1) or if data formatters are to be applied (e.g. No or Yes). Not all data is subject to data formating.
- Clear - Clears the current query in the query pane and result set.
- Execute - Execute the query that exists in the query pane
- Execute Selected Text - if more than one query exists in the query pane, highlighting the query and using this button will execute the highlighted query.
- Table filter - filter the list of Hornbill tables by typing in text.
- Table List - Shows all the tables available based on the applications you have installed on your instance.
- Manage Saved Queries - If you have saved any queries, you can manage them here.
- Show/Hide Query Editor - Toggle whether the query editor is displayed or not. This may be useful when examining larger result sets.
- Show/Hide Table List - Toggle whether the table list is displayed or not. This may be useful when examining larger result sets.
- Save Query - Saves the current content of the Query Editor
- Query Limit - all queries executed in database direct are subject to a limit, adjust the number of records returned here.
- Result Quick Filter - Filter the results set currently displayed.
- Column Display - When examining your result set, choose to display friendly column display names or raw column database names.
- Export - export your result set to a variety of formats including CSV.
- Result Set - The set of results returned by the last query you executed.