Dynamics CRM
Wednesday, January 28, 2015
Query for getting label of Optionset Used in SSRS report
select t1.activityid,t1. abc_tasktype,t2.value as ActivityName FROM Task t1
left outer join StringMap t2 on
(t2.AttributeName = 'abc_tasktype'
and t2.ObjectTypeCode = 4212)
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment