Stop calculating flowfields

Astinia · 2017-01-16

Hello guru,

I have a table with many flow fields at my customers database NAV2013. The Field Group is set to the: No. and Description.
If I open the list page, all the flow fields are calculated. That's correct.
If I open the drop down at other page to select my No. from the table - it again calculates all those flow fields, even though it shows only No. and Description.
I went thru code - there's nothing in the page at all (all logic in the table). In the table it also doesn't have eny CALCFIELDS.
How can I stop by drop down form calculating those flow fields?

I thought it will calculate them only, if it shows it. According to SQL Profiler - it calculates it always. I tried the same procedure with NAv2015 - the problem is still there.

Thank you

Kishorm · 2017-01-16

Even though it is not showing the list page when you do the mini drop down NAV does still run through some of the code on the list page - for example if you had set a filter in the OnPageOpen trigger then this is effective even in the mini drop down.

NAV will calculate the same FlowFields on the mini drop down as it does on the actual list page - there's no way to control that unfortunately.

Kishorm · 2017-01-16

Even though it is not showing the list page when you do the mini drop down NAV does still run through some of the code on the list page - for example if you had set a filter in the OnPageOpen trigger then this is effective even in the mini drop down.

NAV will calculate the same FlowFields on the mini drop down as it does on the actual list page - there's no way to control that unfortunately.

Stop calculating flowfields

Best Answer

Answers

Categories