Hi i have google cloud vm, i have a domain that serves my app, now i create another ngnix server configuration for my hasura console, My app works fine on my domain, but when i try https://mydomain:8080 http://mydomain:8080 etc i…
I have written this postgres function in hasura CREATE OR REPLACE FUNCTION get_shipday_filter(p_carriercode TEXT, p_shipdate DATE) RETURNS table(shipday text, delivered int, transit int, refused int, undeliverable int, total_exceptions int) AS $$ SELECT view_group_by_shipday_filter.shipday AS shipday, sum(view_group_by_shipday_filter.delivered) AS delivered, sum(view_group_by_shipday_filter.transit) AS…
In the UI I have a table where I'm showing data grouped by shipday which is days of the week. To do that in the hasura I've created a PostgreSQL view - CREATE OR REPLACE VIEW "public"."view_shipday" AS SELECT shipdata.shipday,…