SmartList Builder 2018
Tables
All Navigation Lists are composed of at least one table. The main table is the first table selected for the Navigation List. All additional tables are linked to this table, either directly or indirectly through another table. There are three types of tables that can be added to a Navigation List; Microsoft Dynamics GP tables, SQL Server tables and Extender Resources.
Microsoft Dynamics GP tables are defined in a Microsoft Dynamics GP dictionary. This includes third party dictionaries as well as the main Microsoft Dynamics GP application dictionary. When you select a Microsoft Dynamics GP table, the metadata contained in the dictionary can be accessed. Information such as the display names of the table and fields and list items for list fields are automatically defaulted.
A SQL Server table is any table or view that is contained in your Microsoft Dynamics GP SQL Server databases or any SQL Server database that resides on the same SQL Server as your Microsoft Dynamics GP databases. This feature should be used to access tables that are not contained in a Microsoft Dynamics GP table. You can also use SQL Server views to create complex joins and queries that you cannot create with Navigation List Builder. Since there is no metadata for SQL Server tables, display names and list items are not defaulted.
A SQL Script table is a SQL select script that can be run against the current Dynamics GP company databases. Like SQL Server tables, this feature can be used to access tables that are not contained in a Microsoft Dynamics GP table and create complex joins and queries that you cannot create with Navigation List Builder. The SQL Script option can be used to query tables outside of the current Dynamics GP database as well if the database is specifically included with the table call. Since there is no metadata for SQL Script tables, display names and list items are not defaulted.
Extender Resources are Windows, Detail Windows, Forms and Detail Forms that have been defined in Extender. When you select an Extender Resource, information such as the display names of the fields, decimal places for numeric fields and list items for list fields are automatically defaulted.
To add a Microsoft Dynamics GP table as the main table:
| 1. | Select Microsoft Dynamics GP Table from the Add button above the Tables list to open the Add Table window. |
| 2. | Select the Product, Series and Table. |
| 3. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
To add a SQL Server table as the main table:
| 1. | Select SQL Server Table from the Add button above the Tables list to open the Add SQL Table window. |
| 2. | Select the Database and Table. Select the Views option to display views contained in the selected Database. |
| 3. | If the table or view that you have selected is contained in more than one Microsoft Dynamics GP company database, you can mark the Use Company Database checkbox. When this checkbox is marked, Navigation List Builder will use the table from the Microsoft Dynamics GP database that the user is currently logged in to. If this checkbox is unmarked, Navigation List Builder will always use the selected database. |
| 4. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
|
Security must be granted to tables and/or views in the database before this option will be available. See SQL Table Security for more details. |
To add a SQL Script table as the main table:
| 1. | Select SQL Script from the Add button above the Tables list to open the Add SQL Script window. |
| 2. | Enter the SQL Script. |
| 3. | Select Key fields for the table. There will only be one record displayed in the SmartList for each key field. |
| 4. | Click Save. It will take a few seconds while the fields for the table are initialized with default settings. |
|
Security must be granted to the database before this option will be available. See SQL Table Security for more details. |
To add an Extender Resource as the main table:
| 1. | Select Extender Resource from the Add button above the Tables list to open the Add Extender Resource window. |
| 2. | Select the Resource Type. |
| 3. | Select the Extender Resource. |
| 4. | Click Save. It will take a few seconds while the fields for the Extender Resource are initialized with the default settings. |