Skip to content

Instantly share code, notes, and snippets.

View sshinde01's full-sized avatar

Soniya Shinde sshinde01

View GitHub Profile
-- Task#DEV-215125 Add new column to rdb_report_versions table
-- Database: reports
-- Add filters column of type JSON to rdb_report_versions table
ALTER TABLE rdb_report_versions
ADD COLUMN IF NOT EXISTS filters JSONB DEFAULT '{}';
-- Add comment to the filters column for documentation
COMMENT ON COLUMN rdb_report_versions.filters IS 'Stores report filter and dataset columns configurations in JSON format';