Framework:FKT GetRecord: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
==[[Framework:Formulae#Functions|Function]]== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_GetRecord(<Return field>,<restriction 1 till n>) | <span {{CoPFormel}}>FKT_GetRecord(<Return field>,<restriction 1 till n>) </span> | ||
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). | 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). | ||
| Line 7: | Line 7: | ||
FKT_GetRecord also returns COPSYS_ID’s. Note: don't forget Special „ASLONG“ in Aggmasks. Dimension qualifier is Dimensionname_x. | FKT_GetRecord also returns COPSYS_ID’s. Note: don't forget Special „ASLONG“ in Aggmasks. Dimension qualifier is Dimensionname_x. | ||
Sample: FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …)) | Sample: <span {{CoPFormel}}>FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))</span> | ||
Revision as of 15:18, 6 March 2012
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. Note: don't forget Special „ASLONG“ in Aggmasks. Dimension qualifier is Dimensionname_x.
Sample: FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))
