columnContents

Gets or sets the columns returned in query results. The property accesses a collection of columns. Each item in the collection is set to a column to be displayed. Valid values for this property are represented by the HFMConstants type library constants listed in Journal Column Display Constants.

Read-write.

Syntax

<HFMwQueryDef>.columnContents(lColumnIndex)

Argument

Description

lColumnIndex

The index of the column.

Input argument. Long subtype.

Example

The following snippet sets the columns filter to show journal labels, statuses, types, descriptions, groups, and entities. columnSortOption specifies that the journals will be sorted by labels in ascending order.

'cHFMQueryDef is an HFMwQueryDef object reference.
cHFMQueryDef.columnContents(0) = COLUMN_JOURNALLABEL
cHFMQueryDef.columnSortOption(0) = JOURNALREPORT_SORT_ASCENDING
cHFMQueryDef.columnContents(1) = COLUMN_JOURNALSTATUS
cHFMQueryDef.columnContents(2) = COLUMN_JOURNALTYPE
cHFMQueryDef.columnContents(3) = COLUMN_JOURNALDESCRIPTION
cHFMQueryDef.columnContents(4) = COLUMN_JOURNALGROUP
cHFMQueryDef.columnContents(5) = COLUMN_JOURNALLINEITEMENTITY