json_qry_query_complete

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

query_id

int4

√

null

title

text

2147483647

√

null

active

bool

√

null

json

2147483647

√

null

Table contained 0 rows

View Definition

SELECT q.query_id,
    q.title,
    q.active,
    json_build_object('query_id', q.query_id, 'title', q.title, 'description', q.description, 'query', q.query, 'active', q.active, 'crosstab', q.crosstab, 'formal_params', ( SELECT COALESCE(json_agg(json_build_object('query_id', q.query_id, 'position', qry_parameter."position", 'name', qry_parameter.name, 'description', qry_parameter.description, 'param_type', qry_parameter.param_type_id, 'param_value', NULL::unknown) ORDER BY qry_parameter."position"), '[]'::json) AS "coalesce"
           FROM _oat.qry_parameter
          WHERE (qry_parameter.query_id = q.query_id)), 'filters', ( SELECT COALESCE(json_agg(row_to_json(foo.*) ORDER BY foo.app_id, foo.filter_id, foo.filter_group_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; SELECT q.query_id,
    q.title,
    q.active,
    json_build_object('query_id', q.query_id, 'title', q.title, 'description', q.description, 'query', q.query, 'active', q.active, 'crosstab', q.crosstab, 'parameters', ( SELECT COALESCE(json_agg(json_build_object('param_num', qry_parameter."position", 'name', qry_parameter.name, 'param_value', NULL::unknown, 'description', qry_parameter.description, 'param_type_id', qry_parameter.param_type_id) ORDER BY qry_parameter."position"), '[]'::json) AS "coalesce"
           FROM _oat.qry_parameter
          WHERE (qry_parameter.query_id = q.query_id)), 'filters', ( SELECT COALESCE(json_agg(json_build_object('app_id', oat_filter.app_id, 'filter_id', oat_filter_content.filter_id, 'filter_group_id', oat_filter.filter_group_id, 'label', oat_filter.label, 'description', oat_filter.description) ORDER BY oat_filter_content.filter_id), '[]'::json) AS "coalesce"
           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)))) AS json
   FROM _oat.qry_query q
  WHERE (q.query_id = 171);

Description

Columns

View Definition

Possibly Referenced Tables/Views