Related Articles
public.vwpresencedetails
Description See PresenceDetails: Presence Code Lookup Data Table Definition CREATE VIEW vwpresencedetails AS ( SELECT pd.id, pd.systempresence, pd.orgpresence, pd.deactivated, pd.type, CASE WHEN ((pd.divisionid)::text = '*'::text) THEN dd.id ELSE ...
public.vwqueuedetails
Description See QueueDetails: Queue Lookup data Table Definition CREATE VIEW vwqueuedetails AS ( SELECT qd.id, qd.name, qd.description, "substring"((qd.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup, ...
public.vwqueueconvrealtime
Description See QueueConvRealTime: Queue Conversation Real-Time Data Table Definition CREATE VIEW vwqueueconvrealtime AS ( SELECT queuerealtimeconvdata.conversationid, queuerealtimeconvdata.media, queuerealtimeconvdata.actingas, ...
public.vwflowoutcomedetails
Description Normalized Flow Outcome Details (with division and user lookups) Table Definition CREATE VIEW vwflowoutcomedetails AS ( SELECT fod.id, fod.name, fod.description, fod.divisionid, dd.name AS divisionname, fod.operationid, CASE WHEN ...
public.vwuserdetail
Description See UserDetail: User Description in detail Table Definition CREATE VIEW vwuserdetail AS ( SELECT ud.id, ud.name, ud.jabberid, ud.state, ud.title, lower((ud.email)::text) AS email, ud.username, ud.department, ud.manager AS managerid, ...