Framework:FKT GetRecord

Function

FKT_GetRecord(<Return field>,<restriction 1 till n>)

The function FKT_GetRecord is used the same way as the FKT_GetAggregat function, with the following difference: The FKT_GetAggregat supplies the sum of the values to which the corresponding conditions apply. The FKT_GetRecord supplies the same value which is found under the corresponding restrictions (as of version 20060820 no log message will be displayed if no dataset is found).

FKT_GetRecord also returns COPSYS_ID’s.

This function belongs to server-side functions.

Samples: FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))

FKT_GetRecord(Employees.PSPElements_1, Employees !me [Plantable.Employees_1.COPSYS_ID])

Transform=fkt_GetRecord(TBL_PRE_BUD_MYP_PAR.FiscalYearPeriod_1, Company !me+under @Session_Unternehmen_ID@, StartYear != true)

Hinweis  For bool queries you have to use True/False instead of 1/0.

Hinweis  For a measurereference you needn't refer to the table.