Please enable JavaScript to view this site.

Process Designer

Navigation: PHP API > Work with Subtables

Determine subtable values (getSubtableValue)

Scroll Prev Top Next More

This function allows you to read a value of a row in the subtable.

Parameter

Type

Description

$subtable

string

Subtable name

$row

int

Row ID

$fieldName

string

Column name

$rawValue

bool

Flag in order to set if the value should be returned in "raw form" (optional), default value is false

 

This flag only affects process table fields of type:

- Date (TIMESTAMP) (DATE)

- Date (DATETIME) (DATETIME)

- Attachment (FILE)

 

If the parameter $rawValue has been passed with the value true, the time is returned with the type date.

In contrast to the type Attachment the actual file name is returned on the file system. This should be used to perform file operations.

The format of the returned value depends on the type of subtable column.

Type

Format

Example

Text

Text output

Text …

Integer

Integer output

1000

Decimal

Decimal output

1000.00

Attachment

Output of the directory and the file name below the JobRouter upload directory.

030df2c553e040cc89b943081d682114/test.pdf

Long text

Text output

Text …

Date

Output: YYYY-MM-DD

2012-01-20

Example:

$attachment = $this->getSubtableValue('ATTACHMENT', 1, 'MATERIAL', true);