Customizing
Version 27 Version 26 39.5.25 39.5.23 39.5.22 39.5.21 39.5.20 39.5.19 39.5.18 39.5.17 German English
Version 27 Version 26 39.5.25 39.5.23 39.5.22 39.5.21 39.5.20 39.5.19 39.5.18 39.5.17 German English

DT312 Triggers

DI065523 UUID

Universally Unique Identifier (UUID) of a trigger. It is created automatically.

DI065526 Changed on

When a record is modified, the modification date is automatically entered here.

DI065529 Changed by

When a record is modified, the ID (code) of the logged-on user is automatically entered in this field.

DI065537 Function name

Full name of the (static) class method to be executed including its path.

Examples

  • ppms.start_migration.doSomething

  • de.planta.server.events.EventManager.insertNewEvent

DI065538 DT

ID of the data table to which a data-driven trigger refers.

DI065543 Condition

Condition which analyzes a Jython function before the start of a data-driven trigger. If this function returns True, the trigger is started.

Note

  • If the condition is empty, the method is always executed without Jython check function.

DI065544 Parameter

Freely definable string for the method to be executed. What exactly should be entered here depends on the function defined for the trigger. See function name

DI065545 Activated

Values

  • - The trigger is running.

  • - The trigger is ignored.

DI065557 Position

Integer value for sorting data-driven triggers and server startup triggers. Determines in what sequence the triggers are executed.

Details

  • If several data triggers are initiated at the same time because they have been defined in the same table for the same trigger type, the triggers will be executed starting at the lowest position number.

  • If two data triggers have the same position number, the following order applies: 1. Java, 2) Jython, 3) Python.

DI065862 Trigger type

Determines the trigger type of data-driven triggers.

Values

Value

Description

714: Pre-insert

Is executed for insert tasks before saving.

715: Pre-update

Is executed for update tasks before saving.

716: Pre-delete

Is executed for deletion tasks before saving.

717: Post-insert

Is executed for insert tasks after saving.

718: Post-update

Is executed for update tasks after saving.

719: Post-delete

Is executed for deletion tasks after saving.

777: Pre-save

Is executed for insert and update tasks before saving. A pre-insert and pre-update-trigger.

778: Post-save

Is executed for insert and update tasks after saving. A post-insert and post-update-trigger at the same time.

883: On-change

Is executed before saving whenever a data field is changed.

7: Timed trigger

Is executed at particular points in time regardless of changes made to data (time-controlled triggers).

8: Simple repeating

Simplified, time-controlled trigger which is executed every x minutes (only used internally)

9: Startup

Trigger which is only executed once upon each server start


See also: Programmable Triggers

DI065864 Function type

Determines which type of method is called.

Values

  • 1: Java

  • 2: Jython

  • 3: Python

Currently, only Jython and Java functions are supported for time-controlled triggers.

DI066389 Name

Name of a time-controlled trigger

The parameter can be edited in the following module by users with modification rights:

DI065866 Status

Status of a time-controlled trigger. Is automatically adjusted to the execution of a trigger.

Values

  • 0: Waiting

    • The trigger is currently scheduled to run at another time.

  • 1: Is running

    • The function assigned to the trigger is currently running.

  • 2: Terminated

    • The trigger was terminated without errors and will not be executed again.

  • 3: Failed

    • An error has occurred during the last execution. The trigger will be executed again after server restart.

Note

  • A manual change of the status has no influence on whether an trigger is executed again or not. Its execution only depends on the Activated parameter as well as of the interval settings of the trigger.

DI065871 Starting date

Date at which the time-controlled trigger will be started the next time.

DI065872 Starting time

Time at which the time-controlled trigger will be started the next time on the defined date (DI065871 Starting date).

DI065922 Data table

ID of the data table which a data-driven trigger refers to.

DI065923 Data table

DI066054 Day

This parameter serves to define on which date a time-controlled trigger is to be executed for the first time.

DI066055 Time

This parameter serves to define at which time of the day a time-controlled trigger is to be executed for the first time.

DI066057 Recurs every (number)

Interval (in numbers) between the recursion of a user-defined time-controlled trigger. The unit is defined via the DI066074 Recurs every (unit) parameter.

DI066059 Recurs: Monday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066060 Recurs: Tuesday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066061 Recurs: Wednesday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066062 Recurs: Thursday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066063 Recurs: Friday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066064 Recurs: Saturday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066065 Recurs: Sunday

Parameter for user-defined time-controlled triggers. Defines whether the trigger can run on the respective weekday.

DI066066 Never ends

Parameter which determines the end of a user-defined time-controlled trigger. If the parameter is activated, the trigger has no end.

DI066067 Ends on

Parameter which determines the end of a user-defined time-controlled trigger. Here you can specify the date on which the trigger is to be terminated.

Note

  • For the trigger to end on the specified date, the checkbox for parameter DI066069 must be activated.

DI066068 Ends after

Parameter which determines the end of a user-defined time-controlled trigger. Here you can specify the number of repetitions after which the trigger is to be terminated.

Note

  • In order for the trigger to be terminated after the defined number of repetitions, you have to DI066070 activate the checkbox of the DI066070 parameter.

DI066069 Ends on - checkbox

Parameter which determines the end of a user-defined time-controlled trigger. If the parameter is activated, the trigger ends on the date which is specified in the DI066067 Ends on parameter.

DI066070 Ends after - checkbox

Parameter which determines the end of a user-defined time-controlled trigger. If the parameter is activated, the trigger ends on the date which is specified in the DI066068 Ends after parameter.

DI066072 Recurs

The frequency at which a time-controlled is executed.

Interval

Description

Once

The trigger is executed once at the planned point in time and does not recur.

Hourly

The trigger recurs every hour.

Daily

The trigger recurs every day.

Weekly

The trigger recurs every seven days.

Monthly

The trigger recurs the next month on the same week day, e.g. on the first Monday or on the last Friday of a month.

Yearly

The trigger recurs on the same date in the following year. Triggers on 02/29 only recur in leap years.

User-defined

A user-defined interval is specified. This allows for a more detailed configuration.

DI066074 Recurs every (unit)

Time unit which defines the interval between repetitions of a user-defined time-controlled trigger. The exact interval is defined in numbers using the DI066057 Recurs every (number) parameter.

Values

  • minutes

  • hours

  • days

  • weeks

  • months

  • years

DI066077 Last execution date

Date of the last execution of a time-controlled trigger.

DI066078 Last execution time

Time of the last execution of a time-controlled trigger.

DI066092 Number of executions

Specifies how often a time-controlled trigger has already been executed.