Please enable JavaScript to view this site.

Administration manual

Navigation: Tech Doc > External processing of instances > Automatic process initiation

Fill process table

Scroll Prev Top Next More

The insstring column can be used to pass process data to a new JobRouter instance. It can be used to fill the various columns of the JobRouter process table with values. Those assignments have to be done in the following format: "FieldName=FieldValue". If there are more than one assignment, they have to be separated by a semicolon.

Example: INVOICENUMBER=201029389;DATE=27.09.2009;SUPPLIER=JOBROUTER

Please note: Semicolons inside the values have to be escaped by using a backslash (e.g. "Field1=Va\;lue1;Field2=..."

The following example shows an SQL query to start a simple process:

 

INSERT INTO JRJOBIMPORT 

(

    processname,

    version,

    step,

    initiator,

    insstring

VALUES 

(

    'Incoming Invoices',

    0,

    1,

    'admin',

    'INVOICENUMBER=201029389;DATE=27.09.2009;SUPPLIER=JOBROUTER'

)