Home > Forum > Rules, JS, SQL > SQL query for calculated column suddenly no longer working when added as constant

SQL query for calculated column suddenly no longer working when added as constant
0

Hello folks,

We have used constants which contain SQL queries for calculated report collumns a couple of times already, so this does work.

But i now have a query which works perfectly when added into the calculated collumn directly, but no longer works when stored in a constant. (img attached)
Through logs we found that he has a problem seemingly with strings, but we found no way to baypass that.

Anyone have an idea what is done with the query on the way or why this might be the case?