Trigger and Task Misc

[NiceDuck]

Halo!

There's is actually no question here. I just decided to make a thread where to compile all the trigger and task misc. inquiries that I post or found so I can easily track them out.

[NiceDuck]

Issue on transferring records using not exist.

I noticed this issue a while ago.

 

On this case, Cascade_B table is empty before the task run. After the task, it pasted every single 'aa' on the Cascade_B even though we are using a not exist condition. This is because the conditional statement is ran through all of the records on the Cascade_A table at the same time and not one after another. 

In short, the result on the Cascade_B is actually an expected behavior.

If you want your task to ran the conditions on those records from AA one at a time (to prevent duplicates), you will have to use a setup like this instead: