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.
SELECT COALESCE in table view
SELECT COALESCE in table view
- Attachments
-
- this is what we need
- 2018-01-12_145951.jpg (36.4 KiB) Viewed 1939 times
-
- this is my table
- 2018-01-12_145941.jpg (35.48 KiB) Viewed 1939 times
Re: SELECT COALESCE in table view
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
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