Framework:FKT GetRecord: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 9: | Line 9: | ||
This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | ||
Samples: <span {{CoPFormel}}>FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))</span> | |||
<span {{CoPFormel}}>FKT_GetRecord(Employees.PSPElements_1, Employees !me [Plantable.Employees_1.COPSYS_ID]) </span> | |||
Revision as of 13:34, 22 October 2013
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])
