...
crm.query.mailbox.dashboard SELECT distinct CRM_MAILBOX.id_mailbox, CRM_MAILBOX.ds_mailbox, (select count(CRM_TEAMUSERS.ID_TEAMUSERS) from CRM_TEAMUSERS (nolock) where CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox and CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team) AS nr_vinculado, (select count(CRM_USER.ID_CRMUSER)from CRM_USER (nolock) where CRM_USER.do_authenticationtype = 'C' and CRM_USER.id_crmuser = CRM_TEAMUSERS.id_crmuser and CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox and CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team) AS nr_logados FROM CRM_MAILBOX (nolock) inner join CRM_MAILBOXTEAM (nolock) on CRM_MAILBOX.id_mailbox = CRM_MAILBOXTEAM.id_mailbox inner join CRM_TEAMUSERS (nolock) on CRM_MAILBOXTEAM.id_team = CRM_TEAMUSERS.id_team inner join CRM_USER (nolock) on CRM_USER.id_crmuser = CRM_TEAMUSERS.id_crmuser GROUP BY CRM_MAILBOX.id_mailbox, CRM_MAILBOX.ds_mailbox, CRM_MAILBOXTEAM.id_mailbox, CRM_MAILBOXTEAM.id_team, CRM_TEAMUSERS.id_team, CRM_USER.id_crmuser, CRM_USER.do_authenticationtype, CRM_TEAMUSERS.id_crmuser
Jira | ||||||
---|---|---|---|---|---|---|
|
2. crm.query.mailfile.list da CRM_MAILFILE - Modificação de Query
...