View Properties

The properties for Views are the same as those found in tables, but because views are read-only, most properties on views cannot be changed. Some have fixed values, and some are inherited from the data sources used in the query which defines the view.

The following properties for Views, which can be set, relate to data analysis when you are using Microsoft SQL Reporting Services.

  • AnalysisVisibility

  • AnalysisSelection

  • TypicalRowCount

  • IsLookup

  • SingularLabel

For more information about these properties, see Table Properties.

The properties that can be set for a View are listed below. For a description of the Best Practices for setting the properties, see Best Practice for View properties. For a description of the read-only properties, see Table Properties.

Property

Description

ConfigurationKey

Sets the configuration key for the view.

DeveloperDocumentation

Describes the purpose of a view and explains how it is used in the application. A description is typically no more than five sentences long and is written as a single paragraph.

EntityRelationshipType

Classifies a view according to common entity relationship (ER) data model notation. A view is classified as an entity or a relationship. An entity represents an object. A relationship represents an association between two objects.

FormRef

Specifies the default form for the view. The default form is the one that should be displayed when the user activates Jump to Main Table by using the shortcut menu for a field on a form.

The form is referenced through a menu item of type Display.

If you leave this field blank, MorphX tries to activate a form that has the same name as the table you are referring to.

Label

Specifies a user-friendly name for the view.

Name

Specifies the name of the view. The name is used when referring to it from the X++ language.

SecurityKey

Sets the security key for the view.

TableGroup

Determines which group the view belongs to.

Table groups categorize tables and views, according to the type of data they hold. Views can belong to the same table groups as a table.

TitleField1, TitleField2

Determine the information shown in the window caption for the view. The caption is constructed from:

  • the TitleField1 label followed by colon (:), and a space

  • the value of the current record in the column used for TitleField1 followed by a comma (,)

  • the value of the current record in the column used for TitleField2.

Community Additions

ADD
Show: