public.vwqueuedetails

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,
    "substring"((qd.description)::text, 'region=([^;]+)(;|$)'::text) AS region,
    "substring"((qd.description)::text, 'grouptype=([^;]+)(;|$)'::text) AS grouptype,
    "substring"((qd.description)::text, 'country=([^;]+)(;|$)'::text) AS country,
    "substring"((qd.description)::text, 'language=([^;]+)(;|$)'::text) AS language,
    "substring"((qd.description)::text, 'accountowner=([^;]+)(;|$)'::text) AS accountowner,
    qd.divisionid,
    divisiondetails.name AS divisionname,
    divisiondetails.name AS vwuserpresencedata,
    qd.enabletranscription,
    qd.isactive
   FROM (queuedetails qd
     JOIN divisiondetails divisiondetails ON (((qd.divisionid)::text = (divisiondetails.id)::text)))
)

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) true Primary Key/Queue ID
name varchar(255) true Queue Name
description varchar(255) true Queue Description
queuegroup text true Queue Group
region text true Region
grouptype text true Group Type
country text true Country
language text true Language
accountowner text true
divisionid varchar(50) true Queue Division ID
divisionname varchar(50) true Queue Division Name
vwuserpresencedata varchar(50) true User Presence Data
enabletranscription boolean true Enable Transcription Yes/No
isactive boolean true Active Yes/No

Referenced Tables

Name Columns Comment Type
public.queuedetails 7 Queue Lookup data BASE TABLE
public.divisiondetails 4 BASE TABLE

    • Related Articles

    • public.vwuserqueuemappings

      Description UserQueueMappings: View for mappings in between User and Queue Table Definition CREATE VIEW vwuserqueuemappings AS ( SELECT qm.queueid, qd.name AS queuename, qm.userid, ud.name, ud.department, ud.managername, qm.divisionid FROM ...

    • public.vwqueueauditdata

      Description Audit Table for Queue Membership changes Table Definition CREATE VIEW vwqueueauditdata AS ( SELECT qa.queueid, qa.userid, ud.name, ud.department, ud.managername, qa.addorremove, qa.activeorinactive, qa.datemodified, qa.modifiedby, ...

    • public.vwrealtimequeue

      Description Real-time queue data Table Definition CREATE VIEW vwrealtimequeue AS ( SELECT qd.id AS queueid, qd.name AS queuename, qd.divisionid, qd.divisionname, qr.media, sum( CASE WHEN ((qr.actingas)::text = 'acd'::text) THEN 1 ELSE 0 END) AS ...

    • public.vwuserinteractiondata

      Description See UserInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwuserinteractiondata AS ( SELECT userinteractiondata.keyid, userinteractiondata.startdate AS startdateutc, userinteractiondata.startdateltc, ...

    • public.participantattributesdynamic

      Description Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false conversationid varchar(50) false conversationstartdate timestamp without time zone false conversationstartdateltc timestamp without time zone true ...