AnsweredAssumed Answered

process stops upon no query results

Question asked by allan.ford577519 on May 22, 2017
Latest reply on May 23, 2017 by 51662476


I have an email notification process that I was keen to have email even if the query returns no rows ..


The Boomi process stops however at this point ..


I guess I can trick the Oracle query into returning at least 1 row ..


i.e. do the query I want and then union with a selection from dual with all null value columns matching desired query .. 


There might be another way ..

i.e. use a process branch .. cache ..


I could do an upfront select count(*) .. and then branch different paths depending upon result of select count(*) .. 


Is this a common requirement / issue ?

Any comments / suggestions appreciated.