Hello,
I tried a sample based on standard app, and this one works (or at least it compiles and runs, it is not a bit of code that could probably be used for anything:
New flowfield on table 18:
tableextension 50100 CustomerExtension extends Customer
{
fields
{
// Add changes to table fields here
field(202; "Older than 45 days"; Integer)
{
CalcFormula = Count ("Cust. Ledger Entry" where("Posting Date" = filter(< 121221)));
Caption = 'Older than 45 days';
FieldClass = FlowField;
}
}
var
myInt: Integer;
}
Then add the field to Customer List (in helloworld.al):
pageextension 50100 CustomerListExt extends "Customer List"
{
layout
{
addfirst(Control1)
{
field("Older than 45 days"; "Older than 45 days")
{
ApplicationArea = all;
Caption = 'Older than 45';
}
}
}
trigger OnOpenPage();
begin
Message('App published: Hello world');
end;
var
}
That shows me 1 for all customers, and when I drill down on it, it shows the filter.
Can you check if you can get it to work in standard app? Or, if you can provide your table if that enables repro in Cronus.
Also check if you got symbols downloaded for table ContractMasterTbl, especially if the error you get - is that in the compiler, or at runtime you get it? If the table is part of an extension, you may need to make that extension a dependency in app.json.
I hope this gives some ideas, let us know how you get on.
