Get User CustomNotificationAddresses

select pv.StringValue, * from tbl_Identity    i
left join tbl_PropertyValue pv on pv.ArtifactId=convert(binary(16),i.id)
--where i.AccountName='danzhang'
and pv.PropertyId=32

select * from tbl_PropertyDefinition

select pd.Name, * from tbl_PropertyValue pv left join tbl_PropertyDefinition pd on pv.PropertyId=pd.PropertyId
where pv.StringValue='zhanghongjun@bjgreatsoft.com'

posted on 2017-09-06 18:48  danzhang  阅读(314)  评论(0编辑  收藏  举报

导航