Skip to main content
Solved

Problems with "Manage Query Tables"

  • February 14, 2023
  • 2 replies
  • 117 views

rvgfox
Problem Solver
Forum|alt.badge.img+4

I’ve a query table created to my D365 F&O data source like you can see in this screenshot:

 

The query returns data as you can see in the query tool (it would be nice to be able to run it in the “Manage Query Tables” window too):

 

But, If try to Synchronize ODX Objects:

 

I get an error and there is not the table if I try to remap it:

 

 

And when I deploy and execute the table, it’s empty:

 

Is this a bug or I’m doing something wrong?

Best answer by Christian Hauggaard

Hi @rvgfox 

Once you have added the query table within the managed query window, please execute the synchronize task on the data source.

Then right click on your data source and choose select tables. Ensure that your new query table is selected. 

 

Then right click on that the transfer task and choose select tables. Ensure that your new query table is selected. 

Then execute the transfer task.

View original
Did this topic help you find an answer to your question?

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

Hi @rvgfox 

Once you have added the query table within the managed query window, please execute the synchronize task on the data source.

Then right click on your data source and choose select tables. Ensure that your new query table is selected. 

 

Then right click on that the transfer task and choose select tables. Ensure that your new query table is selected. 

Then execute the transfer task.


rvgfox
Problem Solver
Forum|alt.badge.img+4
  • Problem Solver
  • February 15, 2023

Thanks @Christian Hauggaard it was missing in the transfer task 😁


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings