Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) How do you search the ...

How do you search the Dynamics 365 database

(0) Share

Report

Posted on by Alex Lapointe

Hi,

I'm having trouble finding things in the database of Dynamics 365 with Power BI, when you connect to the OrganizationData.svc, there is a LOT of table, and sub table.

For exemple, I'm working with the table "OpportunitySet", someone add a custom combobox, I'm able to get the value "176000004", but I can't find a way to get the text value from this.

I search in the "PickListMappingSet", but there is too much stuff.

Also, all my Opportunities have a Team and people in those teams, I think they are link with "Connections", but I have no idea how to obtain them, I need to find some opportunities who have missing people in their team.

Is there any way to search everywhere in the database, or to find where each value is store in it.

Thanks

*This post is locked for comments

All responses (2)

Answers (0)

joman 617 on at

Like (0)

Report
RE: How do you search the Dynamics 365 database

select your_field, your_fieldName from FilteredOpportunity where your_conditions

It is better to query from Filtered views. They contains information, depends on user preferences and access.
Soner Taskin 60 on at

Like (0)

Report

RE: How do you search the Dynamics 365 database

select AttributeValue, Value

from StringMap

where ObjectTypeCode = 1 -- entity type code

and AttributeName = 'new_fieldname --fieldname