Finance forum

creating query in AOT

(0) Share

Report

Posted on by dark_knight

768

Hello,

I'm trying to create my own AOT query in AX7.

I follow thus article:

https://docs.microsoft.com/en-us/dynamicsax-2012/developer/walkthrough-creating-an-aot-query-that-has-group-by-and-having-nodes

I'd like to add count(RecId) field to field node as they write here:

Fields

Add a field under the new CustTable data source node.

Expand the new data source node.
Right-click the Fields node, and then click New > COUNT.
In the Properties window for the new field node, set the Fieldproperty to RecId.

ANSI SQL typically uses an asterisk for the count aggregate function. But in Microsoft Dynamics AX a field must be used, and by convention the RecIdfield is usually used.

I use standard table "CustTable" as a datasource and can't add a field:

I also can't add CustTable extension to my datasources node of the query. So the question is how to add count field?

Thanks.

Categories:

Development / Customization / SDK

All responses (3)

Answers (1)

Suggested answer

Satish Panwar 14,645 on at

Like (0)

Report

RE: creating query in AOT

Hi Azat,

By default the setting is unselected and that should allow the field addition. Did you change the setting to "Yes" when you added the data source.

Thanks,
Satish Panwar
Please take time to click 'Yes' against the answers that help you guide in right direction to help other community members
Verified answer

Andrew Xu 3,877 on at

Like (0)

Report

RE: creating query in AOT

Hi Azat,

To add field in your datasource, you need to set the property 'Dynamic Fields' of your datasource to 'No'.
Martin Dráb 230,445 Most Valuable Professional on at

Like (0)

Report

RE: creating query in AOT

Try changing the Dynamic Fields property of CustTable datasource to No.

You can't add table extensions. Add the extended table instead; it'll include fields from your extension.