Query Object access to another query or view - BC SaaS

(0) Share

Report

Posted on by Anita75

1,159

Hi All,

I'm trying to build a complex query linking sales to purchases and usually when working in on-prem systems I link one view to another view or use commen table expressions (CTE). Lot of the time these views provide a way to sumamrize data in view or rank data before linking to another view. So comming back to BC cloud what options do we have in this regard? One option perhaps could be using temp tables but version 16 may not support them. Or it could be that I have to populatte a new table on run time and use that within the query which is not ideal. I know we can use Power BI to connect to multiple data sources but there are lot of instances we need to report inside BC itself

Thanks

All responses (1)

Answers (0)

Suggested answer

Marco Mels on at

Like (0)

Report

RE: Query Object access to another query or view - BC SaaS

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

dynamicsuser.net/.../developers

I will open this up to the community in case they have something to add.

Thanks.