Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey guys,
Im reading an SQL query from and populating a table, which works fine!
Now I would like to set a where statement so to speak in an expression. so that rows onyl shows where my column: Registration isNull or has an empty value.
May add this in your expression:
{<Registration = {"=NullCount(Registration) > 0"}>}
or
{<Registration = {"=Len(Trim(Registration)) = 0"}>}
Which database it is? Oracle or Sql server? want to restrict at back end or front end?
Alternatively create a flag in the script like this:
If(Len(Trim(Registration)) = 0, 1, 0) as Flag
and then use the flag
{<Flag = {1}>}
SQL server
try
Sum({1-$<Registration ={'*'}>}Value)
Not working 😕
Not a sum just a if function
still not clear what you want to achieve it. Please elaborate.
I think creating the flag in the script will be the most easy way to do it.