...
Form: Stream Attribute Details
| Field | Description |
|---|---|
| Name | Name of the Attribute. |
| Type | This can be one of:
|
| Local | Tick this if this field is only required as part of the stream calculation, and it is not necessary to keep the result for further stream calculations, reports or alarms. If this is ticked, the Column Name field becomes optional. |
| Length/Precision | For a String, the maximum length of the String. For an Integer, the maximum number of digits. |
| Order | The order in which the attributes are placed in the stream. |
| 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. |
| Cache Key | If a cache key is set, the value of this attribute persists throughout the 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. The cache key is an expression that is evaluated for each stream item, and of course it can use the existing value of the attribute, in other words, to value it had in the previous stream item processed in the stream calculation. This allows expressions to use the "persistent" attribute value on subsequent stream items. The expression provided in the Cache Key is evaluated for each stream item so that this "persistent" attribute can refer to multiple value keyed on the "Cache Key". |
| Indexed | Tick this option if this field should be indexed in the underlying database. An indexed field should be used to increase performance on very large streams in the following situations:-
|
| Description | Description of the attribute. |
Form Icons
The form provides the standard form icons as well as the following:
Shows the list of attribute functions available in PhixFlow. |