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) / How to find fields in ...
Microsoft Dynamics CRM (Archived)

How to find fields in database.?

(0) ShareShare
ReportReport
Posted on by Abdul Wahab 12,119 Moderator

Hi all,

I have to find opportunity# and Owner field in the database. Where should I find it.? I am finding it on opportunity table. I have requirement. I have to build report through report builder.

5657.Untitled9.png 3386.Untitled8.png

Thank you

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Alagunellaikumar Profile Picture
    Alagunellaikumar 6,212 on at

    If you are look in to opportunity table in database.Always search table in database with their corresponding entity ends with base.

    If you have CRM 2011 then for each customized entity there are two tables

    1)base table =opportunityBase

    2)Customization on opportunity =OpportunityExtension

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,119 Moderator on at

    Hi Alagu nellaikumar.S

    Teacher, I find it on both tables but unable to see them in it.

    Thank you

  • Abdul Wahab Profile Picture
    Abdul Wahab 12,119 Moderator on at

    Hi Teacher,

    name is opportunity field in the database. What is the field for owner.?

    Thank you

  • Verified answer
    Alagunellaikumar Profile Picture
    Alagunellaikumar 6,212 on at

    In the table you have only ownerId but in the view you get ownername

    select OwnerIdName from Opportunity

  • Verified answer
    JohnAnonymous Profile Picture
    JohnAnonymous 5,241 on at

    I'm not very sure, but in the database I would expect this is the field ownerid in the table opportunityBase. That field is a guid and is a foreign key to the systemuserBase table. You need to join those to get the user details.

    It's been a while since I accessed the db directly, so I might be off on naming conventions.

  • Verified answer
    PS Profile Picture
    PS 23,577 on at

    Hi Abdul,

    Either use SELECT * FROM dbo.FilteredOpportunity

    or

    SELECT * FROM dbo.Opportunitybase

    fow owner its ownerid

    Following blog will help u because you are creating a custom report and you will have to get the owner name instead of owner's GUID

    missdynamicscrm.blogspot.com.au/.../crm-2011crm-2013-filtered-view-return-nodata.html

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