Returns the labels and IDs 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. To display the journals or template that meet the criteria, pass the IDs returned by this method to GetJournalsDisplayDataFromIDs or GetTemplatesDisplayDataFromIDs.
<HFMwManageJournals>.ExecuteQueryLabelsAndIDs lType, bstrScenario, bstrYear, bstrPeriod, bstrValue, varalColumns, varalSortOptions, varavFilters, pvaralIDs, pvarasLabels| Argument | Description |
|---|---|
| lType | A flag that determines whether to return labels of journals or templates. Pass 0 for journals, 1 for templates. 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. |
| pvaralIDs | Array Long subtype of journal IDs returned. Input/output argument. |
| pvarasLabels | Array of String Subtype of journals labels returned. Input/output argument. |