ExecuteQuery

Returns the labels of the journals or templates that match the specified columns, sort options, and filtering criteria.

To display the journals or template that meet the criteria, pass the labels returned by this method to GetJournalsDisplayData or GetTemplatesDisplayData.

Syntax

<HFMwManageJournals>.ExecuteQuery (lType, bstrScenario, bstrYear, bstrPeriod, bstrValue, varalColumns, varalSortOptions, varavFilters)

Argument

Description

lType

A flag that determines whether to return labels of journals or templates. Pass 0 for journals, 1 for templates.

Input argument. Long subtype.

bstrScenario

The label of the journals’ Scenario dimension member.

Note:

This argument is ignored for templates.

Input argument. String subtype.

bstrYear

The label of the journals’ Year dimension member.

Note:

This argument is ignored for templates.

Input argument. String subtype.

bstrPeriod

The label of the journals’ Period dimension member.

Note:

This argument is ignored for templates.

Input argument. String subtype.

bstrValue

The label of the Value dimension member for the journals or templates.

Input argument. String subtype.

varalColumns

The journal or template columns for which to return data. Get these columns from HFMwQueryDef.GetDefAsVariants.

Input argument.

varalSortOptions

The sort options for the journals or templates. Get these sort options from HFMwQueryDef.GetDefAsVariants.

Input argument.

varavFilters

The filters for the journals or templates. Get these filters from HFMwQueryDef.GetDefAsVariants.

Input argument.

Return Value

Returns the labels of the journals or templates that match the specified criteria.

Example

ExecuteQuery is used in the example for GetJournalsDisplayData.