Framework:FKT GetRecord: Difference between revisions

From CoPlanner 11
Jump to navigationJump to search
No edit summary
No edit summary
Line 13: Line 13:
__NOEDITSECTION__  
__NOEDITSECTION__  


[[Category:Functions|GetRecord]]
[[Category:Functions_-_server-side|GetRecord]]
[[Category:Functions_-_server-side|GetRecord]]
[[de:Framework:FKT GetRecord]]
[[de:Framework:FKT GetRecord]]

Revision as of 14:48, 23 May 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, …))