Share
ReportI am trying to create a query and identify the last Operation Number in the Capacity Ledger Entry table. I want to select
column(Operation_No_; "Operation No.") {
Method = Max;
}
The issue is that it is telling me that the method can only be used on columns that have a Decimal, BigInteger, Integer, or Duration type. This column has values like '010', '020'..,100, etc.
How can I go about getting this information from Business Central. From NAV, we got it just through SQL through
SELECT [Prod_ Order No_] AS number, MAX([Operation No_]) AS operation
FROM dbo.[Capacity Ledger Entry]
GROUP BY [Prod_ Order No_]
SELECT [Prod_ Order No_] AS number, MAX([Operation No_]) AS operation
FROM dbo.[Capacity Ledger Entry]
GROUP BY [Prod_ Order No_]
Any help or guidance would be appreciated.
Thanks,
Kevin
All responses (
Answers (
159
