Recently, I was asked how to change the output format of Duration data type, how to convert the unit to hours or minutes, etc. So, today I would like to briefly discuss Duration data type in Business Central.
Tag Archives: Data
How to edit and view (ascii) data in Business Central
In this video, I show how to add a data editor to Business Central. I’m implenenting the Ace editor. This is the editor I use in several projects, including BCScript and WSFN from E Foqus.
Delaying Power BI Dataset Refresh Until The Source Data Is Ready
This week a customer came to me with the following problem: they had scheduled the refresh of their dataset but their source data wasn’t always ready in time, so the old data was being loaded by mistake. The best solution here is to use some kind of external service (for example Power Automate) to poll the data source regularly to see if it’s ready, and then to refresh the dataset via the Power BI REST API when it is.
Smarter Data Types in AL
In this video, I investigate the new data types in AL. Lately, I have been thinking about ways to make internal data types smarter and better for my use.
Import data with the Excel Buffer
In this video, I show an old favorite, the Excel Buffer. A great way to get data into Business Central. I create a few handy extra functions to make the experience nicer.
Analyze data using Query Analyzer in Business Central
Inline Query Analyzer is a tool to analyze data in Business Central. This is an open source project intended to help developers for quick retrieval of data for analysis purposes. You can write SQL like queries to retrieve data. Users can view the query results in Grid and JSON views.
Basics of JSON data types in Business Central
This post is about understanding the basics of JSON and how to handle JSON data in Business Central AL Language using JSON data types. JSON data types are introduced in AL Language with Business Central / Microsoft Dynamics NAV 2018. JSON stands for JavaScript Object Notation. The JSON format is a lightweight data interchange format originally specified by Douglas Crockford.