vw_provhub_calls

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

transaction_time

timestamptz

35,6

√

null

application_name

text

2147483647

√

null

serialnumber

text

2147483647

√

null

status_prev

text

2147483647

√

null

status_actual

text

2147483647

√

null

cust_prev

varchar

20

√

null

cust_actual

varchar

20

√

null

product_prev

varchar

2147483647

√

null

product_actual

varchar

2147483647

√

null

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT logged_actions.action_tstamp_tx AS transaction_time,
    logged_actions.application_name,
    btrim((logged_actions.row_data -> 'serialnumber'::text)) AS serialnumber,
        CASE btrim((logged_actions.row_data -> 'status'::text))
            WHEN '1'::text THEN 'Active'::text
            WHEN '2'::text THEN 'Inactive'::text
            ELSE NULL::text
        END AS status_prev,
    COALESCE(
        CASE (logged_actions.changed_fields -> 'status'::text)
            WHEN '1'::text THEN 'Active'::text
            WHEN '2'::text THEN 'Inactive'::text
            ELSE NULL::text
        END,
        CASE btrim((logged_actions.row_data -> 'status'::text))
            WHEN '1'::text THEN 'Active'::text
            WHEN '2'::text THEN 'Inactive'::text
            ELSE NULL::text
        END) AS status_actual,
    c1.erpid AS cust_prev,
    COALESCE(c2.erpid, c1.erpid) AS cust_actual,
    p1.erpname AS product_prev,
    COALESCE(p2.erpname, p1.erpname) AS product_actual
   FROM ((((((audit.logged_actions
     LEFT JOIN technicalaccount ta1 ON ((ta1.idtechnicalaccount = (btrim((logged_actions.row_data -> 'idtechnicalaccount'::text)))::integer)))
     LEFT JOIN client c1 ON ((c1.idclient = ta1.idclient)))
     LEFT JOIN technicalaccount ta2 ON ((ta2.idtechnicalaccount = ((logged_actions.changed_fields -> 'idtechnicalaccount'::text))::integer)))
     LEFT JOIN client c2 ON ((c2.idclient = ta2.idclient)))
     LEFT JOIN product p1 ON ((p1.idproduct = ta1.idproduct)))
     LEFT JOIN product p2 ON ((p2.idproduct = ta2.idproduct)))
  WHERE ((logged_actions.table_name = 'device'::text) AND (logged_actions.application_name = 'ProvHub'::text) AND ((logged_actions.row_data -> 'serialnumber'::text) IS NOT NULL) AND ((btrim((logged_actions.row_data -> 'status'::text)) <> COALESCE((logged_actions.changed_fields -> 'status'::text), btrim((logged_actions.row_data -> 'status'::text)))) OR ((p1.erpname)::text <> (COALESCE(p2.erpname, p1.erpname))::text) OR ((c1.erpid)::text <> (COALESCE(c2.erpid, c1.erpid))::text)));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views