Загрузка данных


SELECT
    qm.id AS query_model_id,
    qm.code AS query_model_code,
    qm.name AS query_model_name,
    qmq.name AS query_name,
    qmq.query
FROM dev.query_model_query qmq
JOIN dev.query_model qm
    ON qm.id = qmq.query_model_id
WHERE qmq.query ILIKE '%contract_params%'
  AND qmq.query ILIKE '%form_id%'
ORDER BY qm.name, qmq.name;




SELECT
    qm.id AS query_model_id,
    qm.code AS query_model_code,
    qm.name AS query_model_name,
    qmq.name AS query_name,
    qmq.query
FROM dev_local.query_model_query qmq
JOIN dev_local.query_model qm
    ON qm.id = qmq.query_model_id
WHERE (qmq.is_deleted IS NULL OR qmq.is_deleted = false)
  AND qmq.query ILIKE '%contract_params%'
  AND qmq.query ILIKE '%form_id%'
ORDER BY qm.name, qmq.name;