Versions Compared

Old Version 20

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version 21

changes.mady.by.user Fiona Sargeant

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use the attributes properties tab to specify the characteristics of the  data in a table column.  You can open attribute properties from:

...

FieldDescription
Indexed

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to prevent this attribute being indexed in the PhixFlow database.

Insert excerpt
_check_box_ticked
_check_box_ticked
nopaneltrue
 to index this attribute in the PhixFlow database.

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 the stream data
  • sort or group the stream data.
Filter conditions are
case-independent by default

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to use filters that are case-sensitive.

Insert excerpt
_check_box_ticked
_check_box_ticked
nopaneltrue
 to set new filter conditions on this attribute to be case-insensitive by default. The filter window → Ignore Case check box inherits this setting; see Filters on Data Views. For case-insensitive filters, there is no difference if the attribute is also indexed. 

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.


Key

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 for in-memory streams, to specify that this field is not a key value.

Insert excerpt
_check_box_ticked
_check_box_ticked
nopaneltrue
 for in-memory streams, to specify that this field will be used as a key value. 

Translate Values 
Anchor
translate
translate

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to ignore this attribute when translating text in PhixFlow (the default).

Insert excerpt
_check_box_ticked
_check_box_ticked
nopaneltrue
 to include this attribute when translating text that appears in PhixFlow. To be translated, the attribute text must be included in a translation table; see Translating an Application Interface and Translation Table.

Cache Key

Enter an expression to be evaluated for each stream item (data record) in the stream. The expression can:

  • either use the value of this attribute
  •  or calculate a different value

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
attributes
attributes
Attribute Types

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

...

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.

...

Apply the Basic Settings → Type of TrueFalse to fields that can have the values that represent true or false.

Excerpt

...

The values that represent true are:

  • 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 represent false are:

...

-include
_true_false
_true_false
nopaneltrue

  • an empty/null field.