Datadictionary OpenWave 3.1.11 |
|
View: vwfrminitialisatie
Datadictionary OpenWave 3.1.11 |
|
View: vwfrminitialisatie
Schema
public
Owner
waveuser005
Descriptions
View van instellingen waarbij passwords getoond worden als ****. Basistabel tbinitialisatie
Fields
Name | Data type | Description |
|---|---|---|
dnkey |
integer |
|
dvsectie |
char(50) |
|
dvitem |
char(50) |
|
d1logic |
char(1) |
|
dfnumber1 |
double precision |
|
dfnumber2 |
double precision |
|
dddatum |
timestamp |
|
dvstring |
varchar(255) |
|
dvinfo |
varchar(255) |
|
Rules
Name | Event | Instead | Condition | Description |
|---|---|---|---|---|
_RETURN |
SELECT |
|
|
|
Definition
dnkey,
dvsectie,
dvitem,
d1logic,
dfnumber1,
dfnumber2,
dddatum,
dvstring,
dvinfo)
AS
SELECT a.dnkey, a.dvsectie, a.dvitem, a.d1logic, a.dfnumber1, a.dfnumber2,
a.dddatum,
CASE
WHEN upper(a.dvsectie::text) = 'DOCUMENTEN'::text AND
upper(a.dvitem::text) = 'OPHALENVIAFILESERVER_PASSWORD'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELING ZAAK'::text AND
upper(a.dvitem::text) = 'HTTPAUTHENTICATIEPASS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELINGDOCNAARDMS'::text AND
upper(a.dvitem::text) = 'HTTPAUTHENTICATIEPASS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELINGDOCNAARDMS'::text AND
upper(a.dvitem::text) = 'PASS_CMIS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELINGBAG'::text AND
upper(a.dvitem::text) = 'HTTPAUTHENTICATIEPASS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELINGGBA'::text AND
upper(a.dvitem::text) = 'HTTPAUTHENTICATIEPASS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
WHEN upper(a.dvsectie::text) = 'KOPPELINGNHR'::text AND
upper(a.dvitem::text) = 'HTTPAUTHENTICATIEPASS'::text AND a.dvstring IS NOT NULL THEN '****'::character varying
ELSE a.dvstring
END::character varying(255) AS dvstring,
a.dvinfo
FROM tbinitialisatie a;
COMMENT ON VIEW public.vwfrminitialisatie
IS 'View van instellingen waarbij passwords getoond worden als ****. Basistabel tbinitialisatie';
This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 22-2-2017 10:50 |
|