Business Central Execute Queries from Pages

Business Central Execute Queries from Pages With the QueryCategory property we can execute a query object from a page (also available in Smartlists) by defining a query in AL; it is possible to declare with a comma separated list where the object can be used, in practice it is added to the list of objects … Read more

Business Central Queries VS Views

Business Central Queries VS Views Queries and Views are two very interesting objects for Business Central, that can be used for various purposes. As both can be used, I point out the differences and the ways of using them with a couple of examples. In this Scenario the battle card is: “Queries VS Views” …a … Read more

A Visual SQL Query Designer – Code project (SQL From NAV Part III)

A Visual SQL Query Designer – Code Project (SQL From NAV Part III) If some of your customers asks you to gain access to SQL data directly from NAV (as other systems with integrated query editors..) can use this nice tool to run SQL queries (or others T-SQL statements…). This tools recalls some typical features of SQL Studio … Read more

%d bloggers like this: