Use the Extender Views window to define new Views.
|
You can create and edit Views only when logged in as a user that has the SQL server role of sysadmin or the database role of dbowner.
|
To add a new View:
| 1. | Open the Extender window (Microsoft Dynamics GP >> Tools >> Extender >> Extender). |
| i. | Expand the Solution that the view is to be added too. |
| ii. | Select Views from within the solution. |
| i. | Select the Solution that the view is to be added too. |
| ii. | Click the drop down arrow next to the New button. |
| 3. | Enter a View ID and Description for the View. |
| 4. | Enter a SQL Name of the view. This is the name that will be used when the SQL View is created. |
| 5. | Select the Primary Table |
| 6. | Select additional tables. |
| 7. | Select fields to include in the view. |
| 8. | Click on the Save button. |
To select the Primary Table:
| 1. | Click on the Add button. |
| • | If the Type is Microsoft Dynamics GP Table, select the Product, Series and Table. |
| • | If the Type is Extender Window, select the Window ID. |
| • | If the Type is Extender Form, select the Form ID. |
| 3. | Click on the Add button. |
To select an additional table:
| 1. | Click on the Add button. |
| 2. | Select the table already selected to link the additional table to. |
| 3. | Select the Link To Type: |
| • | If the Type is Microsoft Dynamics GP Table, select the Product, Series and Table. |
| • | If the Type is Extender Window, select the Window ID. |
| • | If the Type is Extender Form, Extender Detail Form or extenders Linked Form, select the Form ID. |
| 5. | Click on the Add button. |
To select a link field:
| 1. | Click on the Add  button above the Link Fields list. |
| 2. | Select the Link From Field. |
| 3. | Select the Link To Field. |
| 4. | Click on the Add button. |
|
The linking of two fields always uses a Left Outer join.
|
To remove a link field:
| 1. | Select the link that you want to remove from the Link Fields list. |
| 2. | Click on the Remove  button above the Link Fields list. |