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,
    qd.callslatargetperc,
    qd.callslatargetduration,
    qd.callbackslatargetperc,
    qd.callbackslatargetduration,
    qd.chatslatargetperc,
    qd.chatslatargetduration,
    qd.emailslatargetperc,
    qd.emailslatargetduration,
    qd.messageslatargetperc,
    qd.messageslatargetduration,
    qd.assistantid,
    qd.assistantstate,
    qd.assistantmediatypes,
    qd.assistantenabled,
    qd.member_count,
    qd.user_member_count,
    qd.joined_member_count,
    qd.skill_evaluation_method
   FROM (queuedetails qd
     JOIN divisiondetails divisiondetails ON (((qd.divisionid)::text = (divisiondetails.id)::text)))
)