Microsoft Dynamics AX 2012 Data Selection and Manipulation

Learn to create and run a select statement in Dynamics AX 2012, selecting data from customer table with select star and select first, and understand its role before data manipulation.

Explore using the select statement to fetch and manipulate data, declare and use a table variable, apply filters, select specific columns, and apply aggregate functions.

Learn to use the select statement to query the customer table where district_id equals 10. Print matching accounts and loop through results with next and while.

Learn to fetch the first record or multiple records efficiently with first only and fast only, using offset and filters to control data retrieval.

Sort results with the order by clause by selecting a column and choosing ascending or descending order. Sort by account number or segment to control sequencing.

Learn to use the and operator in a select statement to filter records by multiple conditions, such as static group and id filters, demonstrated through shell-based queries.

Learn how the or operator builds layered filters across fields, applying or logic and fallback criteria when a condition fails to refine results.

Learn how to optimize data retrieval in Dynamics AX 2012 by selecting only the needed fields instead of all columns, speeding queries and reducing errors.

Learn to use the group by clause to aggregate sales data, sum line amounts, and include all selected fields in the group by, with proper order by usage.

Learn to use the index name in a select statement, apply index offset, and see how indexed queries can beat order by for faster data retrieval.

Learn how to use indexes with select statements to return data in sorted order, and how order by uses a chosen index to enforce this ordering.

Apply aggregate functions in a select statement to compute count, sum, average, max, and min, with group by across customer id and line amount to produce totals and summaries.

Learn to build a join query by selecting data from the sales table, sales line, and time table using a join and where conditions.

Learn to select a single field using a join between related tables, as shown in this lesson. Optimize queries by avoiding full-table selects and retrieving only the needed field.

Explore outer joins in Microsoft Dynamics AX 2012 data selection, contrasting inner joins that require a match with outer joins that return records from parent or child tables.

Explore exists join in Microsoft Dynamics AX 2012, a join type that checks for a related record and fetches data only from the parent table when it exists.

Explore the not exists join in microsoft dynamics ax 2012, contrasting it with inner joins, and learn how to fetch records from the primary table when no related record exists.

demonstrates selecting specific fields from a sales table and inserting them into a new table, using an insert method, and preparing for a while loop in the next lesson.

Learn to select multiple records by status, insert them into a target table, and manage the transaction with begin and commit in AX 2012 data selection and manipulation.

Master ttsBegin and ttsCommit to begin and commit transactions in Microsoft Dynamics AX 2012, ensuring data integrity during insert, update, and delete operations.

Validate records before writing to a table by selecting a record, performing a boolean validation in an if condition, and conditionally inserting or handling errors.

Learn how the insert method handles data in Microsoft Dynamics AX 2012, and how the DoInsert method can bypass this logic when overriding Insert, though it's not recommended.

Learn how to update a record in microsoft dynamics ax 2012 by using select for update, modify table variables, execute the update method, and commit changes step by step.

Learn how to update multiple records by using select for update, update with, and a while loop; the lecture demonstrates updating the email table records and verifies the changes.

Learn how to bypass the update method by using the DoUpdate method when you have overwritten the update logic in Microsoft Dynamics AX 2012 data selection and manipulation.

Master deleting a record in Microsoft Dynamics AX 2012 by creating a delete method, selecting the table, and applying select for update to perform a valid removal.

Learn to delete multiple records in Microsoft Dynamics AX 2012 by selecting and removing them, and delete a single unique record using the record.

Master the do delete method in Microsoft Dynamics AX 2012 by overriding the delete routine and bypassing delete logic to perform insert, update, and delete operations.

Learn about insert recordset in Dynamics AX 2012, copying data via selection and manipulation from one table to another on a server with faster set-based inserts and insert buffer preprocessing.

Demonstrates insert record set in Dynamics AX 2012 by creating a method, declaring a table variable, and inserting data from sales and email tables using a select statement.

Learn how to use update record set to update multiple records in a single server trip, faster than the update method that updates records one by one.

This demo shows how to create a new method, declare a table variable, and use update_recordset to update delivery name fields with a where condition, then verify overwritten data.

Learn to delete multiple records with a delete from statement, a faster alternative to looping with the x record to delete method. This approach reduces server trips and improves performance.

Learn how to delete records in the demo table using delete from, including deleting all data, running the command, and validating table state, with insert/update as needed.

Explore intercompany data insertion in Microsoft Dynamics AX 2012 by inserting records into multiple companies, using change company and a container loop to mirror data from USMF to BRMF.

Learn to update records across multiple companies in Dynamics AX 2012 by adjusting the update statement, changing the company context, and managing buffers to avoid cross company errors.

Learn to delete records across multiple companies in Microsoft Dynamics AX 2012 by converting an update routine to a delete, using the change company method, and validating results.