第1个设置的选择与图片一致
第2个问题我把视图的语句列出,麻烦看下有没有特殊的地方
Select
t2.Name,
t2.Touchpoint_ID,
t1.Year,
t3.ASN,
t1.User,
ifnull(t2.Manager,t3.LineManager) as 'Manager',
t2.Date,
ifnull(t2.Status,"Not Submitted") as 'Status'
from
MidYear_Touchpoint_User t1
left join User_Info t3 on t3.用户名 = t1.User
left join Touchpoint t2 on (t2.Employee = t1.User and t2.Name like t1.Year||'%' and t2.Type ='Mid-Year')
第3点,工程使用内部数据库,不涉及外联库 |