Sum if query

[bigbentobox]

Is it posisble to a make a query that do a sum with if inside?

For example :

SUM(if( users.origin IS NULL, 1,0))

Checked the documentation but don't find the if statement, there is a workaround?

[asterite]

Hello,

Could you show me the full query you want to perform, including the model you are querying against?

You could use a virtual column: https://github.com/asterite/rgviz-rails#virtual-columns

So you would do:

render :rgviz => User, :virtual_columns => {
    'user_origin_is_null' => {
        :sql => "case when users.origin is null then 1 else 0 end",
        :type => :string
    }
}

I'm not sure you can do "if" in SQL (in GQL I know you can't)