Articles on: Tips and tricks

Common Problems & Things to Consider

Mapper Connector


use single quote ' instead double quotes "

Calculation, Math and Expressions


Calculate in mapper then put them in variable to be used later on
Consider fragmentation using () general function expression
Compare always use variables

SQL Syntax


Sql syntax prepare it in variables (not in mapper). Bug everything after dynamic field will be taken out
!!! Select from xxx where id = '<dyamic>' and 'bbb', everything after dynamic will be eaten
Into postgresql ensure not mix left and right sqlsyntax variables in a single mapper. Prepare gradually (fragment by fragement)


Failure Notifications


Email will be sent on workflow error concurrency 1, 3, and 7. Then it will auto disabled the scheduler on concurrent error number 7

Updated on: 10/02/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!