Is there a way to create a dynamic OR clause in Boomi database write operation?
Having it only generate:
condition AND condition AND condition
is limiting in the extreme.
I see the solution. Just use standard insert/update/delete. Although it is confusing to see there are no CONDITIONS to define as in the dynamic insert/update/delete, just use the FIELDS in the same order that you want them in the query. Map them to the profile with values required prior to issuing the database connector operation.
Retrieving data ...