web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Customer experience | Sales, Customer Insights,... Custom Case origin is ...

Customer experience | Sales, Customer Insights,...

Suggested Answer

Custom Case origin is not exist in dabatase table StringMapBase

(0) Share

Report

Report

Posted on by Hamisati Muftia

5

Hello,

I'm and IT support in my company and I'm new to CRM.

So, our business users requested to add new case source : WhatsApp .

I've managed to add that in : Customization -> Customize The System -> Option Sets . Our users is able to create cases with this origin as well.

However, cases with this origin needs to appear in our existing report (we use Microsoft Reporting Service).

So, I need to locate where this WhatsApp value in database (on-premises).

I used query : select * from StringMap where AttributeName='caseorigincode'

To my surprise , query results shows all case origin except newly added : WhatsApp.

Is it because I added custom value ? Or, did I look up wrong table ? Any idea what tables I should look ?

Thank you in advance.

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Tarcisio Vilas Boas Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hey, try to check on StringMapBase, that has no filter, since StringMap is a filtered view.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1

ManoVerse 75 Super User 2026 Season 1

#2

Muhammad Shahzad Sh... 69 Most Valuable Professional

#3

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans