SIFT

omyvadiya

Hi,
I am new to navision, i have read the SIFT technology, only one query.
We define SumIndexField to a key, but how we know to which key we have to assign the SumIndexField.
As in Customer table, For Balance field Flowfield is defined. How can it be related to the key and which key.
Please clarify.

kriki

NAV is intelligent enough to figure out which key it can use to calculate the flowfield. It scans the keys of the underlying table 1 by 1 and if it finds a key with SIFT-fields that can be used, it will use that key.

vaprog

At least on a native db, the key needs to include all fields on which a (flow-)filter is set. I am not sure whether this requirement is relaxed on an SQL server environment, but probably not (I am not talking about the SQL Server index nor the SQLIndex, MaintainSQLIndex properties here).

Furthermore, NAV uses the first key that matches the requirements, not the best one.

kriki

SQL has the same requirements but you can opt to change the index in SQL (SQLIndex-property), to maintain or not the SQL Index (MaintainSQLIndex-property) or to maintain or not the SQL SIFT (MaintainSIFTIndex-property).

In NAV2013, it is not necessary anymore to have a key in NAV anymore! You can calculate SIFT-fields in any way conceivable without having a SIFT-key for it.