Skip to content
+1-888-319-3663

EONE BLOG

Introducing the Query Builder for Dynamics 365 Business Central


The biggest problem we see with the cloud is that you do not have table-level access for reporting. We’ve fixed this issue for Dynamics 365 Business Central with the Query Builder, which is a new feature now available with the Popdock for Dynamics 365 Business Central app.



Table-level queries without code


With the Query Builder, everyone can build their own optimized queries right from BC tables. The easy interface lets you select tables and fields, and then join them to other BC tables to build your own query.

These queries can be simple or complex. You have access to:
  • Tables and columns across all your Dynamics 365 Business Central data – even ISV tables, your extensions, and all your dimensions.
  • Search and select any fields you want to use – even the ones that aren’t exposed on your Dynamics 365 Business Central pages.
  • Create joins and see both left/right outers.
  • Use restrictions and summarize.
  • Build really rich queries that are optimized for performance.
The best part about this is you will never have to write AL code for your queries again.

Publishing your Dynamics 365 Business Central API


Then, with a click of a button you can publish the query as a Dynamics 365 Business Central endpoint to use where you’d like – in PowerBI, for your integrations, or for any other way you’d like to call that data.

Essentially, this means users have the power to create and modify optimized API queries for Dynamics 365 Business Central quickly without needing to learn or write any AL code. We think this will be pretty powerful for our partners to deliver requirements faster without custom development and for our customers to have all the reporting power they want as they move to the cloud.

Check out a quick introduction of the Query Build in action here:


To access the Query Builder for Dynamics 365 Business Central:

1. Get started with a Popdock Business Level Plan.
2. Access and download Popdock from Dynamics 365 Business Central.

If you have any questions about getting started, reach out to our team via chat or at sales@eonesolutions.com. We’re happy to help you get started with the Query Builder for Dynamics 365 Business Central.

Leave a Comment





RECENT POSTS


2022 Q2 Partner All Hands Call - Recording Now Available!
Embed External Data on Any Dynamics 365 Business Central Window Without Code.
Tech Tuesday: Executing SmartConnect 2018 Maps from SQL
Best Practices of Integrating Salesforce and D365 Business Central - Part Three: Integration Strategy
Best Practices of Integrating Salesforce and D365 Business Central - Part Two: Data Strategy in Integrations

POPULAR POSTS


2016 SmartConnect Integration Bootcamps
Tech Tues: Automatically refreshing Pivot Tables in Excel Refreshable Reports
Happy Thanksgiving from the eOne team!
2017 SmartConnect Integration Bootcamps
New Releases of Extender and SmartList Builder

CATEGORIES

TAGS

Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Meet the Team Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships partners Popdock promotions release SalesForce SalesForce.com SmartConnect SmartConnect.com SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.