Query Settings (ie. Parameters)


{$SETTING_NAME: DESCRIPTION|OPERATOR(REDUNDANT)|DATA_TYPE|LIST_ID(REDUNDANT)|[DEFAULT_VALUE(OPTIONAL)|]}

SETTING_NAME: the name of the setting to use in the query. Usage: {$SETTING_NAME}

OPERATOR: not used in Ivo

DATA_TYPE:

1 = Text (will be trimmed with quotes)

2 = Date

3 = Number

4 = Memo

5 = Blob

6 = Yes/No

7 = Currency

8 = Decimal

9 = Text (will not be trimmed with quotes)

10 = Array of list values

LIST_ID: not used in Ivo

DEFAULT_VALUE: the default value to use for the setting


Example:

{$StartDate: Start Date|=|2|-1|[@StartOfLastQuarter]|}



Functions


{GetReportStatIdFromCode:CODE}

CODE

This is the code from the tblReportsItems table


{GetReportSettingFromSettingId:SETTING_ID}

SETTING_ID

This is the SettingId from the tblReportSettings table


{DssDexFundingCodeStringByDexProgramType:PROGRAM_TYPE}

PROGRAM_TYPE

CHSP = 1

NDAP = 2

NDIS Appeals = 3

ILC = 4

DRC = 5

Redress Support = 6


{FundingCodeString:FUNDING}

FUNDING

DssDexCollect (funding sources where Collect DSS DEX = Yes)

DssDexExport (funding sources where Include in DSS DEX Export = Yes)

Ndap

NdisAppeals

Drc

Qdap

QldHealth

Nacap

VicDhs

HaccExport



{DictionaryValue:VALUE}

VALUE

"act", "activity", "ent", "entity"



Variables

{LoggedOnUserId}

{OrganisationCode}

{ActivityTypeDictionaryNameValue}

{EntityTypeDictionaryNameValue}

{ActivityTypesToIncludeInClientLists}

{NdapFundingCodeString}

{NacapFundingCodeString}

{ElderAbuseFundingCodeString}