Notifications
Announcements
No record found.
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
Hello,
You should check StringMapBase table or FilteredStringMap view.
Hi Sandeep,
Case type is stored in incidentbase table while activity type is stored in activitypointerbase table
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
SQL Query to retrieve text of option set
This might help: stackoverflow.com/.../crm-2011-sql-query-to-retrieve-text-of-option-set
we did not get yet.. showing not found
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
