Configurations from backend

Use full queries that can be configured only via backend.

How to make the "Total" default report card always appear.

Run the below script

PL/pgSQL

set role <org_name>;

update organisation_config
set settings = settings || '{"hideTotalForProgram": false}' ::jsonb,
    last_modified_date_time = now()
where organisation_id = <org_id>;