Results 1-10 of 125 for queries
Query Tool/Wizard
...Dynamics 365 Business Central...
Category: Reports and Business Intelligence (370)
Add changecompany, functions and changecompany to Query
...Dynamics 365 Business Central...
Category: Development (1534)
AppSourceCop analyzer should check for breaking changes also on Query objects
...Dynamics 365 Business Central...
Category: Development (1534)
Adjust DataItemTableFilter handling in Queries
...Dynamics 365 Business Central...
Category: Development (1534)
Create Pages Based on Queries
...Dynamics 365 Business Central...
Category: General (2123)
Additional field - Inventory by location query
...Dynamics 365 Business Central...
Category: Inventory (462)
Add Support for HTTP Method QUERY- RFC 10008
...Dynamics 365 Business Central...
Category: Development (1534)
Pages, Tables, Reports and Queries as Interface Implementations
...Dynamics 365 Business Central...
Category: Development (1534)
Run a query from code
...Query.Run(Query::"My Query") Query.RunModal(Query::"My Query") MyQuery.Run() MyQuery.RunModal() I see two reasons for this: We could use QueryCategory to make a query available from a page but you can only set one QueryCategory per page and this property cannot be set by pageextension objects....
Category: Development (1534)
multi-branch query design
...Under that root DataItem (and under any parent DataItem), allow multiple child DataItems at the same level (siblings), each with its own: JoinType (Left/Inner, and Right if applicable) DataItemLink / join criteria to the parent Filters / DataItemTableView Conceptual example: Sales Header (single root) Sales Line (Inner Join) Approval Entry (Left Join) Warehouse Shipment Line (Left Join) Expected benefits More visual, expressive multi-branch query architecture Less AL plumbing (less manual merging / fewer temporary tables) Improved maintainability (centralized structure and filtering) Preserves the Query object’s SQL pushdown intent Important note The main objective is not to enable something that is completely impossible otherwise, but to modernize the Query design experience: make query structures more expressive, maintainable, and closer to how developers naturally model joins, while still keeping a single root DataItem....
Category: Development (1534)
Helpful resources
| Top authors | Ideas submitted | Ideas implemented |
|---|---|---|
| 158 | 28 | |
| 76 | 23 | |
| 78 | 22 |