Boolean value for Boolean column in SQL Widget

Boolean value for Boolean column in SQL Widget

  

Hi,in my SQL , the where clause {SRAction}.[IsActive] need to be always true.The code is as per below.

SyntaxEditor Code Snippet

{SRAction}.[IsActive]=True

However, it i hits error as per below

By removing the where clause, the SQL is running fine.

Does anyone has idea on this?Help !!

Solution

Hi Johnson,

You need to write where condition like below:

where {SRAction}.[IsActive]=1


Regards

-SK-

Solution

Thanks Shashi

You are welcome !

Regards

-SK-

I want to add that for such a simple query, you should use an Aggregate, not a SQL!