The SetJobVariable() function saves a value or an object at the job (workflow). This can then be used in a mapping and EntityIfCase executed later via GetJobVariable or used in the BackendObject.
The X-Path value is saved, which can be used to store entire structures. Which is why a Trim() is also necessary if you only want to save the content, in the following case the value of @Name.
Variables for the DB adapter must start with eBiss.DBadapter.1). With e.g.:
SetJobVariable('ebiss.dbadapter.ComanyName', Trim(@Name))
you can define the variable value of the following WHERE condition:
[Where(" = $CompanyName ")] public string Name;
If you need a numerical value, e.g. if the document number in the DB is numerical, you can achieve this with :
SetJobVariable('ebiss.dbadapter.DocNumber', MakeNumeric(@DocNumber))
When used in the Where condition, the numerical value is thus obtained without quotation marks.
[Where(" = $DocNumber")] public string Name;
SetJobVariable('Name of variable', 'value')
SetJobVariable('LastFilename', 'MyFile_1.dat')