SELECT COALESCE in table view

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
Azizan
Posts: 1
Joined: 2018-01-04 18:31

SELECT COALESCE in table view

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.
Attachments
2018-01-12_145951.jpg
this is what we need
2018-01-12_145951.jpg (36.4 KiB) Viewed 1937 times
2018-01-12_145941.jpg
this is my table
2018-01-12_145941.jpg (35.48 KiB) Viewed 1937 times

R Tammam
Veteran Member
Posts: 113
Joined: 2017-08-26 15:35

Re: SELECT COALESCE in table view

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

Post Reply