---

QueryAction.action("p3x1bQiY", {
    actionComplete: function (data) {
        console.log("Результат ручного формирования УНВ:", data);
        alert("Ручное формирование выполнено");
    }
}, function () {
    return {};
});




SELECT
    "year",
    COUNT(*) AS registry_count
FROM report.smev_register
WHERE smev_register_type_code = 'УНВ'
  AND sample_status IS DISTINCT FROM 'Удалён'
GROUP BY "year"
ORDER BY "year";



SELECT COUNT(*) AS item_count
FROM report.unv_registry_item;







SELECT COUNT(*) AS setting_count
FROM report.unv_annual_setting;