CREATE VIEW vwchatdata AS (
 SELECT c.keyid,
    c.conversationid,
    c.conversationstart,
    c.conversationstartltc,
    c.userid,
    u.name AS username,
    u.department,
    u.title,
    c.chatinitiatedby,
    c.agentchatcount,
    c.agentchattotal,
    c.agentchatmax,
    c.agentchatmin,
    c.agenthasread,
    c.custchatcount,
    c.custchattotal,
    c.custchatmax,
    c.custchatmin,
    c.updated,
    c.mediatype,
        CASE
            WHEN ((c.mediatype)::text = 'chat'::text) THEN 'Chat'::text
            WHEN ((c.mediatype)::text = 'message'::text) THEN 'Message'::text
            ELSE 'Unknown'::text
        END AS mediatypedisplay
   FROM (chatdata c
     LEFT JOIN userdetails u ON (((c.userid)::text = (u.id)::text)))
)