Datadictionary OpenWave 3.1.32
Previous topic Chapter index Next topic

View: vwomgstringadvuit

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

There is no description for view vwomgstringadvuit

 

Fields

Name

Data type

Description

dnkeyomgvergunningen

integer

 

dvadviesuit

text

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwomgstringadvuit

 

Definition

CREATE VIEW public.vwomgstringadvuit (
   dnkeyomgvergunningen,
   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 tbadviezen.dnkeyomgvergunningen,
   string_agg(tbadviezen.dvcodeadviesinstanties::text, ' '::text) AS dvadviesuit
   FROM tbadviezen
   WHERE tbadviezen.dnkeyomgvergunningen IS NOT NULL AND
       CASE
           WHEN
((
       SELECT const.val1
       FROM const
       )) = 'F'::bpchar THEN tbadviezen.ddadviesdatum IS NULL
           ELSE
tbadviezen.dddateringadvies IS 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
Previous topic Chapter index Next topic