Example: Array.toStringArray()

=Array.toStringArray('Apples', 'Oranges', 'Bananas', 'Lemons') Returns an array with 4 fruity elements.

Example: Array.toNumberArray()

=Array.toNumberArray(1, 2, 3, 4) Returns an array with 4 numbers.

Example: Array.toDateTimeZoneArray()

=Array.toDateTimeZoneArray(Time.now(),Time.parse('20240803100236','yyyyMMddhhmmss')) Returns an array with 2 date/times elements.

Example: Array.toTimeArray()

=Array.toTimeArray(Time.now(),Time.parse('20240803100236','yyyyMMddhhmmss')) Returns an array with 3 epoch time elements.

Example: Array.toString()

=Array.toString(['Apples', 'Oranges', 'Bananas', 'Lemons'], ',') Returns "Apples,Oranges,Bananas,Lemons".

Example: Array.toStringAffix()

=Array.toStringAffix(['Apples', 'Oranges', 'Bananas', 'Lemons'], ',', '[', ']',) Returns "[Apples,Oranges,Bananas,Lemons]".

Example: Array.get()

=Array.get(['Apples', 'Oranges', 'Bananas', 'Lemons'], 0) Returns "Apples".

Example: ToBoolean()

=ToBoolean('true') Returns true.

Example: ToNumber()

=ToNumber('123') Returns 123.

Example: ToInteger()

=ToInteger('123') Returns 123.

Example: ToString()

=ToString(true) Returns true.

Example: ToYN()

=ToYN('true') Returns Y.

Example: Math.abs()

=Math.abs(-12.12) Returns 12.12.

Example: Math.floor()

=Math.floor(-12.12) Returns -13.

Example: Math.ceil()

=Math.ceil(-12.12) Returns -12.

Example: Math.round()

=Math.round(12.49) Returns 12.

Example: Math.getInstance()

Example: Range.inRange()

The following example uses the Time.format function. This boolean function checks if the current day of the month is between 1 and 7. =Range.inRange(Time.format(Time.now('Europe/Berlin'), 'd'), '1-7').

Example: Range.inSet()

The following example uses the Time.format function. This boolean function checks if the current month is the first month of a quarter. =Range.inSet(Time.format(Time.now('Europe/Berlin'), 'M'), ' X__X__X__X__'). Note the leading space in trueRange to convert from the 1-based month to the 0-based trueRange.

Example: currentString.concat()

='Hello'.concat(' World', '!') Returns Hello World!.

Example: currentString.toString()

='123'.toString() Returns 123, it can be used as a string.

Example: currentString.charAt()

='Hello World!'.charAt(4) Returns o.

Example: currentString.indexOf()

='Hello World!'.indexOf('o') Returns 4.

='Hello World!'.indexOf('o', 5) Returns 7.

Example: currentString.lastIndexOf()

='Hello World!'.lastIndexOf('o') Returns 7.

='Hello World!'.lastIndexOf('o', 5) Returns 4.

Example: replace()

='abc def ghi'.replace('def', '123') Returns [abc 123 ghi].

Example: currentString.split()

='1 2 3 4 5 6 7 8 9 10'.split(' ', 5) Returns [1, 2, 3, 4, 5].

Example: currentString.substring()

='Hello World!'.substring(0) Returns Hello World!.

='Hello World!'.substring(6) Returns World!.

='Hello World!'.substring(1, 3) Returns el.

Example: currentString.toLowerCase()

='HeLLo WorLd!'.toLowerCase() Returns hello world!.

Example: currentString.toUpperCase()

='HeLLo WorLd!'.toUpperCase() Returns HELLO WORLD!.

Example: currentString.length()

='HeLLo WorLd!'.length() Returns 12.

Example: getSystemId()

=getSystemId() Returns redwood-university_test in this system.

Example: currentString.contains()

='Hello'.contains('l') Returns true.

='Hello'.contains('lol') Returns false.

Example: currentString.startsWith()

='Hello'.startsWith('He') Returns true.

='Hello'.startsWith('llo') Returns false.

Example: currentString.trim()

='Hello '.trim() Returns 'Hello'.

=' Hello'.trim() Returns 'Hello'.

=' Hello '.trim() Returns 'Hello'.

='Hel lo'.trim() Returns 'Hel lo'.

Example: String.concat()

=String.concat(Time.now('Europe/Paris'), ', Rue Toulouse-Lautrec') Returns 2024/08/01 13:08:36,946 Europe/Paris, Rue Toulouse-Lautrec.

Example: String.toString()

=String.toString(123) Returns 123 as a String.

Example: String.charAt()

=String.charAt('Hello John', 4) Returns o.

Example: String.indexOf()

=String.indexOf('Hello', 'l', '3') Returns 3.

Example: String.lastIndexOf()

=String.lastIndexOf('Hello', 'l', '3') Returns 3.

Example: String.replace()

=String.replace('abc def ghi', 'def', '123') Returns [abc 123 ghi].

Example: String.split()

=String.split('Some people like', ' ', '3') Returns [Some, people, like].

Example: String.substring()

=String.substring('like it on ice', 8, 14) Returns on ice.

Example: String.toLowerCase()

=String.toLowerCase('but I like it dry.') Returns but i like it dry..

Example: String.toUpperCase()

=String.toUpperCase('I like it dry.') Returns I LIKE IT DRY..

Example: String.length()

=String.length('but I like it dry.') Returns 18.

Example: String.getSystemId()

=String.getSystemId() Returns redwood-university_test on this system.

Example: String.contains()

=String.contains('Hello', 'l') Returns true.

=String.contains('Hello', 'lol') Returns false.

Example: String.startsWith()

=String.startsWith('Hello', 'He') Returns true.

=String.startsWith('Hello', 'llo') Returns false.

Example: String.trim()

=String.trim('Hello ') Returns 'Hello'.

=String.trim(' Hello') Returns 'Hello'.

=String.trim(' Hello ') Returns 'Hello'.

=String.trim('Hel lo') Returns 'Hel lo'.

Example: Time.now()

=Time.now() Returns the current time with time zone.

Example: Time.expression()

=Time.expression(Time.now('Europe/Amsterdam'), 'add 1 day') Returns tomorrow, Europe/Amsterdam time.

Example: Time.expressionNow()

=Time.expressionNow('truncate day') Returns 2024/08/01 00:00:00,000 Europe/Amsterdam.

Example: Time.isTimeWindowOpenNow()

=Time.isTimeWindowOpenNow('GLOBAL.System_Week_Monday') - boolean functions which returns true if today is Monday.

Example: Time.isTimeWindowOpen()

=Time.isTimeWindowOpen(Time.expressionNow('subtract 1 day'), 'GLOBAL.System_Week_Monday') - boolean function which returns true if today is Tuesday .

=Time.isTimeWindowOpen(Time.expressionNow('truncate day add 3 hours add 25 minutes'), '$.SomeTimeWindow') - this example illustrates the use of the $ identifier for the partition.

Example: Range.inRangeWarning()

=Range.inRangeWarning(52, '10-50', '51-100', 50, 'Warning: range exceeded') Returns true and creates an operator message.

Example: Repository.getSystemId()

=Repository.getSystemId() Returns redwood-university_test on this system.

Example: Repository.getParentJobId()

=Repository.getParentJobId('27') Returns 21 on this system.

Example: Repository.queryHTMLTable()

=Repository.queryHTMLTable('select Job.Description from Job where Job.JobId = 21') Returns My Job on this system.

Example: Repository.queryCSV()

=Repository.queryCSV('select Job.Description from Job where Job.JobId = 21') Returns My Job on this system.

Example: Time.isDayOfWeekInSetNow()

=Time.isDayOfWeekInSetNow('_X_X_X_') Returns true if the current day is Monday, Wednesday, or Friday.

Example: Time.isDayOfWeekInSet()

=Time.isDayOfWeekInSet(Time.now('Europe/Paris'), '_X_X_X_') Returns true if the day falls on a Monday, Wednesday, or Friday.

Example: Time.isDayInRangeNow()

=Time.isDayInRangeNow('4-7') Returns true if the current day of the month is between 4 and 7.

Example: Time.isDayInRange()

=Time.isDayInRange(Time.now('Europe/Bratislava'), '4-7') Returns true if the day of the month in the time expression is between 4 and 7.

Example: Time.isLastDayInMonthNow()

=Time.isLastDayInMonthNow() Returns true if the current day is the last day of the month.

Example: Time.isLastDayInMonth()

=Time.isLastDayInMonth(Time.expressionNow('add 2 days')) - return true if the current day is two days before the end of the month.

Example: Time.isMonthInSetNow()

=Time.isMonthInSetNow('_X_X_X_X_X_X') - return true if the current month has an even number.

Example: Time.isMonthInSet()

=Time.isMonthInSet(Time.expression(Time.now(), 'add 1 month'), '_X_X_X_X_X_X') - return true if the current month has an uneven number.

Example: Time.format()

=Time.format(Time.now(), 'yyyy-MM-dd') Returns the date in the yyyy-MM-dd format, as in 2024-08-14.

Example: Time.formatLocale()

=Time.formatLocale(Time.now(), 'yyyy-MM-dd', 'de_DE') Returns the date in the yyyy-MM-dd format, as in 2024-08-14 using the German/Germany locale.

Example: Time.formatDuration()

=Time.formatDuration(100000) Returns 0:01:40.000.

Example: Time.formatDurationEx()

=Time.formatDurationEx(10000000000, '|1 week, |# weeks, |1 day, |# days, |#|:#|:#|.#|') Returns 16 weeks, 3 days, 17:46:40.000.

=Time.formatDurationEx(10000000000, '|1 semaine, |# semaines, |1 jour, |# jours, |#|:#|:#|.#|') Returns 16 semaines, 3 jours, 17:46:40.000.

=Time.formatDurationEx(10000000000, '|||1 day,|# days, |#|:#|:#|.#|') Returns 115 days, 17:46:40.000.

=Time.formatDurationEx(10000000000, '||||# days, |#|:#|:#|.#|') Returns 2777:46:40.000, which is the duration in hours, minutes, seconds, and milliseconds. The first and third elements were empty, causing the second which was empty and the fourth which was # days, to be discarded.

Example: Time.getUTCMillisecondsNow()

=Time.getUTCMillisecondsNow() Returns the milliseconds since January 1 1970, for example 1709323964 on 2024/03/02 01:42:44 Europe/Amsterdam.

Example: Time.getUTCMilliseconds()

=Time.getUTCMilliseconds(Time.now()) Returns the milliseconds since January 1 1970, for example 1709323964 on 2024/03/02 01:42:44 Europe/Amsterdam.

Example: Time.formatNow()

=Time.formatNow('yyyyMMddhhmmss') Returns 20240302014244.

Example: Time.parse()

=Time.parse('20240302014244', 'yyyyMMddhhmmss') Returns 2024/03/02 01:42:44 Europe/Amsterdam.

Example: Time.nextTimeWindowOpeningNow()

=Time.nextTimeWindowOpeningNow('GLOBAL.System_Week_Thursday') Returns 2024/03/07 00:00:00,000 Europe/Amsterdam.

=Time.nextTimeWindowOpeningNow('$.SomeTimeWindow') Returns 2024/03/02 00:00:00,000 Europe/Amsterdam.

Example: Time.nextTimeWindowOpening()

=Time.nextTimeWindowOpening(Time.parse('20240302014244', 'yyyyMMddhhmmss'), 'GLOBAL.System_Week_Thursday') Returns 2024/03/07 00:00:00,000 Europe/Amsterdam .

Example: Time.nextTimeWindowClosingNow()

=Time.nextTimeWindowClosingNow('GLOBAL.System_Week_Sat') Returns 2024-03-03 00:00:00,000 Europe/Amsterdam.

Example: Time.nextTimeWindowClosing()

=Time.nextTimeWindowClosing(Time.parse('20240302014244', 'yyyyMMddhhmmss'), 'GLOBAL.System_Week_Sat') Returns 2024-03-03 00:00:00,000 Europe/Amsterdam.

Example: Time.addOpenDays()

Example: Time.addOpenDaysFromNow()

=Time.addOpenDaysFromNow('System_Week_WorkDays', 10) Returns the date with 10 added days to the current date according to the time window 'System_Week_WorkDays'.

Example: Constraint.listConstraint()

=Constraint.listConstraint('Country', 'de,nl,gt', value !== '') This will show a drop down list with the values de, gt and nl. However you can fill in any non-empty value, e.g. also mx

=Constraint.listConstraint('Country', 'de,nl,gt') This will show a drop down list with the values de, gt and nl. You can only choose values from this list.

=Constraint.listConstraint('Ciphers or letters', '1,2,3,...|a,b,c,...', null, '\\|') This will show a drop down list with the values 1,2,3,... and a,b,c,.... Note, the commas in the values. Also note, that the bar here is a special character in regular expressions and therefore it needs to be escaped with two slashes. You can only choose values from this list.

Example: Constraint.pairListConstraint()

=Constraint.pairListConstraint('Country, Code', 'de=49,nl=31,gt=502', value !== '').

This will show a drop down list, like

However, you can fill in any non-empty value, e.g. also mx.

=Constraint.pairListConstraint('Country Code, Country', 'de=Deutschland,nl=Nederland,gt=Guatemala') .

This will show a drop down list, like

You can only choose one of the the values de, nl, or gt.

=Constraint.pairListConstraint('Code|Various symbols', 'C:1,2,3,...|L:a,b,c,...|O:=-*+/', null, '\\|', ':') .

This will show a drop down list, like:

Note, the commas and equal sign in the values. Also note, that the bar here is a special character in regular expressions and therefore it needs to be escaped with two slashes. You can only choose values from this list.

Example: Credential.getProtectedPasswordByProtocolRealUser()

=Credential.getProtectedPasswordByProtocolRealUser('GLOBAL', 'login', 'host', 'root') or.

=Credential.getProtectedPasswordByProtocolRealUser('$', 'login', 'host', 'root') where '$' represents the partition of the Process Definition the parameter is in.

Example: Credential.getProtectedPasswordByProtocolVirtualUser()

=Credential.getProtectedPasswordByProtocolVirtualUser('GLOBAL', 'login', 'host', 'appowner').

Example: Credential.getProtectedPassword()

=Credential.getProtectedPassword('host', 'root').

Example: Event.isEventRaised()

=Event.isEventRaised('MyPartition.MyEvent') Returns true on this system as the event is currently raised.

Example: JDBC.clearCache()

Example: JDBC.constraint()

=JDBC.constraint('user=scott endpoint=xe', 'select name "City", state "State/province" from cities where country = ?', parameters.Country) - Implements a constraint, showing two columns. The first column has the title "City", the second column has the title "State/province". The data in the drop down list is a list of cities from the country as defined in the parameter Country, where the data comes from the database table cities. The actual value that is chosen is the city. The other column is only informational.

Example: JDBC.query()

• =JDBC.query('user=scott endpoint=xe', 'select global_name from global_name where rownum <= ?', 1) - returns the global name of the Oracle database. Do not use a cached value of the result.
• =JDBC.query('user=scott endpoint=xe cache=0', 'select global_name from global_name where rownum <= ?', 1) - returns the global name of the Oracle database. Do not use a cached value of the result, but do cache the result for a next time.
• =JDBC.query('user=scott endpoint=xe cache=60', 'select global_name from global_name where rownum <= ?', 1) Returns the global name of the Oracle database. Do use a cached value of the result, but only when the cached value is not older than 60 seconds.
• =JDBC.query('user=scott endpoint=xe cache=1m', 'select global_name from global_name where rownum <= ?', 1) - returns the global name of the Oracle database. Do use a cached value of the result, but only when the cached value is not older than 1 minute.
• =JDBC.query('user=scott endpoint=xe cache', 'select global_name from global_name where rownum <= ?', 1) Returns the global name of the Oracle database. Do use a cached value of the result, but only when the cached value is not older than the number of seconds as specified in the registry key /configuration/REL/JDBC/DefaultMaxCacheAge.

Example: JobChainParameters.getOutValueString()

=JobChainParameters.getOutValueString('Step 1, Job 1', 'Parameter') Returns the String Out value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getOutValueNumber()

=JobChainParameters.getOutValueNumber('Step 1, Job 1', 'Parameter') Returns the Number Out value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getOutValueDate()

=JobChainParameters.getOutValueDate('Step 1, Job 1', 'Parameter') Returns the Date Out value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getOutValueArray()

=JobChainParameters.getOutValueArray('Step 1, Job 1', 'Parameter') Returns the Array Out value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getInValueString()

=JobChainParameters.getInValueString('Step 1, Job 1', 'Parameter') Returns the String In value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getInValueNumber()

=JobChainParameters.getInValueNumber('Step 1, Job 1', 'Parameter') Returns the Number In value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getInValueDate()

=JobChainParameters.getInValueDate('Step 1, Job 1', 'Parameter') Returns the Date In value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getInValueArray()

=JobChainParameters.getInValueArray('Step 1, Job 1', 'Parameter') Returns the Array In value of the parameter named "Parameter" of the first job (Job 1) in step Step 1.

Example: JobChainParameters.getJobId()

=JobChainParameters.getJobId('Step 1, Job 1') Returns the job id of the first job (Job 1) of the step Step 1.

Example: JobChainParameters.getJobStatus()

=JobChainParameters.getJobStatus('Step 2, Job 1') Returns the job status of the first job (Job 1) of the step Step 2.

Example: JobChainParameters.getJobReturnCode()

=JobChainParameters.getJobReturnCode('Step 2, Job 1') Returns the job return code of the first job (Job 1) of the step Step 2.

Example: JobChainParameters.getJobFilePath()

=JobChainParameters.getJobFilePath('Step 1, Job 1', 'stdout.log') Returns the path to the output file of the first job (Job 1) of the step Step 1.

Example: JobChainParameters.jobFileExists()

=JobChainParameters.jobFileExists('Step 1, Job 1', 'stdout.log') Returns true if the output file of the first job (Job 1) of the step Step 1 exists and can be read.

Example: Logic.keyword_case()

=Logic.case(getSystemId(), 'redwood-university_test', 'test', 'redwood-university_prod', 'prod', 'Not Matched') Returns test on this system.

Example: Logic.keyword_if()

=Logic.if(getSystemId() === 'redwood-university_test', 'test', 'Not Matched') Returns test on this system.

Example: Logic.nvl()

=Logic.nvl(getSystemId(), 'Not null') Returns redwood-university_test on this system.

Example: Loop.getString()

=Loop.getString('symbol') Returns the value of the column named symbol as a String.

Example: Loop.getBigDecimal()

=Loop.getBigDecimal('price') Returns the value of the column named price as a BigDecimal.

Example: Loop.getDate()

=Loop.getString('date') Returns the value of the column named date as a DateTimeZone.

Example: Loop.formatBigDecimal()

=Loop.formatBigDecimal('price', '$#.00') - retrieves the value of the column named price as a BigDecimal and formats it as specified and returns it as a String.

Example: Loop.formatDate()

=Loop.formatDate('date', 'dd-MM-yyyy') - retrieves the value of the date column named date, formats it using dd-MM-yyyy and returns it as a String.

Example: Loop.reformatStringAsBigDecimal()

=Loop.reformatStringAsBigDecimal('price', '$#.00', '#,00') - retrieves the value of the column named price parses it using $#.00 and formats it using #,00 and returns it as a String.

Example: Loop.reformatStringAsDate()

=Loop.reformatStringAsDate('date', 'yyyy-MM-dd', 'dd-MM-yyyy') - retrieves the value of the string column named date, parses it using yyyy-MM-dd, formats it using dd-MMM-yyyy, and returns it as a String.

Example: getMember()

=columns.getMember('Price in EUR') - returns the value of the column 'Price in EUR'.

Example: PLSQL.booleanExpr()

• =PLSQL.booleanExpr('user=scott endpoint=xe', '? > 0', 1) Returns true. Do not use a cached value of the result.
• =PLSQL.booleanExpr('user=scott endpoint=xe cache=0', '? > 0', 1) Returns true. Do not use a cached value of the result, but do cache the result for a next time.
• =PLSQL.booleanExpr('user=scott endpoint=xe cache=60', '? > 0', 1) Returns true. Do use a cached value of the result, but only when the cached value is not older than 60 seconds.
• =PLSQL.booleanExpr('user=scott endpoint=xe cache=1m', '? > 0', 1) Returns true. Do use a cached value of the result, but only when the cached value is not older than 1 minute.
• =PLSQL.booleanExpr('user=scott endpoint=xe cache', '? > 0', 1) Returns true. Do use a cached value of the result, but only when the cached value is not older than the number of seconds as specified in the registry key /configuration/REL/PLSQL/DefaultMaxCacheAge.
• =PLSQL.booleanExpr('user=scott cache=1m', '? > ?', parameters.param1, parameters.param2) - compares two numbers defined in parameters param1 and param2. Note that this uses the System_Oracle endpoint (default)

Example: PLSQL.dateExpr()

Example: PLSQL.numberExpr()

Example: PLSQL.stringExpr()

Example: Query.getNumber()

=Query.getNumber('select Job.JobId from Job where Job.Description=\'My Job\'') Returns 21 on this system. .

=Query.getNumber('select Job.ReturnCode from Job where Job.JobId = ?', [JobChainParameters.getJobId('Step 1,job 1')], 'n') Returns 0 on this system.

Example: Query.getString()

=Query.getString('select Job.Description from Job where Job.Queue in (select q.UniqueId from Queue q where q.Name=?) order by Job.JobId DESC', ['System']) Returns My Job on this system.

=Query.getString('select Job.Description from Job where Job.JobId=?', [parameters.JOBID]) Returns My Job on this system; note that the job has a JOBID parameter of type Number that holds the actual job id.

=Query.getString('select Job.Description from Job where Job.JobId=?', [parameters.JOBID], 'n') Returns My Job on this system; note that the job has a JOBID parameter of type String that holds the actual job id, so in this case casting is required.

=Query.getString('select Job.Description from Job where Job.JobId = ?', [Query.getRelativeJob('Step 1,job 1')], 'n') - First Job on this system.

Example: Query.getRelativeJob()

=Query.getRelativeJob('Step 1, Job 1') - get the job id of the first job of the job chain step named Step 1.

Example: SAP.convertJobParameterRangesToExpression()

=SAP.convertJobParameterRangesToExpression('Step 1, Job 1', 'Parameter', 32) Returns a select option.

Example: SAP.convertRangesToExpression()

=SAP.convertRangesToExpression('IBTAAZZ', 2) Returns AA - ZZ.

Example: Table.getRow()

=Table.getRow('System_Variables', 2) Returns EMEA on this system.

Example: Table.getColumnString()

=Table.getColumnString('System_Variables', '2', 'SystemValue') Returns EMEA on this system.

Example: Table.getColumnNumber()

=Table.getColumnNumber('System_Variables', 'CCOP') Returns 13100 on this system.

Example: Table.formatRow()

=Table.formatRow('System_Variables', 2, '<row><entry>', '{1}', '</entry><entry>', '</entry></row>') Returns <row><entry>EMEA</entry></row> on this system.

=Table.formatRow('$.Countries', 49, '#', '{2}{0}={1}', '|', '#') Returns #Abbreviation=De|Conversion_Rate=1.0|Name=Germany|Translation=Deutschland# .

=Table.formatRow('$.Countries', 31, '<row><entry>', '{2}{1}', '</entry><entry>', '</entry></row>') - returns <row><entry>NL</entry><entry>1.0</entry><entry>The Netherlands</entry><entry>Nederland</entry></row>

Example: Table.l()

Example: Table.lookup()

=Table.lookup('PROD', 'CustomTable', 'Identifier10', 'ColumnA') Returns the value from the table 'CustomTable' (table is in partition 'PROD') from the row with key 'Identifier10', and from that row the value of 'ColumnA'.

=Table.lookup('CustomTable', 'Identifier10', 'ColumnA') Returns the value from the table 'CustomTable' (table is in partition 'GLOBAL', as partitionName is not specified) from the row with key 'Identifier10', and from that row the value of 'ColumnA'.

Example: UserMessage.renderHistoryAsHTML()

=UserMessage.renderHistoryAsHTML(parameters.UserMessage_UniqueId, 'aCssPrefix').

Example: UserMessage.renderHistoryAsText()

=UserMessage.renderHistoryAsText(parameters.UserMessage_UniqueId).

Example: Variable.getString()

=Variable.getString('2') Returns EMEA on this system.

Example: Variable.getNumber()

=Variable.getNumber('CCOP') Returns 13100 on this system.

Example

The following example returns the Out value of parameter Param1 on Job number 4 of step Extract data in the chain.

Partition Placeholder

The $ placeholder is replaced with the partition of the job definition or job chain it is specified on.

Substitution Parameters and REL Contexts

In fields that support REL expressions you can specify the substitution parameters using either REL variables or Ant syntax, the latter inside string literals. Note that the substitution parameters will be replaced after the REL expression has been evaluated; this means that REL will only see the substitution parameter names, not their values.

AdHocAlertSource

CallSchedulingParameter

ConstraintLOV

DefaultParameter

ForecastCallPrecondition

ForecastStepPrecondition

GotoStepEvaluation

JobChainCallPrecondition

JobChainInExpression

JobChainStepPrecondition

JobDefinitionAlertSource

JobDefinitionRuntimeLimit

JobEvent

JobSearch

MailJob

MonitorAlertSource

MonitorCondition

OSNativeParameter

ProcessMonitorEvaluation

ProcessServerAlertSource

ProcessServerCheckAlertSource

ReportColumnEvaluation

ReportPreviewDefaultParameter

ReportSelectionEvaluation

ReturnCodeMapping

SAPMassActivityParameter

Simple