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

Attributes

An attribute can be added in Bizview and used to add some property to a Client, User, Object, or Data. These attributes will be treated as new information in addition to the data stored in the standard tables for Client, Object, or Data. You can think of them as new columns in the standard Client, User, Object, or Data tables. For example, you might want to add an attribute 'Residual' to your object values for product. That Object Attribute can then be connected to the object Product, and you get an additional column in which you can maintain the Residual for each product.

Access this feature by selecting System from the menu and then select Attributes:

Below is a list of the available fields:

Field 

Description

Example

Note

Attribute ID*

The unique ID for the attribute.

RESIDUAL

Keep short, no spaces, no strange characters, numbers, or capital letters.

Description

Enter a description of the attribute.

Residual life time


Attribute type*

Select among the available types.

CLIENT, DATA, OBJECT, USER

See Usage section below for detailed descriptions.

Data type

Select among the available types.

TEXT, NUMBER


Additional Information

Usage

  • Client Attribute: Define a Client attribute if you want to manage additional property on the client definition. For example, 'Number of employees' or 'Headquarters'. The Client attributes defined in Bizview is available for usage when creating/editing a Client.

  • User Attribute: Define a User attribute if you want to manage additional property on the user definition. For example, 'Age' or 'Gender'. The User attributes defined in Bizview is available for usage when creating/editing a User.

  • Object Attribute: Define an Object attribute if you want to manage additional property in the object values definition. For example, 'Depreciation' or 'Residual'. The Object attributes defined in Bizview need to be connected to the Objects that are supposed to use the attribute, this is done in the Object Attributes. The Object attributes connected to an Object will display as new columns, highlighted in yellow, in the Object Values grid.

  • Data Attribute: When working with input forms (FORM), all data in templates are saved to the CVAL column in dat.data_cells table. However, many times there is a need to store additional information to these data records. For example, a text column 'Comment' or a column in which the item price 'Price' can be added. Entered values in a data attribute column are saved along each CVAL value (in that row, within the same ATTGROUP) when updated in the database. Once the Data attribute is defined, you can enter them in row 1 in the template, just like CVAL. Values in this column will then be saved. The parameter ATTGROUP needs to specified to tell Bizview which CVAL columns should be saved together with the attribute.

systemadministrationdataattributes

Published:

Attributes

An attribute can be added in Bizview and used to add some property to a Client, User, Object, or Data. These attributes will be treated as new information in addition to the data stored in the standard tables for Client, Object, or Data. You can think of them as new columns in the standard Client, User, Object, or Data tables. For example, you might want to add an attribute 'Residual' to your object values for product. That Object Attribute can then be connected to the object Product, and you get an additional column in which you can maintain the Residual for each product.

Access this feature by selecting System from the menu and then select Attributes:

Below is a list of the available fields:

Field 

Description

Example

Note

Attribute ID*

The unique ID for the attribute.

RESIDUAL

Keep short, no spaces, no strange characters, numbers, or capital letters.

Description

Enter a description of the attribute.

Residual life time


Attribute type*

Select among the available types.

CLIENT, DATA, OBJECT, USER

See Usage section below for detailed descriptions.

Data type

Select among the available types.

TEXT, NUMBER


Additional Information

Usage

  • Client Attribute: Define a Client attribute if you want to manage additional property on the client definition. For example, 'Number of employees' or 'Headquarters'. The Client attributes defined in Bizview is available for usage when creating/editing a Client.

  • User Attribute: Define a User attribute if you want to manage additional property on the user definition. For example, 'Age' or 'Gender'. The User attributes defined in Bizview is available for usage when creating/editing a User.

  • Object Attribute: Define an Object attribute if you want to manage additional property in the object values definition. For example, 'Depreciation' or 'Residual'. The Object attributes defined in Bizview need to be connected to the Objects that are supposed to use the attribute, this is done in the Object Attributes. The Object attributes connected to an Object will display as new columns, highlighted in yellow, in the Object Values grid.

  • Data Attribute: When working with input forms (FORM), all data in templates are saved to the CVAL column in dat.data_cells table. However, many times there is a need to store additional information to these data records. For example, a text column 'Comment' or a column in which the item price 'Price' can be added. Entered values in a data attribute column are saved along each CVAL value (in that row, within the same ATTGROUP) when updated in the database. Once the Data attribute is defined, you can enter them in row 1 in the template, just like CVAL. Values in this column will then be saved. The parameter ATTGROUP needs to specified to tell Bizview which CVAL columns should be saved together with the attribute.

systemadministrationdataattributes

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