Performance - Flow field vs Page Field

samantha73

Hi All
I'm trying to show item category code on the item ledger entries page and looking at the best implementation. I could create a flow field on the table and show it on page. Or I can create a page field and use on after get record or some trigger to populate it via a procedure on the page. Which one is more performant and any other ideas?

GoxyPower

Hello,

Flowfield is more elegant.
To gain performance be sure to add key for Item Category Code field
in the Item table.

Best regards,

GoxyPower

Hello,

In the Item table you should add "Item Category Code" as a Key

GoxyPower

Hello,

Flowfield is more elegant.
To gain performance be sure to add key for Item Category Code field
in the Item table.

Best regards,

samantha73

Thanks. How do you "add key for Item category code" in item table? As currently I have only added below to ILE and no other changes
FieldClass = FlowField;
CalcFormula = max(Item."Item Category Code"
WHERE(
"No." = field("Item No.")

));

GoxyPower

Hello,

In the Item table you should add "Item Category Code" as a Key