This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- 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'; |