File+Column Details

Element Details: File+Column

Available in: Logi Info

Source code name: FileColumn

Introduced in: v9.1.47

FileColumn copies a column value from a DataLayer into a file, one for each row. The value can be text or binary.

FileColumn is especially useful for getting and displaying images retrieved from database queries.

Set DataColumn to the name of the source text or binary column. As the FileColumn element creates its files, the data gets removed from the DataLayer.

Set the DataType to Binary or Text. Binary values should be Base64-encoded in the DataLayer, which is the standard behaviour

With the FileColumn element, be careful to set the Filename attribute so that each file gets a unique name. Use @Function.GUID~ or an ID value from data row, like @Data.ID~. Get the physical filename and pathname by creating new columns with the SavedFilePathColumnID and SavedFilenameColumnID attributes.

Example:
Filename="@Function.AppPhysicalPath~\rdDownload\@Function.GUID~.gif"

Element Group:Add and Replace Columns

ATTRIBUTES

Click attribute Name to drill down for more information.

Name

Possible Values

Description

DataColumn

UserDefined

(Required) The name of a data field/column returned from the DataLayer.

DataType

Text

Binary

Specifies the type of data present.

Filename

UserDefined

(Required) A physical, file system path and filename.

UserDefined

(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.

IncludeCondition

True

False

An expression that evaluates to a value of True or False. If the expression is blank, or evaluates to true the element is processed. If the expression evaluates to false, the element is skipped. Expressions should be in VBScript or JavaScript syntax. For .NET versions, the scripting language can be set in the _settings.lgx General element. For Java versions, the scripting language is always JavaScript. Typically, you would compare values using an operator, such as "@Session.value~ < 0". Use quotes when working with strings: "@Session.myValue~" == "SomeValue"

SavedFilenameColumnID

UserDefined

The ID of the column that will store the name of the file saved with the FileColumn element.

SavedFilePathColumnID

UserDefined

The ID of the column that will store the file system path of the file saved with the FileColumn element.

PARENT ELEMENTS

Click element to drill down for more information.

CHILD ELEMENTS

Click element to drill down for more information.