mibuso.com
Home› NAV Three Tier
Options

What is FilterColumnName on a Query variable?

lvanvugtlvanvugt Member Posts: 774
edited 2014-07-23 in NAV Three Tier
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?
Luc van Vugt, fluxxus.nl
Never stop learning
Van Vugt's dynamiXs
Dutch Dynamics Community

Answers

  • Options
    geordiegeordie Member Posts: 655
    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.
    * Daniele Rebussi * | * Rebu NAV Diary *
  • Options
    lvanvugtlvanvugt Member Posts: 774
    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.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
  • Options
    mostafabalatmostafabalat Member, Microsoft Employee Posts: 5
    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.
  • Options
    lvanvugtlvanvugt Member Posts: 774
    Thanx, pal.
    Luc van Vugt, fluxxus.nl
    Never stop learning
    Van Vugt's dynamiXs
    Dutch Dynamics Community
Sign In or Register to comment.