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

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Soner Taskin 60 on at

Like (0)

Report
Copy link

Link copied!

select AttributeValue, Value

from StringMap

where ObjectTypeCode = 1 -- entity type code

and AttributeName = 'new_fieldname --fieldname

Was this reply helpful? Yes No
joman 617 on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No