Views System

Views System File Structures

The Views System uses seven data control files:

	pvxview.vue	Defines view contents.
	pvxview.src	Defines data sources and views.
	pvxview.clc	Defines calculated items in a view.
	pvxview.itm	Defines elements within the data sources.
	pvxview.lnk	Defines interrelationships between the data sources.
	pvxview.grp	Defines group names.
	pvxview.gpd	Defines which data sources and views belong to which group.

These files are initially created in the current working directory and must be accessible whenever view components are defined or accessed.

(The pvxview.clc file was added in PxPlus 2021.)

View Definitions - pvxview.vue

The file structure for pvxview.vue is explained below.

Element Name

Description

Length

Print Format

VUE_ID

View identifier

XXX00000

VUE_SEQ

View sequence. An optional record with sequence 0000 may exist for views with a free-form filter assigned. Free-form filters are applied at the view level rather than at the field level.

0000

VUE_PATH

Source linkage. An item from the primary data source is defined by its ITM_ID$ alone. Items from linked or related files are defined by the LNK_ID$(s) followed by the item's ITM_ID$.

240

VUE_COLUMN

Column name

VUE_CONDITION

Filter condition. This is applied at the view level if VUE_SEQ is 0000 and applied at the field level if VUE_SEQ is greater than 0000.

Note:
The format of the VUE_CONDITION contents changed as of PxPlus v8.00 to make it more flexible. It is not possible to use views with conditions defined or updated in v8.00 or later with an earlier version.

500

VUE_TYPE

"I" or blank	Item is a data source element
"C"	Item is a calculated item

(VUE_TYPE was added in PxPlus 2021.)

Record size (including delimiters):		819
Defined record size:		1024 (Variable)
*Key Definitions:*
Primary key:	VUE_ID + VUE_SEQ		[1:1:8]+[2:1:4]

Note:
All fields are delimited strings.

Calculated Fields - pvxview.clc

The file structure for pvxview.clc is explained below.

(The pvxview.clc file was added in PxPlus 2021.)

Element Name

Description

Length

Print Format

CLC_ID

Element ID

XXX00000

CLC_SRC_ID

Parent (view) ID

XXX00000

CLC_NAME

Field or column name

CLC_DESC

Item description

CLC_DATA_TYPE

Data type

S	String data *(Default)*
N	Numeric data

CLC_LENGTH

Item length

CLC_EXPR_IND

Type of expression (Not Used)

CLC_SOURCE

Formula/expression

300

CLC_CLASS

Class of item

CLC_FLD_SEQ

Item sequence

0000

Record size (including delimiters):		460
Defined record size:		640 (Variable)
*Key Definitions:*
Primary key:	CLC_ID		[1:1:8]
Alternate Key 1:	CLC_SRC_ID + CLC_ID		[2:1:8]+[1:1:8]
Alternate Key 2:	CLC_SRC_ID + CLC_NAME		[2:1:8]+[3:1:30:"C"]
Alternate Key 3:	CLC_SRC_ID + CLC_DESC		[2:1:8]+[4:1:64:"C"]
Alternate Key 4:	CLC_SRC_ID + CLC_FLD_SEQ		[2:1:8]+[10:1:4]

Note:
All fields are delimited strings.

Data Sources - pvxview.src

The file structure for pvxview.srcis explained below.

Element Name

Description

Length

Print Format

SRC_ID

Data source ID

XXX00000

SRC_DESC

Data source description

SRC_TYPE

Source type

L	Logical name
P	Path name
O	Object name
T	External database table
V	View

SRC_EXPR_IND

Expression indicator

=	Expression

SRC_PRIMARY_SOURCE

Data source

T	Connection string
L	Logical file name
P	File name
O	Object name
V	Primary source ID

1024

SRC_KEY

(Used by SRC_TYPE V Only)

Sort key

SRC_ORDER

(Used by SRC_TYPE V Only)

Element order

A	Alphabetic
" " null	Natural order *(Default)*

SRC_UPD_STAMP

Last update

SRC_LONG_DESC

Long description

255

SRC_PASSWORD

(Used by SRC_TYPE V Only)

Password (encrypted)

SRC_INIT_LOGIC

Initialization logic

128

SRC_EXEC_LOGIC

Execution logic

128

SRC_CLOSE_LOGIC

Closing logic

128

SRC_LOGIC_OBJECT

Logic object

128

Record size (including delimiters):		2004
Defined record size:		2176 (Variable)
*Key Definitions:*
Primary key:	SRC_ID	[1:1:8]
Alternate Key 1:	SRC_DESC	[2:1:64:"UC"]

Note:
All fields are delimited strings.

Data Elements - pvxview.itm

The file structure for pvxview.itm is explained below.

Element Name

Description

Length

Print Format

ITM_ID

Element ID

XXX00000

ITM_SRC_ID

Parent (data source) ID

XXX00000

ITM_NAME

Field or column name

ITM_DESC

Element description

ITM_DATA_TYPE

Data type

S	String data *(Default)*
N	Numeric data

ITM_LENGTH

(Optional) Item length

ITM_EXPR_IND

Type of expression (Not Used)

ITM_SOURCE

Formula/expression

300

ITM_CLASS

Class of item

ITM_FLD_SEQ

Element sequence

0000

Record size (including delimiters):		460
Defined record size:		640 (Variable)
*Key Definitions:*
Primary key:	ITM_ID		[1:1:8]
Alternate Key 1:	ITM_SRC_ID + ITM_ID		[2:1:8]+[1:1:8]
Alternate Key 2:	ITM_SRC_ID + ITM_NAME		[2:1:8]+[3:1:30:"C"]
Alternate Key 3:	ITM_SRC_ID + ITM_DESC		[2:1:8]+[4:1:64:"C"]
Alternate Key 4:	ITM_SRC_ID + ITM_FLD_SEQ		[2:1:8]+[10:1:4]

Note:
All fields are delimited strings.

Relationships - pvxview.lnk

The file structure for pvxview.lnk is explained below.

Element Name

Description

Length

Print Format

LNK_ID

Link identifier

XXX00000

LNK_PARENT_ID

Parent source ID (Data source this link belongs to)

XXX00000

LNK_SRC_ID

Linked data source ID (Linked data source)

XXX00000

LNK_DESC

Link description

LNK_TYPE

Type of relationship

1	One-to-one
*	One-to-many
(Key expression used as a range)

LNK_NO_DATA_OPTION

File/Data is mandatory

1	Return null data for subordinate fields
2	Display *asterisk in string fields
3	Skip the record

LNK_KNO

Related key name/number

LNK_EXPR_IND

Type of expression (Not Used)

LNK_KEYDEF

Key expression

300

LNK_PREFIX

Record prefix for link file

Record size (including delimiters):		475
Defined record size:		640 (Variable)
*Key Definitions:*
Primary key:	LNK_ID		[1:1:8]
Alternate Key 1:	LNK_PARENT_ID+ LNK_SRC_ID		[2:1:8]+[3:1:8]
Alternate Key 2:	LNK_PARENT_ID + LNK_DESC		[2:1:8:"U"]+[4:1:64:"C"]
Alternate Key 3:	LNK_SRC_ID + LNK_PARENT_ID		[3:1:8]+[2:1:8]

Note:
All fields are delimited strings.

Data Groups - pvxview.grp

The file structure for pvxview.grp is explained below.

Element Name	Description	Length	Print Format
GRP_ID	Group identifier	8	XXX00000
GRP_DESC	Group description	64

Record size (including delimiters):		74
Defined record size:		256 (Variable)
*Key Definitions:*
Primary key:	GRP_ID	[1:1:8]
Alternate Key 1:	GRP_DESC	[2:1:64:"UC"]

Note:
All fields are delimited strings.

Grouped Data Sources - pvxview.gpd

The file structure for pvxview.gpd is explained below.

Element Name	Description	Length	Print Format
GPD_GRP_ID	Group identifier	8	XXX00000
GPD_SRC_ID	Data source identifier	8	XXX00000

Record size (including delimiters):		18
Defined record size:		256 (Variable)
*Key Definitions:*
Primary key:	GPD_GRP_ID + GPD_SRC_ID		[1:1:8]+[2:1:8]
Alternate Key 1:	GPD_SRC_ID + GPD_GRP_ID		[2:1:8]+[1:1:8]

Views System

View Definitions - pvxview.vue

Note: The format of the VUE_CONDITION contents changed as of PxPlus v8.00 to make it more flexible. It is not possible to use views with conditions defined or updated in v8.00 or later with an earlier version.

Note:All fields are delimited strings.

Calculated Fields - pvxview.clc

Note:All fields are delimited strings.

Data Sources - pvxview.src

Note:All fields are delimited strings.

Data Elements - pvxview.itm

Note:All fields are delimited strings.

Relationships - pvxview.lnk

Note:All fields are delimited strings.

Data Groups - pvxview.grp

Note: All fields are delimited strings.

Grouped Data Sources - pvxview.gpd

Note: All fields are delimited strings.

Note:
The format of the VUE_CONDITION contents changed as of PxPlus v8.00 to make it more flexible. It is not possible to use views with conditions defined or updated in v8.00 or later with an earlier version.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.

Note:
All fields are delimited strings.