×

扫描二维码登录本站

标签: 暂无标签
Oops! 发生了一个错误.
No result for the single row query: 'SELECT DISTINCT `Contact_contact`.`id` AS `Contactid`, `Contact_contact`.`name` AS `Contactname`, `Contact_contact`.`status` AS `Contactstatus`, `Contact_contact`.`org_id` AS `Contactorg_id`, `Organization_org_id_organization`.`name` AS `Contactorg_name`, `Contact_contact`.`email` AS `Contactemail`, `Contact_contact`.`phone` AS `Contactphone`, `Contact_contact`.`notify` AS `Contactnotify`, `Contact_contact`.`function` AS `Contactfunction`, `Contact_contact`.`finalclass` AS `Contactfinalclass`, IF((`Contact_contact`.`finalclass` IN ('Team', 'Contact')), CAST(CONCAT(COALESCE(`Contact_contact`.`name`, '')) AS CHAR), CAST(CONCAT(COALESCE(`Contact_fn_Person_person`.`first_name`, ''), COALESCE(' ', ''), COALESCE(`Contact_contact`.`name`, '')) AS CHAR)) AS `Contactfriendlyname`, COALESCE((`Contact_contact`.`status` = 'inactive'), 0) AS `Contactobsolescence_flag`, `Contact_contact`.`obsolescence_date` AS `Contactobsolescence_date`, CAST(CONCAT(COALESCE(`Organization_org_id_organization`.`name`, '')) AS CHAR) AS `Contactorg_id_friendlyname`, COALESCE((`Organization_org_id_organization`.`status` = 'inactive'), 0) AS `Contactorg_id_obsolescence_flag` FROM `contact` AS `Contact_contact`INNER JOIN `organization` AS `Organization_org_id_organization` ON `Contact_contact`.`org_id` = `Organization_org_id_organization`.`id`LEFT JOIN `person` AS `Contact_fn_Person_person` ON `Contact_contact`.`id` = `Contact_fn_Person_person`.`id` WHERE (`Contact_contact`.`id` = 1) '

如果问题仍然存在,请联系管理员.




上一篇:问题管理中工作任务开始结束时间如何修改成非必填项
下一篇:大神请教事件管理配置项
鲜衣怒马

写了  篇文章,拥有财富 ,被  人关注

您需要登录后才可以回帖 登录 | 立即注册
B Color Link Quote Code Smilies
woolpost 发表于 2019-7-19 22:45:43
本帖最后由 woolpost 于 2019-7-19 22:46 编辑

请在db中执行上面的sql语句,确定执行成功后,请检查数据库连通性
以上是此问题解决方法!

Powered by ITIL  © 2001-2025
返回顶部