Datadictionary OpenWave 3.1.32

View: vwomgstringadvin

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwomgstringadvin

Fields

Rules

Indices

There are no indices for table vwomgstringadvin

Definition

CREATE VIEW public.vwomgstringadvin (
   dnkeyomgvergunningen,
   dvadviesin)
AS
WITH const AS (
SELECT tbinitialisatie.d1logic AS val1
FROM tbinitialisatie
WHERE lower(tbinitialisatie.dvsectie::text) = 'adviezen'::text AND
   lower(tbinitialisatie.dvitem::text) = 'retourisgeleverd'::text
       )
   SELECT tbadviezen.dnkeyomgvergunningen,
   string_agg(tbadviezen.dvcodeadviesinstanties::text,
       CASE
           WHEN tbadviezen.dvadvgeverpositief = 'T'::bpchar THEN '(+)'::text
           WHEN tbadviezen.dvadvgeverpositief = 'F'::bpchar THEN '(-)'::text
           ELSE '(?)'::text
       END) AS dvadviesin
   FROM tbadviezen
   WHERE tbadviezen.dnkeyomgvergunningen IS NOT NULL AND
       CASE
           WHEN ((
       SELECT const.val1
       FROM const
       )) = 'F'::bpchar THEN tbadviezen.ddadviesdatum IS NOT NULL
           ELSE tbadviezen.dddateringadvies IS NOT NULL
       END AND tbadviezen.ddvervallen IS NULL
   GROUP BY tbadviezen.dnkeyomgvergunningen;

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49