Ribbon UIElement - V8 Search XE - Product Documentation

Ribbon UIElement

Last updated 02 March 2021.

Ribbon Control

The UI of the Ribbon View is the primary feature of the Ribbon framework and provides the next-generation user experience for presenting commands in Windows applications. The ribbon is a command bar that exposes the major features of an application through a series of tabs at the top of an application window.

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Backstage view

When you click on the File tab (far left), the V8 Search XE Backstage view is displayed. It is used to manage files and set options.

Pos.

Description

Version

1

Back: By pressing the arrow in the upper left corner, you can return to the main window.

3.0

2

System: By pressing the button system open on the right side a new area with different subareas.

Pos.	Description	Version
1	1. Press the "System" button 2. Press the "Recent SQL Connections" button 3. Press the add button to "Add+" a new sql server connection 4. Enter the necessary information in the dialogs and press okay Press the right mouse button to open the context menu. Here you will find menu items. With the first menu item you declare the SQL server connection to V8 Search XE's own database. With the second menu item you declare the sql server connection to the V8 Search XE database. With the third menu item delete the existing sql server connection .	3.0
2	1. Press the "System Check" button 2. Select the tables whose data you want to delete permanently. 3. Press the button "OK".	3.0
3	1. Press the "System Check" button 2. Select the tables whose data you want to delete permanently. 3. Press the button "OK".	3.0
4	1. Press the "System Check" button 2. Select the tables whose data you want to delete permanently. 3. Press the button "OK".	3.0
5	1. Press the "System Check" button 2. Select the tables whose data you want to delete permanently. 3. Press the button "OK".	3.0

3.0

3

About: Opens the About dialog.

1.0

4

Settings: Opens the Settings dialog to configure all settings of the V8 Search XE Client.

2.0

5

Close Closing Application with Close button.

1.0

Tab Home | Group SQL Server Connection

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Pos.	Description	Version
1	Home -> Open: Opens the sql server connection that is stored as analysis connection in the backstage view.	2.0
2	Home -> Close: Close the existing sql server connection and closes all open windows.	2.0

Tab Home | SQL Server Script Analyzer

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Pos.	Description	Version
1	Home -> TSQL: Opens one of the central document windows in V8 Search XE. This document window is the link between TSQL Query scripts and the Dynamics NAV/BC Soure code (CAL / AL).	2.0
2	Home -> XE Profiler: The XE Profiler is a feature of V8 Search XE (V8SEAXE) that displays a live display window with advanced events such as deadlocks, blockings or which Dynamics NAV source is being executed by a specific Windows user (Full SQL Tracing).	2.0

Tab Home | SQL Server Script Analyzer Functions

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Pos.	Description	Version
1	Home -> Analyze: The button triggers two functions. 1. Executes a T-SQL parser for the SQL script in the document window. 2. The parser tries to translate the SQL Server table name with the Dynmics NAV object names (NAV is the table often called record). The translation helps the Search Module to find the location in the AL code that generated the TSQL script.	2.0
2	Home -> AL Code: The XE Profiler is a feature of V8 Search XE (V8SEAXE) that displays a live display window with advanced events such as deadlocks, blockings or which Dynamics NAV source is being executed by a specific Windows user (Full SQL Tracing). The session created by the XE Profiler interferes with SQL Server execution to a lesser extent than a similar SQL trace when using the SQL Profiler. This session can also be customized using the existing XE Session Properties interface. In order to use this feature, these adjustments have to be made. You need a V8 service for each Dynamics NC/BC instance you want to profile.	2.0
3	Home -> Formatter: Provides formatting options for several common formatting styles/standards and optionally outputs "colored" HTML code, not just the formatted SQL statement.	2.0
4	Home -> T-Index: Opens a dialog with all important information about the selected table index. Mark the name of the table in the SQL script and press the button. This function is only available in the TSQL Document window.	2.0
5	Home -> V-Index: Opens a dialog with all important information about the selected view index. Mark the name of the view in the SQL script and press the button. This function is only available in the TSQL Document window.	2.0
6	Home -> Statistics: Opens a dialog with all important information about the selected table statistics. Mark the name of the table in the SQL script and press the button. This function is only available in the TSQL Document window.	2.0
7	Home -> Show Plan: View an actual SQL execution plan.	2.0

Tab Home | SQL Server C/AL Code Mapping

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Warning! These functions will no longer be supported in future versions.

Pos.	Description	Version
1	Home -> Update: Opens one of the central document windows in V8 Search XE. This document window is the link between TSQL Query scripts and the Dynamics NAV/BC Soure code (CAL / AL).	2.0
2	Home -> Mapping: The XE Profiler is a feature of V8 Search XE (V8SEAXE) that displays a live display window with advanced events such as deadlocks, blockings or which Dynamics NAV source is being executed by a specific Windows user (Full SQL Tracing).	2.0

Tab Action | Extended Events | Dynamics NV/BC Project | Dashboard

The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE tool.

Pos.

Description

Version

1

Action -> Dashboard-Mix -> This function opens a graph showing the number of locks, deadlocks and long duration over the selected period.

Select period

Chart for long durations, deadlock and blockings.

2.0

2

Action -> PBI Desktop -> Starts the Power BI Desktop with the V8 template.

Instructions

2.0

3

Action -> Code Project: One of the main components for the performance analysis, is V8 source code search.

"V8 Source Code Search is an intuitive C/AL code viewer with "where used"and "find usages", powerful search and much more. With the Dynamics objects in the V8 database, the link between the Dynamics NAV/BC source code and the TSQL queries is established. This feature is one of the most powerful features of V8 Search XE.

Pos.

Description

Version

1

Import / update Dynamics AL or C/AL objects into the V8 database. Opens a tab window with the different actions for Dynamics source code objects.

3.2

2

Import AL Objects: You can import Dynamics application objects into the V8 database from your dynamics system.

Pos.	Description	Version
1	Import AL Objects: Click on the button to open the new document window for importing AL objects.	3.2
2	Import AL Objects: Enter the name of your licensed dynamics database.	3.2
3	Import AL Objects: Select the Dynamics version you use.	3.2
4	Import AL Objects: Press the Start button. After pressing the Start button a new area will open showing you the status of the import. After successful import, restart the application.	3.2

3.2

3

Import C/AL Objects: You can import Dynamics application C/Side objects into the V8 database from your dynamics system.

Pos.	Description	Version
1	Import C/AL Objects: Click on the button to open the new document window for importing C/AL objects.	3.2
2	Import C/AL Objects: Enter the name of your licensed dynamics database.	3.2
3	Import C/AL Objects: Select the Dynamics version you use.	3.2
4	Import C/AL Objects: Important! Only objects according to the Dynamics NAV license are imported (Application Builder or Solution Developer). Please make sure that you have loaded the correct linence in the client when opening the Dynamics NAV development environment. Start the application as administartor.	3.2
5	Import C/AL Objects: Press the Start button. After pressing the Start button a new area will open showing you the status of the import. After successful import, restart the application.	3.2

3.2

4

Update AL Objects: You can update Dynamics application objects into the V8 database from your dynamics system.

Pos.	Description	Version
1	Update AL Objects: Click on the button to open the new document window for update AL objects.	3.2
2	Update AL Objects: The document window will show you all dynamics objects that are newer than those already imported into the v8 database.	3.2
3	Update AL Objects: Select the objects you want to update.	3.2
4	Update AL Objects: Press the Start button. After pressing the Start button a new area will open showing you the status of the update. After successful import, restart the application.	3.2

3.2

5

Update C/AL Objects: You can update Dynamics application objects into the V8 database from your dynamics system.

Pos.	Description	Version
1	Update C/AL Objects: Click on the button to open the new document window for update C/AL objects.	3.2
2	Update C/AL Objects: The document window will show you all dynamics objects that are newer than those already imported into the v8 database.	3.2
3	Update C/AL Objects: Select the objects you want to update.	3.2
4	Update C/AL Objects: Important! Only objects according to the Dynamics NAV license are imported (Application Builder or Solution Developer). Please make sure that you have loaded the correct linence in the client when opening the Dynamics NAV development environment. Start the application as administartor.	3.2
5	Update C/AL Objects: Press the Start button. After pressing the Start button a new area will open showing you the status of the update. After successful import, restart the application.	3.2

3.2

6

Remove ALL Objects: You can remove all Dynamics application objects from the V8 database.

Pos.	Description	Version
1	Remove ALL Objects: Click on the button to open the new document window for remove all objects.	3.2
2	Remove ALL Objects: Select the type of imported objects you want to delete from the database. The names with the ending "_AL" are the dynamics AL objects or dynamics nav extensions. Without this extension all C/AL objects are removed.	3.2
3	Remove ALL Objects: Press the Start button. After pressing the Start button a new area will open showing you the status of the import. After successful import, restart the application.	3.2

3.2

3.2

4

Action -> Views -> Here you have the possibility to open closed documents or tool windows.

Instructions

2.0

5

Action -> LD Table -> A function has been added under the menu item Dashboard -> General. The Transaction ID Full SQL Trace function compares the imported "Full SQL Trace" data with the Blocking, Deadlocks and Long Durations data. If there are any matches of the Transaction ID during this period, they will be displayed in a list. The list will show you whether it is a blocking transaction or a blocked transaction. With the Full SQL Trace Events Transaction function, you can view the complete transaction in the open dialog box. In the dialog window there is a new button under XE Profiler with the name Analysis after pressing the button the detected SQL scripts are marked, which was detected for this transaction as blocking, deadlock or long duration.

Instructions

2.0