web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Retrieving entity name...
Microsoft Dynamics CRM (Archived)

Retrieving entity name using GUID value in SQL Server

(0) ShareShare
ReportReport
Posted on by synthesis 212

Hello. I am administering a CRM 4.0 system. I have been running a number of SQL queries in SQL Server on the <my_org>_MSCRM database. The case (incident) entity has a lookup field which is linked to a custom entity called Town. There are a number of case records that have been created by end users with the Town field filled in. Using SQL queries on the CRM database server, I have been trying to retrieve the Town value (as it would appear in the end user's case when opened in CRM). The closest I have got is retrieving the GUID values for the Town field using IncidentExtensionBase.new_townid. I could not find a field which gives the Town name. Using an SQL query how could one retrieve the Town name? 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    gdas Profile Picture
    gdas 50,091 Moderator on at

    Hi ,

    Are you getting any error ? If you  try to retrieve directly data from Town entity , did you get the data?

    Try to retrieve from town and in the Town entity you will find incident id by which you will get the the IncidentExtensionBase data. So just do reverse process .

  • Verified answer
    Flydancer Profile Picture
    Flydancer 1,332 on at

    Hi synthesis,

    you should have a look at the "FilteredIncident" View. There should be a field like new_townidname.

    Here is a good read about filtered views: community.dynamics.com/.../crm-2015-why-filtered-views-are-useful

    Otherwise you could use the townid to join on the new_townbase table in your query if you want the "raw" data.

  • Suggested answer
    RaviKashyap Profile Picture
    RaviKashyap 55,410 Moderator on at

    Each lookup is tied up with an entity and each entity has its won table. So you need to find the table for Town entity and then select the name from that table by passing the town id.

  • Rajesh Chungath Profile Picture
    Rajesh Chungath 467 on at

    Please query on FilteredTown view based on townid

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans