Inserting Variables - Revision history

Jkuehlthau: /* System Generated Variables */

2022-12-28T20:29:58Z

System Generated Variables

← Older revision		Revision as of 20:29, 28 December 2022
Line 15:		Line 15:
	\|-		\|-
	\|[Row Hash Code]		\|[Row Hash Code]
	\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>Row Hash Code is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.<BR>*THIS ONLY WORKS IN VBSCRIPT. DO NOT USE WITH C#, JAVASCRIPT, OR PERL.*		\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>Row Hash Code is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.<BR>'''*THIS ONLY WORKS IN VBSCRIPT. DO NOT USE WITH C#, JAVASCRIPT, OR PERL.*'''
	\|-		\|-
	\|Job Argument		\|Job Argument

Jkuehlthau: /* System Generated Variables */

2022-12-28T20:29:16Z

System Generated Variables

← Older revision		Revision as of 20:29, 28 December 2022
Line 15:		Line 15:
	\|-		\|-
	\|[Row Hash Code]		\|[Row Hash Code]
	\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>Row Hash Code is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.		\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>Row Hash Code is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.<BR>*THIS ONLY WORKS IN VBSCRIPT. DO NOT USE WITH C#, JAVASCRIPT, OR PERL.*
	\|-		\|-
	\|Job Argument		\|Job Argument

Jkuehlthau at 18:45, 29 May 2015

2015-05-29T18:45:40Z

← Older revision		Revision as of 18:45, 29 May 2015
Line 1:		Line 1:
			=Overview=
	Variables that have been created during an Exec Before/After Operation can be inserted as the end-result value in any kind of Function Field. Place your cursor inside the text box, and click the “Insert Variable” link.		Variables that have been created during an Exec Before/After Operation can be inserted as the end-result value in any kind of Function Field. Place your cursor inside the text box, and click the “Insert Variable” link.

Line 7:		Line 8:
	[[file:Insertvarwindow.png]]		[[file:Insertvarwindow.png]]

			=System Generated Variables=
	There are 3 system generated variables that can be used throughout Sugar.		There are 3 system generated variables that can be used throughout Sugar.
	{\| class="wikitable"		{\| class="wikitable"
Line 14:		Line 15:
	\|-		\|-
	\|[Row Hash Code]		\|[Row Hash Code]
	\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>~~This~~ is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.		\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>Row Hash Code is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.
	\|-		\|-
	\|Job Argument		\|Job Argument
	\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:JobArgument@@.		\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:JobArgument@@.<br>Job Arguments can be passed to Starfish by a 3rd party application when starting a job manually via web services.
	\|-		\|-
	\|Last Run Date		\|Last Run Date
	\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:LastRunDate@@.<br>~~This variable~~ stores the last time a job was run. This is useful for Origin Queries where you want to find all records in the source that were modified after the last time the Job ran.<br>EX: date_modified >= '@@VAR:LastRunDate@@'		\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:LastRunDate@@.<br>Last Run date stores the last time a job was run. This is useful for Origin Queries where you want to find all records in the source that were modified after the last time the Job ran.<br>EX: date_modified >= '@@VAR:LastRunDate@@'
	\|}		\|}

Jkuehlthau at 18:32, 29 May 2015

2015-05-29T18:32:30Z

← Older revision		Revision as of 18:32, 29 May 2015
Line 6:		Line 6:

	[[file:Insertvarwindow.png]]		[[file:Insertvarwindow.png]]


			There are 3 system generated variables that can be used throughout Sugar.
			{\| class="wikitable"
			!Variable
			!Description
			\|-
			\|[Row Hash Code]
			\|Found in the Origin Variable Class, the [Row Hash Code] is added to scripts as @@ORG:#RowHashCode@@.<br>This is a run-time generated MD5 hash of the entire row's data.<br>This is useful when you don't have a last modified date in your origin. You can store it and on the next run of the Job, compare the hash to see if the record changed instead of having to compare each individual field.
			\|-
			\|Job Argument
			\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:JobArgument@@.
			\|-
			\|Last Run Date
			\|Found in the User-Defined Variable Class, the Job Argument is added to scripts as @@VAR:LastRunDate@@.<br>This variable stores the last time a job was run. This is useful for Origin Queries where you want to find all records in the source that were modified after the last time the Job ran.<br>EX: date_modified >= '@@VAR:LastRunDate@@'
			\|}

Admin: Created page with "Variables that have been created during an Exec Before/After Operation can be inserted as the end-result value in any kind of Function Field. Place your cursor inside the text..."

2014-11-05T20:39:31Z

Created page with "Variables that have been created during an Exec Before/After Operation can be inserted as the end-result value in any kind of Function Field. Place your cursor inside the text..."

New page

Variables that have been created during an Exec Before/After Operation can be inserted as the end-result value in any kind of Function Field. Place your cursor inside the text box, and click the “Insert Variable” link.

[[file:Insertvarlink.png]]

From this list, you can choose a User-Defined variable, any Origin field, any Destination field (that comes before it in the sort order, and that has been assigned a value), or a Special Character. At run-time, the Starfish Engine will “replace” the variable code with the actual value for the current Origin row.

[[file:Insertvarwindow.png]]