Datadictionary OpenWave 3.1.11 |
|
View: vwtoeststartwerk
Datadictionary OpenWave 3.1.11 |
|
View: vwtoeststartwerk
Schema
public
Owner
waveuser005
Descriptions
There is no description for view vwtoeststartwerk
Fields
Name | Data type | Description |
|---|---|---|
dnkeyomgvergunningen |
integer |
|
ddstartwrkzhn |
timestamp |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkeyomgvergunningen,
ddstartwrkzhn)
AS
SELECT tbtoestemmingen.dnkeyomgvergunningen,
min(tbtoestemmingen.ddstartwrkzhn) AS ddstartwrkzhn
FROM tbtoestemmingen
WHERE tbtoestemmingen.ddstartwrkzhn IS NOT NULL AND
tbtoestemmingen.ddingetrokken IS NULL
GROUP BY tbtoestemmingen.dnkeyomgvergunningen;
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|