Overview
...
Overview
Use the stream attributes properties tab to specify the characteristics of the the data in a table column.
...
| 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 |
| ||||||||||
| 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. CHECK THIS |
Access Permissions
| Field | Description |
|---|---|
| All Users Can View Data | to do |
| User Groups | to do |
...
If you load data without specifying a type what happens?
Does PhixFlow make a best guess at what the type is and if it's not sure, assumes string??
...
| Description | |
|---|---|
| All Users Can View Data | to do |
| User Groups | to do |
| Anchor | ||||
|---|---|---|---|---|
|
Apply aAll stream attributes have a type. The default is String. What if you want to change a format - e.g set a decimal or date format?string.
Once the stream has data, the attribute type can only be changed if the database allows the change. This this is database dependent and you . You will see an error if your change is not allowed. If the stream has no data then any change in attribute type is possible.Which fields can have "null"?
String
Apply a string type to sequences of characters (i.e., such as letters, numerals, symbols and punctuation marks). By default string attribute types have a fixed default length of 50. The minimum length is 1 and the maximum length is 4000.do we need to tell users about any information-loss if data that is naturally a different type gets loaded as a string?However you can configure a minimum length of 1 and a maximum length of 4000.
Anchor Bigstring Bigstring
Bigstring
| Bigstring | |
| Bigstring |
...
The maximum bigstring size can be configured in 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.
What happens if you attempt to load a float or decimal number into an integer attribute? If you store a number with decimal places as an integer it will be truncated.
Integer has a precision which is the maximum number of digits. The default is 10. The minimum is 1 and maximum is 38can be positive, negative, or zero. The number of digits in an integer indicates its precision.
- The default precision is 10 digits
- The minimum precision is 1 digit
- The maximum precision is 38
If you store a number with decimal places as an integer it will be truncated.
Float
Apply a float type to non-integer numbers with an undefined level of precision.
...
| Note |
|---|
PhixFlow recognises date and date-time datetime formats, but does not recognise time-only formats, for example HH:mm:ss. When a database collector loads TIME data, it therefore sets the string data-type. |
...
- any number other than 0
- for a list: all items in the list are true
- the following case-insensitive strings
- true
- t
- yes
- y.
The values that are saved as false are:
- 0 (zero)
- any string not listed as true above
- an empty/null field.