Forum Discussion

vincenr's avatar
vincenr
New Contributor III
4 years ago

How can I test for no rows back from Oracle query

I am trying to figure out how to route to a ‘no data’ path when nothing is returned from my select query. Can someone help me out? What I’ve tried is (in ‘Is there data?’ snap): $retval != n...
koryknick's avatar
koryknick
Employee
4 years ago

Rather than returning a dummy record, you could also check the returned document equal to an empty object. For example:

$ == {}

This can be your Router check condition if no data was returned by the select since if anything was returned, it would not be an empty object.

vincenr's avatar
vincenr
New Contributor III
4 years ago

Ok, so I changed the pipeline to compare $ = {} but it’s not working for me.