PhuocLe - Microsoft Dynamics CRM

Howto get OptionSet NameValue by SQL Feb/11/2017


Some time, in report, you need get OptionSet NameValue by SQL

Please use this SQL

SELECT fsm.AttributeValue AS Value, fsm.Value AS Name
FROM dbo.FilteredStringMap fsm 
WHERE fsm.FilteredViewName= 'Filteredaccount' AND fsm.AttributeName = 'pl_subscription'

Note:

  • Filteredaccount = 'Filtered' + AccoutnEntityName
  • pl_subscription = OptionSet column of Account

Category: CRM
Tags:

Enter your comment

Your Name (*)
Your Email (*)
Website (*)