Use the attributes properties tab to specify the characteristics of the data Use the attributes properties tab to specify the characteristics of the data in a table column. You can open attribute properties from:
...
| 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 | |||||||||||
| Field | Description | ||||||||||
| All Users Can View Data | |||||||||||
| Insert excerpt | _check_box_ticked | _check_box_ticked | |||||||||
| nopanel | true | User Groups | |||||||||
| Insert excerpt | _user_group | _user_group | |||||||||
| nopanel | true |
| |||||||||
| Cache Key | Enter an expression to be evaluated for each stream item (data 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
| ||||||
| Cache Key | Enter an expression to be evaluated for each stream item (data 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 a stream attribute, see Common Properties → Access Permissions.
| Anchor | ||||
|---|---|---|---|---|
|
All stream attributes have a data type. When loading data from a source, such as a file or database, PhixFlow applies the data type from the source. If there is no data type specified, PhixFlow applies the default type of string.
You can change the type of a stream attribute before the data has been loaded into the stream.
Once the stream contains data, you may be able to change the data type, depending on the database on which PhixFlow runs. PhixFlow reports an error if you are not permitted to change the data type. In this case you can rollback all stream sets so that the stream no longer contains data; see Rollback.
String
Apply a string type to sequences of characters, such as letters, numerals, symbols and punctuation marks. By default string attribute types have a default length of 50. Specify a different string length in Basic Settings → Length.
Anchor Bigstring Bigstring
Bigstring
| Bigstring | |
| Bigstring |
...
The PhixFlow administrator can configure the length of a bigstring using System Configuration → System Tuning → Maximum Bigstring Size.
Integer
Apply an integer type to whole numbers (not a fractions or decimals) that can be positive, negative, or zero. By default integers have a precision of 10 digits. Specify a different integer length in the Basic Settings → Precision.
If you store a number with decimal places as an integer it will be truncated.
...