Datadictionary OpenWave 3.1.34

View: vwhhstringadvuit

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwhhstringadvuit

Columns

Rules

Indices

There are no indices for table vwhhstringadvuit

Definition

CREATE VIEW public.vwhhstringadvuit (
   dnkeyhandhavingen,
   dvadviesuit)
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 dnkeyhandhavingen,
   string_agg(dvcodeadviesinstanties::text, ' '::text) AS dvadviesuit
   FROM tbadviezen
   WHERE dnkeyhandhavingen IS NOT NULL AND
       CASE
           WHEN ((
       SELECT const.val1
       FROM const
       )) = 'F'::bpchar THEN ddadviesdatum IS NULL
           ELSE dddateringadvies IS NULL
       END AND ddadviesdatum IS NULL AND ddvervallen IS NULL
   GROUP BY dnkeyhandhavingen;

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 18/05/2026 15:10