Framework:FKT GetRecord: Difference between revisions
No edit summary |
No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==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). | ||
FKT_GetRecord also returns COPSYS_ID’s. <!--Note: don't forget Special „ASLONG“ in Aggmasks. Dimension qualifier is Dimensionname_x.--> | |||
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> | |||
<span {{CoPFormel}}>Transform=fkt_GetRecord(TBL_PRE_BUD_MYP_PAR.FiscalYearPeriod_1, Company !me+under @Session_Unternehmen_ID@, StartYear != true)</span> | |||
{| {{Bausteindesign1}} | |||
|- | |||
| <span style="color: darkblue;">'''Hinweis'''</span> For bool queries you have to use True/False instead of 1/0. | |||
|} | |||
{| {{Bausteindesign1}} | |||
|- | |||
| <span style="color: darkblue;">'''Hinweis'''</span> For a measurereference you needn't refer to the table. | |||
|} | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category: | [[Category:Functions|GetRecord]] | ||
[[Category:Functions_-_server-side|GetRecord]] | |||
[[de:Framework:FKT GetRecord]] | [[de:Framework:FKT GetRecord]] | ||
Latest revision as of 08:52, 5 November 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])
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. |
