Currently you have to program this. Having the possibility to be able to simply select the query object in the Sourcetable/DataItem would be a great improvement.
And even if it's only as Read-Only that would also work.
Queries are faster then records, even if the data is not cached.
This would give us the possibility to improve performance of certain pages/reports. And also to reuse these queries in different pages/reports. And also, because queries can join and aggregate date from multiple tables, that would also be a great advantage to have in pages/reports.
Comments
That was one of the first remarks i made when i entered the world of Business Dynamics.
I was used to make screens and reports in MS Access, the majority was based on querys and not direct on tables.
I believe this should be a normal facility is a so called relatinal database and therefore was suprised (dissappointed) that BC does not support this.
Category: Development
That would be really appreciated. Can we extend the feature request to XMLPort aswell ?
Category: Development
Business Central Team (administrator)
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team