Sorting on Var Value in List Page

DanielF
DanielF Member Posts: 21
in NAV Three Tier
Hello eyeryone,

following issue:

I added a Field to a Table. The Value is calculated by OnAfterGetRecord-Trigger in List Page. Now when sorting on the Coloumn of this Field in List Navision shows a different amount of Records in the List Page.

Example:
Navision 2015 Demo Database.
Table Vendor extended by Integer Variable.
Function in Table Vendor to assign Value to Variable.

Function gets Called in OnAfterGetRecord-Trigger on Vendor List Page.

myvdm9px40wh.png

linz0xl09k1d.png

Can I fix this?

Work around disabling sorting on whole List is possible - is this possible only for Variable Coloumn?


Kind Regards
Daniel

Comments

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Hi,

    There was no need to add an extra field in Vendor table. All you need is a global variable on the Page, this variable needs to be used in SourceExp in the column, and its value needs to be calculated in OnAfterGetRecord - that's it. NAV will not let you to sort using that column.

    Slawek
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • DanielF
    DanielF Member Posts: 21
    Hi Slawek_Guzek,

    thanks for your reply. Yes I was wrong - I changed to Var on Page.

    Kind Regards
  • otro
    otro Member Posts: 1
    edited 2019-02-07
    Slawek_Guzek wrote: »
    Hi,

    There was no need to add an extra field in Vendor table. All you need is a global variable on the Page, this variable needs to be used in SourceExp in the column, and its value needs to be calculated in OnAfterGetRecord - that's it. NAV will not let you to sort using that column.

    Slawek

    Sorting/Filtering in List page is not available on control which source expression is variable/function.
    Only sorting of field controls available. At least in NAV2016.
  • RockWithNAV
    RockWithNAV Member Posts: 1,172
    I also faced this Sorting on Variables but eventually NAV doesn't allow to do for Variables until its a part of Table.
    Thanks

    Blog - rockwithnav.wordpress.com/
    Twitter - https://twitter.com/RockwithNav
    Facebook - https://facebook.com/rockwithnav/
  • Mark_Smart
    Mark_Smart Member Posts: 16
    Is the calculation something you could do as a flowfield? That way you could have dynamic sorting.

Categories