Last updated 11 November 2020.
Introduction to DockPanel Navigation for V8 Search XE
Navigation Explorer provides a hierarchical interface for viewing and managing the objects in each instance of SQL Server (1) and displays the number and types of Dynamics objects (2) imported.
In the databases, the display is limited to tables, views and stored procedures. In the Dynamics databases, there is a special folder called "Dynamics NAV Meta Object". Metadata is object definition in xml format, User Code is application code written in C# .Net format and User AL Code store codes which we write in C/AL editor (Developer Environment’s Object Designer).
Only a system administrator/local host administrator is able to perform all checks or functions.
This code and information are provided "AS IS" without warranty of any kind, either expressed or implied. Furthermore, the author or Olav Treffurt IT Consulting shall not be liable for any damages you may sustain by using this information, whether direct, indirect, special, incidental or consequential, even if it has been advised of the possibility of such damages.
Contains the following informational sections:
Default: Not enabled
"Pane SQL Server Objekt-Explorer": Displays objektes in a tree structure
Object Explorer provides a hierarchical user interface for viewing and managing objects in all instances of SQL Server. The Object Explorer Details pane provides a tabular view of instance objects and a feature to search for specific objects.
The Object Explorer uses a tree structure to group information in folders. To expand folders, click the plus sign (+) or double-click the folder. Expand folders to view more detailed information.
You can only search for an object if you have previously opened an account. The objects are read at runtime and can therefore only be searched for after they have been completely loaded into the structure.
You perform actions on objects by clicking directly on the Object Explorer node that represents the object. Only the "Dynamics NAV Meta Object" type supports a unique set of right-click actions.
If the search term is found, the name containing the search term is marked and activated at the same time.
If you have opened the tool window "Nav Table Properties" in parallel, the Dynamics NAV object will be landed in parallel. Here is a list of some of the relevant data for the table. For example, the key or the trigger in the single triggers. This function is only possible in the tables.
With the F3 key you can display the next result. Press the F4 key to go back one step.
Default: Not enabled
"Pane SQL Server Objekt-Explorer": Folder Dynamics NAV Meta Object
Expand folders for the Dynamics Database (1), Dynamics NAV Meta Object (2) and Tables (3), click the plus sign (+) or double-click the folder.
Select the desired object and press right mouse button (4) to open the context menu (5).
Three functions are available in the context menu
1. Open Object MetaDate -> This function opens the meta data of the Dynamics NAV/BC object in a new document window. The table Object Metadata has 3 fields for each object, Metadata, User Code & User AL Code. These fields store information in Blob datatype. The dialog has four tabs in which the table data is displayed. You have read-only access to the data.
If you have selected a text in the TSQL Analysis Editor and pressed CTRL + F3, the text is copied into the input field and automatically placed in double quotes. You do not need to press the "Search" button. This is done automatically with the key combination.
2. Open Object NAV Runtime C/AL -> Important! Before you press ok, the Dynamics NAV Development Environment Client must be started as an administrator.
3. Where used? -> The name of the NAV object is automatically copied to the search window and starts the search automatically. The result shows where this object is used in the search field.
Default: Not enabled
"Pane NAV Objekt-Explorer": Displays NAV objektes in a tree structure
The number of imported NAV/BC objects becomes visible here. The main function is the update of the changed AL objects since the creation of the project or update of the AL objects.
Please see TreeNode "DynamicsProject" for further information.