Framework:FKT GetRecord - Revision history

Admin at 07:52, 5 November 2013

2013-11-05T07:52:45Z

← Older revision		Revision as of 08:52, 5 November 2013
Line 13:		Line 13:

	<span {{CoPFormel}}>FKT_GetRecord(Employees.PSPElements_1, Employees !me [Plantable.Employees_1.COPSYS_ID]) </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.
			\|}

2013-10-22T12:34:10Z

← Older revision		Revision as of 13:34, 22 October 2013
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]].

	~~Sample~~: <span {{CoPFormel}}>FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))</span>		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>

2012-05-24T07:11:38Z

← Older revision		Revision as of 08:11, 24 May 2012
Line 5:		Line 5:
	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.		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]].		This function belongs to [[:Category:Functions_-_server-side\|server-side functions]].

2012-05-24T06:36:43Z

← Older revision		Revision as of 07:36, 24 May 2012
Line 6:		Line 6:

	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.

			This function belongs to [[:Category:Functions_-_server-side\|server-side functions]].

	Sample: <span {{CoPFormel}}>FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))</span>		Sample: <span {{CoPFormel}}>FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))</span>

2012-05-23T13:48:02Z

← Older revision		Revision as of 14:48, 23 May 2012
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]]

2012-03-06T14:18:39Z

← Older revision		Revision as of 15:18, 6 March 2012
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>

2010-11-19T10:56:26Z

← Older revision		Revision as of 11:56, 19 November 2010
Line 4:		Line 4:

	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.

			Sample: FKT_GetRecord(Umsatzerloese_Plan.dim_sys_zeit_1, …))

2010-11-18T11:29:33Z

← Older revision		Revision as of 12:29, 18 November 2010
Line 8:		Line 8:
	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:~~Framework Formulae~~\|GetRecord]]		[[Category:Functions_-_server-side\|GetRecord]]
	[[de:Framework:FKT GetRecord]]		[[de:Framework:FKT GetRecord]]

2010-07-15T08:32:58Z

← Older revision		Revision as of 09:32, 15 July 2010
Line 1:		Line 1:
	==Function==		==[[Framework:Formulae#Functions\|Function]]==

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

2010-05-06T09:21:14Z

← Older revision		Revision as of 10:21, 6 May 2010
Line 8:		Line 8:
	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:Framework Formulae\|~~FKT~~ GetRecord]]		[[Category:Framework Formulae\|GetRecord]]
	[[de:Framework:FKT GetRecord]]		[[de:Framework:FKT GetRecord]]