GetJournalsDisplayDataFromIDs

Retrieves the data for the specified journals. Returns data only for the columns specified in the varalColumns argument.

Syntax

<HFMwManageJournals>.GetJournalsDisplayDataFromIDs(varalIDs, lScenario, lYear, lPeriod, varalColumns)
ArgumentDescription
varalIDs

An array containing the IDs of the journals for which to return data.

Tip:

You can get the IDs of all journals that match given criteria with ExecuteQueryLabelsAndIDs.

Input argument.

lScenario

The member ID of the cell’s Scenario dimension member.

Input argument. Long subtype.

lYear

The member ID of the cell’s Year dimension member.

Input argument. Long subtype.

lPeriod

The member ID of the cell’s Period dimension member.

Input argument. Long subtype.

varalColumns

An array of that identifies the columns for which to return data. To set this argument, use either of the following techniques:

  • Pass the columns returned by the HFMwQueryDef method GetDefAsVariants.

  • Construct the array by setting the array items to the desired columns. Columns are represented by the HFMConstants type library constants listed in Journal Column Display Constants.

Input argument. Array items are of a Long subtype.

Return Value