[V5] sum with two column.

[pk4all]

Hello Team,

I want to use

q.sum('time_in_mintues * occurance').as('totalOprationTime')

like raw query sum(col1 * col2)
How to achieve this?
Thnaks.

[pk4all]

@thetutlage please suggest me a solution.

[pk4all]

Hi @RomainLanz any comment on this?

[McSneaky]

query.sum('(time_in_mintues * occurance) AS totalOprationTime')

Or

query.raw('SUM(time_in_mintues * occurance) AS totalOprationTime')

Might differ based on what DB you are using

[pk4all]

Thanks.

[pk4all]

query.sum('(time_in_mintues * occurance) AS totalOprationTime')

Or

query.raw('SUM(time_in_mintues * occurance) AS totalOprationTime')

Might differ based on what DB you are using

Not working with "withAggregate"

My query is

q.withAggregate('operations',otq=>{
                            otq
                            .pojo<{totalOprationTime:number}>()
                            .sum('time_in_mintues * occurance').as('totalOprationTime')
                          })

@McSneaky Please help me.

[pk4all]

query.sum('(time_in_mintues * occurance) AS totalOprationTime')

Or

query.raw('SUM(time_in_mintues * occurance) AS totalOprationTime')

Might differ based on what DB you are using

Not working with "withAggregate"

My query is

q.withAggregate('operations',otq=>{
                            otq
                            .pojo<{totalOprationTime:number}>()
                            .sum('time_in_mintues * occurance').as('totalOprationTime')
                          })

@McSneaky @RomainLanz any solution for my problom.

[lucasKuratani]

You can use Database.raw inside query.select. It also works after subqueries.

Example:

Database.from('YOURTABLE').select(Database.raw('(time_in_mintues * occurance) AS totalOprationTime'))

[pk4all]

You can use Database.raw inside query.select. It also works after subqueries.

Example:

Database.from('YOURTABLE').select(Database.raw('(time_in_mintues * occurance) AS totalOprationTime'))

How can I use this with withAggregate ?

q.withAggregate('operations',otq=>{
                            otq
                            .pojo<{totalOprationTime:number}>()
                            .sum('time_in_mintues * occurance').as('totalOprationTime')
                          })