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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment