Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
Overview
Use the attributes properties tab to specify the characteristics of the data in a grid column. You can open attribute properties from:
- the repository. Attributes are listed under their stream
- the Stream properties → Attributes section
- other attribute lists.
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Basic Settings
| Field | Description | |||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Name | Enter the name of the attribute.
| |||||||||||||||||
| Type | Select the type of data this attribute contains; see Understanding Data Types.
| |||||||||||||||||
Length | This field is available when Type is String. By default strings are 50 characters long. Optionally specify a different string length of between 1 and 4000. For strings longer than 4000 characters, set a Type of Bigstring. | |||||||||||||||||
| Precision | This field is available when Type is Integer. Enter the maximum number of digits allowed in whole numbers. By default, integers are 10 digits long. Optionally specify a different integer precision of between 1 digit and 38 digits. | |||||||||||||||||
| Significant Figures | This field is available when Type is Decimal. Enter the maximum number of total digits for decimal numbers. By default decimals have 10 significant figures. |
| ||||||||||||||||
| Decimal Places | This field is available when Type is Decimal. Enter the maximum number of digits allowed after the decimal point. By default, decimals have 2 decimal places. This must be less than the number of significant figures. | |||||||||||||||||
| Local |
| |||||||||||||||||
| Order | The order of the attributes in the stream. Attribute expressions are evaluated in this order. This is important when you need to use the results of a calculation in another attribute:
In the attribute list, the attribute that calculates the result must come before the attribute that requires the result. | |||||||||||||||||
| Expression | The expression used to generate the attribute value. This is written as a PhixFlow Expression. It must evaluate to a single value, of the type specified in the Type field. | |||||||||||||||||
Advanced
| Field | Description | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Indexed |
To improve performance, index an attribute when the stream has a large data set and an output pipe from the stream uses this attribute to:
| ||||||||||||||||||||||
| Filter conditions are case-independent by default |
| ||||||||||||||||||||||
| Key |
| ||||||||||||||||||||||
Translate Values
|
| ||||||||||||||||||||||
| Cache Key | Enter an expression to be evaluated for each stream-item (record) in the stream. The expression can:
Once calculated, the cache key value persists throughout subsequent stream calculation, rather than being created from scratch for each stream-item as normal. This allows you to keep track of the calculation as it progresses. This means you can use a "persistent" attribute value in other expressions. |
Access Permissions
For details about how to control access to an attribute, see Common Properties → Access Permissions.
| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
Learn More
Insert excerpt _terms_changing _terms_changing nopanel true