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

Overview

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

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

Insert excerpt

	_property_toolbar
	_property_toolbar
nopanel	true

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Insert excerpt

	_parent
	_parent
nopanel	true

Basic Settings

Field Description

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 Figures

This 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
borderWidth	4
titleBGColor	#01cff1
title	Example

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
nopanel	true

to keep both

stream

table data and any result of using it in a calculation.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

if you need to use the attribute in a

stream

calculation, but you do not need to keep the result.

Note
Local attributes should not be used to back fields on forms or cards.

Indexed

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to prevent this attribute being indexed in the PhixFlow database.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to index this attribute in the PhixFlow database.

To improve performance, index an attribute when the

stream

table has a large data set and an output pipe from the

stream

table uses this attribute to:

filter the

stream

data
sort or group the

stream data

data.

Note: Attributes with the type, Bigstring, cannot be indexed as this is not supported by the underlying database.

Primary Key

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

indicates

indicates this attribute is a primary key.

This means it contains

Primary keys contain a unique identifier for every record in the table.

Note: Attributes with the type, Bigstring, cannot be set as the primary key as this is not supported by the underlying database.

Secondary Key

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

indicates this attribute is a secondary key. Secondary keys are optional keys that index records and do not have to be unique.

Foreign Key

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

indicates this attribute is a foreign key. This means

and

the ERD links this attribute to a primary key attribute in an other table; see

Understanding ERDs

Entity Relationship Diagrams.

Info
Table attributes that are flagged as a Foreign Key are automatically considered to be Indexed.

Display Name

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

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

table. 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.

Expression

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

Advanced

Field	Description

Filter conditions are
case-independent by default

Available when Basic Settings → Type is String or Bigstring.

Insert excerpt_check_box_untick_check_box_unticknopaneltrue to use filters that are case-sensitive. Insert excerpt_check_box_tick_check_box_ticknopaneltrue 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. NoteThis 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
nopanel	true

for in-memory

stream

table, to specify that this field is not a key value.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

for in-memory

stream

table, to specify that this field will be used as a key value.

Read Only

The attribute cannot be updated by a Save action in an Actionflow.

Translate Values
Anchor
translate
translate

Available when Basic Settings → Type is String or Bigstring.

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to ignore this attribute when translating text in PhixFlow (the default).

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

to include this attribute when translating text that appears in PhixFlow. To be translated, the attribute text must be included in a translation

stream

table; see Translating an Application Interface and Translation Table.

Filter conditions are case-sensitive by default

This field is only available for PhixFlow instances running on Oracle or MySQL databases.

Available when Basic Settings → Type is String or Bigstring.

Insert excerpt

	_check_box_untick
	_check_box_untick
nopanel	true

to use filters that are case-sensitive.

Insert excerpt

	_check_box_tick
	_check_box_tick
nopanel	true

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.

Excerpt

name	caseSensitiveDatabase

Note
For PhixFlow instances running on a SQL Server database, filters are always case-insensitive.

Cache Key

Enter an expression to be evaluated for each

stream-item (

record

)

in the

stream

table . 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

record 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.

Insert excerpt

	_description
	_description
nopanel	true

Insert excerpt

	_access
	_access
nopanel	true

Insert excerpt

	_audit
	_audit

nopaneltrue

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page

Panel

borderColor	#00374F
titleColor	white
titleBGColor	#00374F
borderStyle	solid
title	Sections on this page

Table of Contents

maxLevel	3
indent	12px
style	none

Learn More

Insert excerpt_terms_changing_terms_changing


nopanel	true

Version	Old Version 39	New Version Current
Changes made by	Fiona Sargeant	Zoe Baldwin
Saved on	Mar 23, 2022	Dec 16, 2024

Page Comparison

Versions Compared

Key

Overview

Insert excerpt_property_tabs_property_tabsnamebasic-hnopaneltrue

Basic Settings

Advanced

Live SearchspaceKey@selfadditionalnoneplaceholderSearch all help pagestypepage

Insert excerpt
_property_tabs
_property_tabs
name basic-h
nopanel true

Live Search
spaceKey @self
additional none
placeholder Search all help pages
type page