CREATE VIEW vwassistantenabledinteractions AS (
 SELECT d.conversationid,
    d.participantid,
    d.participantname,
    d.conversationstartdate,
    d.conversationstartdateltc,
    d.conversationenddate,
    d.conversationenddateltc,
    d.segmentstartdate,
    d.segmentenddate,
    d.segmenttime,
    d.queueid,
    q.name AS queuename,
    q.description AS queuedescription,
    q.divisionid,
    "substring"((q.description)::text, 'queuegroup=([^;]+)(;|$)'::text) AS queuegroup,
    "substring"((q.description)::text, 'region=([^;]+)(;|$)'::text) AS region,
    "substring"((q.description)::text, 'country=([^;]+)(;|$)'::text) AS country,
    q.assistantid,
    q.assistantstate,
    q.assistantmediatypes,
    q.assistantenabled,
    d.mediatype,
    d.originaldirection,
    d.purpose,
    d.segmenttype,
    d.ani,
    d.dnis,
    d.wrapupcode,
    d.wrapupnote,
    d.recordingexists,
    d.flowid,
    d.flowname,
    d.flowtype,
    d.exitreason,
    s.summarytext AS ai_summary,
    s.summarytype,
    s.summarystatus,
    s.summarygenerated,
    s.summarycreated,
    s.summarylanguage,
    s.communicationid,
    d.conversationminmos,
    d.conversationminrfactor,
    d.externaltag,
    d.disconnectiontype,
    d.transfertype,
    d.transfertargetname,
    d.updated
   FROM ((detailedinteractiondata d
     JOIN queuedetails q ON (((d.queueid)::text = (q.id)::text)))
     LEFT JOIN convvoicesummarydata s ON (((d.conversationid)::text = (s.conversationid)::text)))
  WHERE (q.assistantenabled = true)
)