Difference between FILTER & CONST

upasanisandipupasanisandip Member Posts: 405
Hi all,
Anyone knows the difference between FILTER & CONST in report in DataItemTableView property.

Or specifically when to use FILTER & CONST .


thanks.

Comments

  • NaviDevNaviDev Member Posts: 365
    Filter and CONST are type of fixed table filtering upon loading of the object.

    How does it differ.

    Filter - You can specify range value. ex. 1..1000 (filter the value form 1 to 1000 in the specified field).

    CONST - also filtering but does not support range. ex. 1 (will filter the value 1 in the specified field).
    Navision noob....
  • kinekine Member Posts: 12,562
    FILTER(A&B) - will filter on A and B (nothing will be found)

    CONST(A&B) - will filter on exact value 'A&B'.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.