2、员工离职的owner code更改如下命令的srep_code值区分大小写,必须用大写, 先运行第二步,导出之后给销售部,让他们按照文件更改完毕,再执行第一步,导出之后的文件让销售部根据导出文件全部改完之后,再执行第三步,再给销售部做完,即可去停用此员工的账号1.查找的属于某个owner的profile(含company及contact)select * from name$owner where primary_yn='Y' and inactive_date is null and user_id=(selec
3、t person_name_id from application$_user where srep_code='**')2.查找的属于某个owner的profile(仅仅含company)select * from name$owner where primary_yn='Y' and inactive_date is null and user_id=(select person_name_id from application$_user where srep_code='**') and name_id i
4、n (select name_id from name_view where name_type='COMPANY')3.查找的属于某个owner的Blockblock的查询语句就是把name$owner 换成book$owner, book$owner里面的event id就是block idselect * from book$owner where primary_yn='Y' and inactive_date is null and user_id=(select person_name_id from
5、application$_user where srep_code='**')在profile search界面,把鼠标点在client id的地方, 然后按住ctrl shift双击鼠标左键,就可以看到client id变成了name id然后就可以用这个name id来查询