SELECT COALESCE in table view

Azizan · Post by **Azizan** » 2018-01-12 08:13

hello, we use appgini a couple days ago

how to use "Select Coalesce" or maybe another querry syntax ? we need to create a count of record in every group in a one line querry. and then in sub-total row, we need to create different color backgroud.

we attach my table. it woud be very appreciate if we can find solution in here.

R Tammam · Post by **R Tammam** » 2018-01-22 09:18

Hello Azizan,

i couldn't find any query syntax to select what you want , but you can use App Gini custom pages , and count them manually

an idea for counting , you can select distinct company values and itterate over the table to count them

AppGini Community Forums

SELECT COALESCE in table view

SELECT COALESCE in table view

Re: SELECT COALESCE in table view