Performance - Flow field vs Page Field

samantha73
samantha73 Member Posts: 118
in NAV Three Tier
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?

Best Answers

  • GoxyPower
    GoxyPower Member Posts: 4
    Answer ✓
    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
    GoxyPower Member Posts: 4
    Answer ✓
    Hello,

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

Answers

  • GoxyPower
    GoxyPower Member Posts: 4
    Answer ✓
    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
    samantha73 Member Posts: 118
    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
    GoxyPower Member Posts: 4
    Answer ✓
    Hello,

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

Categories