Forum Discussion

Siva_Venna's avatar
Siva_Venna
Contributor
6 years ago

Table name in SQL select snap

Hi, I have few tables on SQL server like abc_2020 abc_2019 abc_2018 I want to query the the table that has suffix as current year. I have specified the value in the settings > table name-- ...
j_angelevski's avatar
j_angelevski
Contributor III
4 years ago

Hi @MikeP,

In that case your expression should work because $.isEmpty() should return true. Not sure why it doesn’t work for you, but you can also try with the following: $.values().length == 0. Can you also share your settings in the router snap ?

MikeP's avatar
MikeP
New Contributor II
4 years ago

hi j.evegelvski, sorry for delayed reply.

I think I sussed it now.

!$.isEmpty() although no errors syntactically on setting it in the expression validation, it doesn’t seem to functionally work.

However, $.isEmpty() == false, the more explicit syntax, does work, therefore the router flow now conforms as expected.

Thanks for your assistance!