How do I assign a View to a widget? - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

You can create a new View and assign it to an existing or newly created widget.

Views created through this functionality are not project specific and can be used for Widget definition as of now. They can be used for SMAT Connector configurations in future.

Have a quick look on the video

To create and modify View through Administration Page, follow these steps:

1. On the Home page, click Administration> GLOBAL SETUP.

2. Click View Builder. To add a new View details, click New View.

3. Enter User Defined Name for the view and select the View Category.

   View Name does not support blank spaces and can't exceed more than 20 characters.

   There are two categories in View Category.

   • Dashboard: This View retrieves data from Smart Materials and display it in a widget on the Dashboard.

   • SMAT Connector: This View retrieves data from Smart Materials in other applications.

4. Enter the Short Description and Description as required.

   

   • Short Description and Description supports maximum 80 and 4000 characters respectively.

   • If you want to view the related Short Description and Description of a View, click the NLS () icon.

5. Enter the SQL Query and click Generate View.

   

   • SQL query retrieves data based on your requirement. For example, if View Category is Dashboard, you can enter a query to retrieve released requisitions. The number of these released requisitions displays in your widget on Dashboard. Or, if View category is SMAT Connector, you can retrieve data from multiple tables used for data transfer.

   • While creating a SQL Query, you can know about the required tables and their respective column names and details through Search table.

     • In the right side of the page, click Search table. All the tables appear in a pop-up. Select the table, then their respective columns display within the Table Name column.

     • Related Table column displays the dependent or linked table associated with the selected table.

   • When a View is generated:

     • If View Category is Dashboard , a prefix MV_DBRD_ gets append to the user defined view name. For example MV_DBRD_Test.

     • If View Category is SMAT Connector, a prefix MV_CONN_ gets append to the user defined view name.

6. To view the results of the created View, click Show Results.

   

   • For Dashboard View Category, Show Results displays Column Header and the number of the items that you want to retrieve through the query. For example, if the query is to retrieve the number of approved Purchase Orders, then the result shows only "number" of Approved Purchase order like 3.

   • For SMAT Connector View Category, Show Results displays all the tables required for integration.

   • • Only 20 records display at a time. To view more records, you need to keep scrolling.

     • Search function allows you to search only from the displayed records and not from all the records retrieved from the query.