LOOP_ITERATION

tazzmaxx

I was attempting to get the LOOP_ITERATION function to work and I used the exact example that is listed in the users manual:

CREATE TRANSACTION WITH Transaction.FileName=LOOP_ITERATION FOR EACH FILE IN 'c:/mydirectory'

When I attempt to save the rule I receive a syntax error (Syntax error at token "FOR EACH" (column 59)).

Also, I do not see the LOOP_ITERATION function in the list in the rule editor.

I would like to try this out as it may be very helpful.

aware_support

It's a mistake in the documentation. The correct syntax is:

CREATE TRANSACTION FOR EACH FILE IN 'c:/mydirectory' WITH Transaction.FileName=LOOP_ITERATION

tford

Hi Support,

The User Guide says "You can use LOOP_ITERATION expression to get values of the current file name, current date or current iteration number, for example:"

The example shows getting the current file name. What is the syntax for getting the date for iteration number?

aware_support

The syntax is similar:

CREATE TRANSACTION FOR EACH DATE BETWEEN MyObj.Date1 AND MyObj.Date2 WITH Transaction.CurrentDate=LOOP_ITERATION

CREATE TRANSACTION FOR EACH Number BETWEEN 1 AND 5 WITH Transaction.CurrentNmb=LOOP_ITERATION

rocketman

Hi Support, I wonder if you could help with the syntax of this one, I think I'm close. The object is for the process to create bookable training slots for each session in a training scheme at weekly intervals between the scheme start date and the end date

CREATE TS_Slots FOR EACH NUMBER BETWEEN 0 AND WEEK_DIFFERENCE(Training_Schemes.Date_Effective_From,Training_Schemes.Date_Ends)WITH TS_Slots.Slot_Date=DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION),TS_Slots.StartTime=TIMESTAMP(DAY_OF_MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),YEAR(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),HOUR(TS_Sessions.Start_Time),MINUTE(TS_Sessions.Start_Time))

Whe nI run the process, I get the following error

Type of the end boundary parameter in action CREATE TS_Slots FOR EACH NUMBER BETWEEN 0 AND WEEK_DIFFERENCE(Training_Schemes.Date_Effective_From,Training_Schemes.Date_Ends) WITH TS_Slots.Slot_Date=DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION),TS_Slots.StartTime=TIMESTAMP(DAY_OF_MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),YEAR(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),HOUR(TS_Sessions.Start_Time),MINUTE(TS_Sessions.Start_Time)),TS_Slots.EndTime=TIMESTAMP(DAY_OF_MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),MONTH(DATE_ADD(TS_Sessions.Session_StartDate,7LOOP_ITERATION)),YEAR(DATE_ADD(TS_Sessions.Session_StartDate,7*LOOP_ITERATION)),HOUR(TS_Sessions.Start_Time)+HOURS(TS_Sessions.Duration),MINUTE(TS_Sessions.Start_Time)+MINUTES(TS_Sessions.Duration)),TS_Slots.Subject=TS_Sessions.Scheme.Scheme_Name,TS_Slots.Session=TS_Sessions is invalid

rocketman

Forget last post - sorted