Finance | Project Operations, Human Resources, ...

How to get the query of the data entity?

(0) Share

Report

Posted on by ..

1,965

Hi,

How can i get the query of a certain data entity?

I have the same question (0)

All responses (12)

Answers (0)

Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

Hi

Go to the database, find the data entity in the views section of your database. here you will find the complete query of your data entity.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi sheikh,

Is it normal that the query is wrong? I mean When i try to run it i got errors. So i had to edit few lines in order for the query to run

For example after inner join with a table there was no on conditiin directly after it it was after few lines

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi IntegrationBeginner,

You asked a question for some general information and now it appears that you have a specific issue. Can you share more details about what you are working on and what error you get?

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Andre,

I took part of the query. As you can see T7 doesn't have an ON condition for the inner join

If i move the on condition highlighted in yellow next to T7 then the query for the entity runs (as this is the relation on the entity itself)

But why is it wrong from the first place?

Was this reply helpful? Yes No
Suggested answer

Sheikh Sohail 6,125 on at

Like (0)

Report

I am not sure what exactly is your case, but in general, with the OOTB data entity, the query should run properly without having any issues.

If this is a custom data entity, then you need to check, how you developed the data entity. the data entity is actually viewed in the database, so what you will develop will be shown as it is in the database.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Hi IngegrationBeginner,

what you see in the database is created by D365 based on the entity definition that you have developed in Visual Studio. So if you see some issues here, you must figure them out and fix them in the entity definition in the Visual Studio.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi nikolas and sheikh,

But how come the entity is working correctly and i get no build errors

I mena what should i change if i can't see any errors?

Also i noticed that in the standard data entity ledgerjournalentity... There was no on condition next to the inner join and it was done later but it didn't fail when running it

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

You're saying that the entity is working correctly. So what exactly are you trying to achieve now? Do you have a business problem that you're trying to solve?

Anyway, the view that you see in the database is the one that D365 creates from your entity. But the entity execution in D365 is more than just that view - so you can't always expect 1:1 results from running the entity and querying the SQL view.

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

Hi Nikolaos,

So it's ok that the query is wrong even though the entity is working?

Yes i'm trying to solve the problem described in this question.

I'm getting repeated records when using recurring integration in a different environment

community.dynamics.com/.../repeated-records-in-recurring-integration

Was this reply helpful? Yes No
.. 1,965 on at

Like (0)

Report

I forgot to add to the previous reply the query error

Was this reply helpful? Yes No