20
It would be great to have the possibility to be able to use a query object as a SourceTable for a page and a DataItem for a report directly.
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.
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.
STATUS DETAILS
Needs Votes
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