What is FilterColumnName on a Query variable?

lvanvugt

If you create a Query variable the C/AL Symbol Menu shows me (among others) FilterColumnName. I have been searching for an explanation on this and couldn't find it. Does any one know what this is meant for?

geordie

Seems don't be even documented but, if QueryVariable.ColumnName retrieve the value of a column, maybe QueryVariable.FilterColumnName was intended to get the filter applied to a specific column.

It's just a guess of course...did you manage to use it in any way? I always get a compiler error.

lvanvugt

geordie wrote:

It's just a guess of course...did you manage to use it in any way? I always get a compiler error.

Nope, as it seems to be only a category name which has nothing in it.

mostafabalat

There are two types of columns in a query: regular columns that hold values, and filter columns that are not part of the query row but can be used to set up filters. The FilterColumnName property can then be used in C/AL code to set filters, such as:

SETFILTER(Posting_Date, 'xyz');

where Posting_Date is a filter column in query 19.

lvanvugt

Thanx, pal.