UIElement Dialogs
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 dialog forms.
Home Tab
An Application button, which presents a menu of commands that involve doing something to.
| Pos. | Description | Version |
|---|---|---|
| 1 | Home: This is the default tab. | 2.0 |
| 2 | Title: Shows the name of the executed query. | 2.0 |
| 3 | Home -> Refresh: When you update data, the V8 dialog must query the underlying data sources, possibly reloading the source data into a dataset. This may take a little longer for some queries. Some queries cannot be updated. You will get a message that you have to close the current window and run the query again. | 2.0 |
| 4 | Home -> Code Analyse: Copies the content of the active cell into the TSQL Documents window. The Documents window must be open before executing the query. You can also use the short key F5. This function is very useful when you want to parse SQL scripts. | 2.0 |
| 5 | Home -> Hide Result: With this function you can show and hide the result grid. hides the grid for the best view of your cell value. | 2.0 |
| 6 |
Home -> Navigation: The Navigate view is displayed when the result grid is open. The view shows the currently active line of the used query. This serves for better readability. Double click on the cell.
|
3.5 |
| 7 |
Home -> Auto Filter: By filtering information in a worksheet, you can find values quickly. You can filter on one or more columns of data. With filtering, you can control not only what you want to see, but what you want to exclude. You can filter based on choices you make from a list, or you can create specific filters to focus on exactly the data that you want to see.
You can search for text and numbers when you filter by using the Search box in the filter interface. When you filter data, entire rows are hidden if values in one or more columns don't meet the filtering criteria. You can filter on numeric or text values, or filter by color for cells that have color formatting applied to their background or text.
Filtering data using an AutoFilter
To activate the auto filter click the button. Close the dialog and execute the query again. After opening, the "Autofilter" is available. Please note that it can be a disadvantage to activate the "Autofilter" if you have a large amount of data. The loading process can take much longer. For this reason the default setting for activating the "Autofilter" is set to "false". You also have the possibility to activate the "Autofilter" in Settings under Setting -> System every time you open a dialog. Check "Use Auto Generate..".
If you have activated the checkbox please set the number of data lines to load. By default 1000 lines are loaded. Remember more lines to load, the longer it takes for the dialog to open. |
2.0 |
| 8 |
Home -> Save to DB: With this function you can save the query result in the V8 database. This function is particularly useful if you want to visualize your data according to your requirements. You can use this data to evaluate the status of your system. By default the button is disabled. The button is enabled if a table has been created in the V8 database for this query, in which the result data can be stored. All query result tables begin V8C in the name. After that the internal name of the query is displayed.
Note: When you start a V8 Search XE program, or after you click the File tab, you can see the V8 Search XE Backstage view. If you need to create a new table, change options or more, Backstage is the place to do it.
To create a table for this query start "Backstage" with the "File" tab.
After successful creation of the table in the database, you will receive a message with table names. The button for creating the table is locked from now on.
Getting back to your document. If you want to exit Backstage, and return to the document you were working on, click the Back arrow that is at the top left of the navigation pane. Back in the result document the button is now accessible. Click the button and the result of the query will be saved in the database.
|
2.0 |
| 9 |
Home -> Save to CSV: One way that most V8 users save results in the grid is to save the result in a CSV file that can be opened in Excel, for example. All csv files contain column headers. The CSV file will be saved in the folder that would be set in settings.
|
2.0 |
| 10 |
Home -> Open Report: Build a Report from a Query DataSet using ReportViewer. The output looks like this:
Export Report as XLSX, XLS ,PDF or Word Document.
|
2.0 |
| 11 | Home -> Show (XE Profiler): Opens the dataset of the V8 XE profiler data collection (deadlock and blocking). Detailed information can be found under "Overview Windows -> XE Profiler -> UIElement XE Profiler". | 2.0 |
| 12 | Auto-Hide ribbon: Auto-Hide ribbon hides the ribbon for the best view of your document. | 2.0 |
| 13 |
Show Plan: SQL Server Query Execution Plans in Document Window It is a tool that presents in images and text, the process by which SQL Server steps through the query, parsing, hashing, and building the results set using the information it has available (statistics, indexes, and the raw data).
| 2.4 |
Tab Formatter
The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE dialog forms.
| Pos. | Description | Version |
|---|---|---|
| 1 | Formatter -> Standard Formatting: The editing and formatting functions of the Frontend Text Editor enable you to maintain your source code in a well-structured and readable form. | 2.0 |
| 2 | Formatter -> Formatter: T-SQL Formatter offers a brilliant and good solution to create a consistent standardized T-SQL code formatting. | 2.0 |
| 3 |
Formatter -> SQL Parser: The TSQL statement is analyzed with this function and represents all tokens contained in it with their types in a Treeview control (Tabpage "SQL Parser"). This function is also available on the TSQL Documents window. This function will be extended in the next version of V8 Search XE, because it is suitable for translating TSQL to Dynamics NAV/BC source code.
|
2.0 |
| 4 | Formatter -> Script to File: Save the content of the Frontend Text Editor as a file. | 2.0 |
| 5 | Formatter -> Script to Clipboard: Store the contents of the Frontend Text Editor in the clipboard. | 2.0 |
| 6 |
Formatter -> Script to SSMS: Opens the content of the Frontend Editor in a new query tab in SQL Server Management Studio (SSMS).
|
3.5 |
| 7 |
Formatter -> Formatter Options: Provides formatting options to cater to different common formatting styles/standards.
|
2.0 |
Note! Many of the functions can be executed by clicking the right mouse button in the open context menu.
Tab Data | Backstage
The following table describes fields on the Ribbon Commands Properties tab in the V8 Search XE dialog forms.
| Pos. | Description | Version | |||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Getting back to your document: If you want to exit Backstage, and return to the document you were working on, click the Back arrow that is at the top left of the navigation pane. | 2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 2 |
Action:
|
2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 3 |
Data Filter:
You have the possibility to view stored data for the current query. If you open a dialog from the dashboard, you will always see the current value of the query. If you activate a data filter and return to the document, you have the possibility to press the Refresh button. Then the results will be displayed in the grid according to the filter settings.
|
2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 3 |
Schedule:
Basics of the V8 job service configuration. A job comprises a specified series of actions that the V8-job-service carries out. By using requests, you can define an administration task so that it is executed once or several times.
|
2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 5 | Save: The CSV file will be saved in the folder that would be set in settings. | 2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 6 | Close: Close the Dialog Form. | 2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 7 | About: Open the About V8 Search XE dialog. Getting back to your document! | 2.0 | |||||||||||||||||||||||||||||||||||||||||||||
| 8 | Settings: Open the Settings V8 Search XE dialog. Getting back to your document! | 2.0 |
