Introduction

Completed

In this module, you learn how to retrieve and read data from the tables in Business Central and how to modify that data by using AL code. Additionally, you discover how to add new records into the database and how to delete records from the database.

When retrieving data, you likely want to filter it so that you don't have to retrieve all data but rather a filtered subset. Similar to SQL, you can have that data sorted for you. To be able to work with data, you need to learn about data functions, starting with the process of retrieving data with AL statements.