how/where is case type and activity type is stored in crm database.. as we need it in (varchar) but when i saw its showing its in (int)
*This post is locked for comments
how/where is case type and activity type is stored in crm database.. as we need it in (varchar) but when i saw its showing its in (int)
*This post is locked for comments
we did not get yet.. showing not found
SQL Query to retrieve text of option set
This might help: stackoverflow.com/.../crm-2011-sql-query-to-retrieve-text-of-option-set
More Details:
Case: msdn.microsoft.com/.../gg328291.aspx
Case type & other fields: msdn.microsoft.com/.../mt593043.aspx
Activity:https: //msdn.microsoft.com/en-us/library/gg327870.aspx
Activity type: msdn.microsoft.com/.../gg328546.aspx
Hi Sandeep,
Case type is stored in incidentbase table while activity type is stored in activitypointerbase table
Hello,
You should check StringMapBase table or FilteredStringMap view.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156