json_qry_query_info

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

query_id

int4

√

null

active

bool

√

null

json

2147483647

√

null

Table contained 0 rows

View Definition

SELECT q.query_id,
    q.active,
    json_build_object('query_id', q.query_id, 'title', q.title, 'description', q.description, 'active', q.active, 'filters', ( SELECT COALESCE(json_agg(row_to_json(foo.*) ORDER BY foo.app_id, foo.filter_id), '[]'::json) AS "coalesce"
           FROM ( SELECT 'qry'::text AS app_id,
                    qry_parameter.param_type_id AS filter_id,
                    'param'::text AS filter_group_id,
                    oat_filter.label,
                    oat_filter.description
                   FROM (_oat.qry_parameter
                     JOIN _oat.oat_filter ON ((qry_parameter.param_type_id = oat_filter.filter_id)))
                  WHERE (qry_parameter.query_id = q.query_id)
                UNION
                 SELECT oat_filter_content.app_id,
                    oat_filter_content.filter_id,
                    oat_filter.filter_group_id,
                    oat_filter.label,
                    oat_filter.description
                   FROM (_oat.oat_filter_content
                     JOIN _oat.oat_filter USING (app_id, filter_id))
                  WHERE ((oat_filter_content.app_id = 'qry'::text) AND (oat_filter_content.id = q.query_id))) foo)) AS json
   FROM _oat.qry_query q;

Description

Columns

View Definition

Possibly Referenced Tables/Views