Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Add Rowid Column-Based Master Keys to a View

You can add a rowid column-based master key to a view if the following conditions are met:

  • The underlying table of the view based on which the master key needs to be created needs to be present in all active queries of the view.

  • The underlying base view must contain a compatible rowid column or a column of the special column type with the master view label set to the view for which the rowid column-based master key is being added.

To add a rowid column-based master key

  1. On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.

  2. Select a view, and then click Modify. For more information, see Select a View.

  3. On the Modify View » <view label> page, under View, click Add, modify keys and joins, and then click Next.The Modify View » <view label>» Add, modify keys and joins page appears.

  4. Click the Add Master Key link. The Add Master Key <view label> dialog box appears.

  5. Click Rowid. The rowid column-specific options are displayed on the page.

  6. In the Key Name box, provide a unique key name for the master key. However, the key name can match with that of an existing master key with different capitalization.

  7. In the Description box, provide a meaningful description.

  8. In the Rowid Table list, select the table on the basis of which you want to add a master key to the view.

  9. IMPORTANT: If you select a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.

  10. In the Table Alias Options section, select a table alias for each query of the view if multiple table aliases are available for the queries in the view. Also, columns of the special column type may also be displayed in the <column label> (Special Column Label) format that can be used to create the master key. Only those table aliases or columns that have not already been used in the definition of rowid column-based joins will be displayed. If you select a special column label, you must use the same column label for each query of the view. Error messages will be displayed if your selection is not allowed.

    NOTE: For a query, the table aliases will be listed in the alphabetical order, and by default, the first table alias will be selected. You can use the Query box to filter the information based on a specific query.

  11. Click OK. The Modify View » <view label> » Add, modify keys and joins page appears showing the new master key under Master Keys.

  12. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  13. Click Save.The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

Published:

Add Rowid Column-Based Master Keys to a View

You can add a rowid column-based master key to a view if the following conditions are met:

  • The underlying table of the view based on which the master key needs to be created needs to be present in all active queries of the view.

  • The underlying base view must contain a compatible rowid column or a column of the special column type with the master view label set to the view for which the rowid column-based master key is being added.

To add a rowid column-based master key

  1. On the NoetixViews Workbench home page, click Modify a View. The Modify View page appears.

  2. Select a view, and then click Modify. For more information, see Select a View.

  3. On the Modify View » <view label> page, under View, click Add, modify keys and joins, and then click Next.The Modify View » <view label>» Add, modify keys and joins page appears.

  4. Click the Add Master Key link. The Add Master Key <view label> dialog box appears.

  5. Click Rowid. The rowid column-specific options are displayed on the page.

  6. In the Key Name box, provide a unique key name for the master key. However, the key name can match with that of an existing master key with different capitalization.

  7. In the Description box, provide a meaningful description.

  8. In the Rowid Table list, select the table on the basis of which you want to add a master key to the view.

  9. IMPORTANT: If you select a table with a profile option, the subsequent generation of the view will fail if the profile condition is not met.

  10. In the Table Alias Options section, select a table alias for each query of the view if multiple table aliases are available for the queries in the view. Also, columns of the special column type may also be displayed in the <column label> (Special Column Label) format that can be used to create the master key. Only those table aliases or columns that have not already been used in the definition of rowid column-based joins will be displayed. If you select a special column label, you must use the same column label for each query of the view. Error messages will be displayed if your selection is not allowed.

    NOTE: For a query, the table aliases will be listed in the alphabetical order, and by default, the first table alias will be selected. You can use the Query box to filter the information based on a specific query.

  11. Click OK. The Modify View » <view label> » Add, modify keys and joins page appears showing the new master key under Master Keys.

  12. In the Customization comments box, provide a summary of the customizations that you have performed. The customization comments can contain a maximum of 200 characters.

  13. Click Save.The customizations are saved, and the Modify View» <view label> page appears.

Now, you can choose to perform any other customizations on the same view or go to the home page.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk