RE: Creating queries dynamically
Hi Josh,
thank you for this info, but I need solution without customer intervention.
I'm developing control add-in that will be embedded inside BC. This control add-in will have business logic and based on current state I need to dynamically create queries to expose the data.
One solution would be to dynamically create AL files and compile extension outside of BC and install it to expose API's. This whole procedure can be automated, but it's not acceptable in my case because I would need external server to do this.
The other solution is to use RecordRef.Open(tableId), read content and return it to caller. But I don't wan't to do this, because I suppose concating large strings can be big issue. As well as this isn't elegant solution
If I could expose api's programatically would be perfect solution for my case
