The Filter key word returns an array of data, so why not call it an Array. It's one less piece of mental gymnastics you have to go through. By allowing both Filter and Array, you would allow backwards compatibility as well as allow experienced use...

If you want to create a filter to include everything that starts with XX, but exclude everything that ends in YY, you have to use a combination of NL("Filter") and NP("Difference") functions. The example given below is very unintuitive and difficu...

It is not uncommon to use array processing in Jet to do otherwise difficult calculations. The classic example is customers with no sales. Rather than require 3 different lines to accomplish this, why not combine them into a single, compact key wor...

Currently, users write logical expressions in Jet Reports using C/AL Operators. While use of these operators are understood better by users who also use them in Dynamics NAV, they are not as intuitive to users as graphical interfaces that use visu...