Hi All,
I know you can develop queries in AL and use them for reports etc. Now since many of us are proficient in t-sql already is there any way to use this? For example I have the on-premise BC and cloud BC so I can create a sql query and then copy it to some extension that will convert to AL code or use sql views but somehow publish it to the cloud version?
I know the LinkedObjects function but assume it only works on-premise
In the past I've used complex sql queries on on premise systems for reporting and event capturing now I'm just wondering if there is short cut other than using AL from scratch
Thanks

Report
All responses (
Answers (