70

Extend the Query object or give possibilities to use SQLCommand DotNet interoperability

In the current NAV 2018 on-premises we make use of SQL Command to produce high performing queries and more flexible queries than the current NAV Table and Query objects allow us. Typical TSQL commands we use are Like statement More sophisticated OR statements inner join cross apply union Date for...

Read more...

1 Comments

Read more... 1 Comments

Category: Development (888)

STATUS DETAILS
Declined
Ideas Administrator
Thank you for your feedback. We are not considering the suggestion at this time due to the following reason: 
1) for security reasons, we cannot give free access to the database. 
2) for performance and stability reasons, we need to be able to control the joins sent to the database

What we are doing instead in every release is to invest in making the Business Central data stack better and more performant.

Sincerely,

Kennie Nybo Pontoppidan

PM, Microsoft
69

Ability to Execute Tests from Visual Studio Code

If we were able to run tests from Visual Studio Code (and from some command line application - like we can build using alc.exe) it would make a massive improvement to the efficiency of development (and probably the uptake in writing and running tests). This presupposes that you have the releva...

Read more...

4 Comments

Read more... 4 Comments

Category: Development (888)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap.

Your help is greatly appreciated,
Business Central Team
68

Allow Sorting Property on Lists

It would be very useful to be able to define if a specific column can be sorted or not. In case a list contains flowfields (e.g. Amount on Customer Ledger Entries), the user can choose to sort the list producing heavy workloads on the SQL server. An AllowSort property can solve the issue mainta...

Read more...

1 Comments

Read more... 1 Comments

Category: Development (888)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap.


Your help is greatly appreciated,

Kennie Nybo Pontoppidan 

PM, Microsoft 
67

Consider different settings per folder within a VS Code workspace

Using a workspace, the settings for enabling code cops in folder A (app) and disabling them in folder B (test) are not considered - which is a bug. However, my GitHub request to fix that was not accepted. Read about the details here: https://github.com/microsoft/AL/issues/5489 Please vote to mak...

Read more...

2 Comments

Read more... 2 Comments

Category: Development (888)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap.

Best regards,
Business Central Team
66

Report RDLC Layout Real-time Preview

Hello, I have an idea how to accelerate RDLC report layout designing. Consider that report creating is composed of two parts: a) Define Dataset in *.al b) Define Report Layout in *.rdlc Printing report processing means: a) Evaluate Dataset (Dataset.xml) b) Evaluate Parameters (Paramset.xml) c)...

Read more...

6 Comments

Read more... 6 Comments

Category: Development (888)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team
66

Re-enable multi-level tree list support in Webclient (ShowAsTree / IndentationControls)

Windows client provided support to build 'dynamic' pages using collapsing tree views. Collapsing / expanding tree nodes was userfriendly, since it limits the information shown when loading the page and allows to user to decide on what node / level information was needed. However, since the mov...

Read more...

2 Comments

Read more... 2 Comments

Category: Development (888)

STATUS DETAILS
Completed
Ideas Administrator
Good news! We released this feature as part of 2020 Release Wave 1.

Please refer to the following link for more information:

Best regards,
Mike Borg Cardona
Program Manager, Microsoft
65

Enable specifying objects by name in properties like SourceTableView, CalcFormula, etc.

from https://github.com/microsoft/AL/issues/6163 -- Describe the bug When setting up SourceTableViews, TableRelations, and so on - that relate to other tables by table IDs (or, far less frequently, specify codeunit IDs to run, etc.) - we still have to use the raw integer ID, which is ugly, opa...

Read more...

2 Comments

Read more... 2 Comments

Category: Development (888)

STATUS DETAILS
Planned
2022 Release Wave 2
Ideas Administrator
Thank you for this suggestion! We are shipping this in 2022 release wave 2. You can already now try it out in insider VSIX builds.

Instead of e.g., 
SourceTableView = where("Source Type" = const(18));

it will be possible to use the option name, i.e.,<br>
SourceTableView = where("Source Type" = const(Database::Customer));

Best regards,
Business Central Team
65

Ability to suspend and restart Code Analysis

When developing in a big workspace and/or in a big single-folder solution it is not always helpful to have the code analyzed as You go. - Code Analysis will often be slow to react - Code Analysis will be surfacing errors and warnings not related to what You are actually doing at the moment So t...

Read more...

2 Comments

Read more... 2 Comments

Category: Development (888)

STATUS DETAILS
Under Review
Ideas Administrator
Thank you for your feedback. We are considering adding it to our longer term roadmap.

Best regards,
Business Central Team
63

"Go to definition" more than once when you are in the base App

When we are using "Go to definition" it works fine as long as I am moving in my own objects. When I use "go to definition" on a "Base App" or "System App" object, a .dal-file is opened, which is fine in the first place, but in many cases I want to navigate through other objects of the Base/System...

Read more...

0 Comments

Read more... 0 Comments

Category: Development (888)

STATUS DETAILS
Completed
Ideas Administrator
Thank you for your valuable feedback. We have decided to deliver this idea and make it available with Business Central 2020 Wave 2, as well as Business Central 2020 Wave 1 CU2

Up until now Go-to-Definition (F12) has relied on retrieving sources from server, and to support multiple configurations, we added  a defaultLaunchConfigurationName setting to indicate which connection to use. This caused unwanted side-effects, so we have restructured F12 to rely on local dependency applications for resolving the source of a reference symbol for apps with runtime versions >= 5.2 (2020 Wave 1 CU2).

This implies that DAL file symbol source navigation support multiple steps/depth as long as symbols are present. There is no support for going a step back again though, i.e., Alt+Arrow Left will go back to starting point. Also, note that F12 will use local symbols which might not reflect server versions - this is relevant when using F12 to navigate into, e.g., a referenced extension to set breakpoints.

For versions <= 5.2 Go to Definition will work as before defaultLaunchConfigurationName, i.e., no source file for reference symbols on a Go to Definition if more then one debug configuration is defined.

Your help was greatly appreciated,  
Peter Borring
PM, Microsoft  

63

Global event - OnOpenPage

We have a requirement to trigger some code any time ANY page is opened (related to some enhanced security functionality). Right now we have to subscribe to EVERY page's openpage event to run our code. It would be great if there was a global trigger that fired any time any page is opened. We co...

Read more...

2 Comments

Read more... 2 Comments

Category: Development (888)

STATUS DETAILS
Needs Votes
Ideas Administrator
Thank you for this suggestion! We are tracking this idea and if it gathers more votes and comments we might consider it in the future.

However, a generic event is currently not on the roadmap due to performance impact of such a generic event, i.e., having to call subscriber code on every page open, regardless of whether subscriber is applicable to page or not (this will slow down page rendering, an area which is very sensitive to performance degradation and is causing customer concern). 

In addition, the problem with a global OnOpenPage is how to give access to the page being opened (related to https://github.com/Microsoft/AL/issues/1593)? There is currently not a generic page concept, so just adding the event will probably not solve anything. 

It would be great of you could provide some examples in comments on what you would like to use the event for (i.e., what business logic to run on all pages), as the solution to those scenarios that might be something different than a global event.

Best regards,
Business Central Team