View vwinfoaantopenadviezen

Datadictionary OpenWave 3.1.33

View: vwinfoaantopenadviezen

Schema

public

Owner

waveuser005

Descriptions

There is no description for view vwinfoaantopenadviezen

Columns

Name	Data type	Description
aantalopenadv	bigint
dnkeyinfoaanvraag	integer

Rules

Name	Event	Instead	Condition	Description
_RETURN	SELECT

Indices

There are no indices for table vwinfoaantopenadviezen

Definition

CREATE VIEW public.vwinfoaantopenadviezen ( aantalopenadv, dnkeyinfoaanvraag) AS SELECT sum(1) AS aantalopenadv, a.dnkeyinfoaanvraag FROM tbadviezen a JOIN tbinfoaanvragen b ON a.dnkeyinfoaanvraag = b.dnkey WHERE b.ddblokkeerdatum IS NULL AND a.ddadviesdatum IS NULL AND a.ddvervallen IS NULL GROUP BY a.dnkeyinfoaanvraag;

This file was generated with SQL Manager for PostgreSQL (www.sqlmanager.net/products/postgresql/manager) at 21-10-2025 10:22