Versions Compared
| Version | Old Version 31 | New Version Current |
|---|---|---|
| Changes made by | ||
| Saved on |
Key
- This line was added.
- This line was removed.
- Formatting was changed.
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Overview
Use the attributes properties
...
to specify the characteristics of
...
the data in a
...
column. You can open attribute properties from:
- the repository. Attributes are listed under
...
- their table.
- the
...
- Table properties → Attributes
...
- section
- other attribute lists.
| Insert excerpt | ||
|---|---|---|
|
...
|
| Insert excerpt | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| 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 |
| |||||||||||||||||
...
Advanced
...
calculation, but you do not need to keep the result. |
...
The order of the attributes in the table. Table attribute expressions are evaluated in this order.
This is important when you need to use the results of a calculation in another attribute:
- either in its expression
- or in a $ variable.
In the attribute list, the attribute that calculates the result must come before the attribute that requires the result.
...
| ||||||||||||||||||
| Indexed |
To improve performance, index an attribute when the table has a large data set and an output pipe from the table uses this attribute to:
| |||||||||||||||||
...
|
...
|
...
Note: Attributes with the type, Bigstring, cannot be indexed as this is not supported by the underlying database. | ||||||
| Primary Key |
| |||||
...
| |||||
...
| |||||
...
Note: Attributes with the type, Bigstring, cannot be set as the primary key as this is not supported by the underlying database. | ||||||||||
| Secondary Key |
| |||||||||
...
| Note |
|---|
| This option affects the behaviour of filters for PhixFlow instances running on Oracle or MariaDB (MySQL) databases. For PhixFlow instances running on a SQL Server database, filters are always case-independent. |
indicates this attribute is a secondary key. Secondary keys are optional keys that index records and do not have to be unique. | ||||||||||||
| Foreign Key |
| |||||||||||
| Display Name |
| |||||||||||
| Order | The order of the attributes in the table. 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 and expression; see Expressions and PhixScripts. It must evaluate to a single value, of the type specified in the Type field. | |||||||||||
Advanced
| Field | Description | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Key |
|
...
table, to specify that this field is not a key value.
|
...
table, to specify that this field will be used as a key value. | ||||||||||||||||||||||||
| Read Only | The attribute cannot be updated by a Save action in an Actionflow. | |||||||||||||||||||||||
Translate Values
| Available when Basic Settings → Type is String or Bigstring.
| |||||||||||||||||||||||
| Filter conditions are case-sensitive by default | This field is only available for PhixFlow instances running on Oracle or MySQL databases. Available when Basic Settings → Type is String or Bigstring.
| |||||||||||||||||||||||
| Cache Key | Enter an expression to be evaluated for each |
...
record |
...
in the table . The expression can:
Once calculated, the cache key value persists throughout subsequent |
...
calculation, rather than being created from scratch for each |
...
record 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
...
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|