Versions Compared

Old Version 37

changes.mady.by.user Fiona Sargeant

Saved on

compared with

New Version 38

changes.mady.by.user Fiona Sargeant

Saved on

Key

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

Insert excerpt
_Banners
_Banners
nameanalysis
nopaneltrue

This page is for data modellers and application designers who need to work with data in tables.

Overview

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

  • the repository. Attributes are listed under their streamtheir table.
  • the Stream  Table properties → Attributes section
  • other attribute lists. 

 

Insert excerpt
_property_toolbar
_property_toolbar
nopaneltrue

Insert excerpt
_

standard_settings_standard_settings

property_tabs
_property_tabs
namebasic-h
nopaneltrue

Insert excerpt
_parent
_parent
nopaneltrue

Basic Settings

FieldDescription
Name

Enter the name of the attribute.

Tip

PhixFlow recognises the attribute name UID as a unique identifier for a record. As records are added, PhixFlow automatically increments the UID value.


Type

Select the type of data this attribute contains; see Understanding Data Types.

  • String
  • Bigstring
  • Integer
  • Float
  • Decimal
  • Date
  • Datetime
  • Graphic
  • TrueFalse

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 FiguresThis field is available when Type is Decimal. Enter the maximum number of total digits for decimal numbers.  By default decimals have 10 significant figures.


Panel
borderColor#01cff1
borderWidth4
titleBGColor#01cff1
titleExample

To specify numbers must have two digits before and after the decimal point, such as 12.34, enter:

Significant Figures  4

Decimal Places  2



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

 

Insert excerpt
_check_box_untick
_check_box_untick
nopaneltrue
 to keep both stream data and any result of using it in a calculation. 

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 if you need to use the attribute in a stream calculation, but you do not need to keep the result.

Indexed

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

Insert excerpt
_check_box_tick
_check_box_tick
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.
Primary Key

Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 indicates this attribute is a primary key. This means it contains a unique identifier for every record in the table. 

Foreign Key
Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 indicates this attribute is a foreign key. This means and ERD links this attribute to a primary key attribute in an other table; see Understanding ERDs.
Display Name
Insert excerpt
_check_box_tick
_check_box_tick
nopaneltrue
 indicates the name of this attribute is used as the label rather than the primary key attribute name.
Order

The order of the attributes in the stream. 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.

ExpressionThe expression used to generate the attribute value. This is written as a PhixFlow Expressionand expression; see Expressions and PhixScripts. It must evaluate to a single value, of the type specified in the Type field.

Advanced

 to prevent this attribute being indexed in the PhixFlow database. 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.
    FieldDescriptionIndexed
    Insert excerpt
    _check_box_untick_check_box_untick
    nopaneltrue
    Insert excerpt
    _check_box_tick_check_box_tick
    nopaneltrue
    Filter conditions are
    case-independent by default

    Available when Basic Settings → Type is String or Bigstring.

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

    Insert excerpt
    _check_box_tick
    _check_box_tick
    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 stream, to specify that this field is not a key value.

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

    Translate Values 
    Anchor
    translate
    translate

    Available when Basic Settings → Type is String or Bigstring.

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

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

    Cache Key

    Enter an expression to be evaluated for each stream-item (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 an attribute, see Common Properties → Access Permissions.

    Insert excerpt
    _description
    _description
    nopaneltrue

    Insert excerpt
    _access
    _access
    nopaneltrue

    Insert excerpt
    _audit
    _audit
    nopaneltrue

    Live Search
    spaceKey@self
    additionalnone
    placeholderSearch all help pages
    typepage

    Panel
    borderColor#00374F
    titleColorwhite
    titleBGColor#00374F
    borderStylesolid
    titleSections on this page

    Table of Contents
    maxLevel3
    indent12px
    stylenone

    Learn More


    Insert excerpt
    _terms_changing
    _terms_changing
    nopaneltrue