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.
