Whenever I setup Cues for customers in AX 2012 I use dynamic filtering to create actionable cues representing relevant data. I do tend to forget the precise name of the methods and number of parenthesis etc. so here is the full list of end-user available methods based on the SysQueryRangeUtil class:

 

Name

Used how

Example

dayRange

(dayRange(-1,2)) gives a query result of all records from yesterday until the day after tomorrow.

Note that it is unfortunately not possible to use decimals, only full days work.

Image 001

day

(day(-1)) gives all records of yesterday, (day(1)) gives records of tomorrow.

Remember that options such as <(day(-1)) works for identifying for example any date before yesterday

Image 003

monthRange

(monthRange(-1,0)) last month and this month

Image 005

yearRange

(yearRange(-1,0)) last year and this year

Image 007

lessThanDate

lessThanUtcDate

lessThanUtcNow

(lessThanDate(-1)) (calculated from the AX session date)

(lessThanUtcDate(-1)

The date represented on the AOS

(lessthanUtcNow())

Calculates from "Now"

Notice this one uses < (less than) meaning that it looks at dates smaller than the number indicates. A value of (lessthandate(1)) is actually "less than tomorrow" ie. all dates from today and backwards

Image 009

greaterThanDate

GreaterThanUtcDate

greaterThanUtcNow

greaterThanDate(5)) (calculated from the AX session date)

(greaterThanUtcDate(-1)

The date represented on the AOS)

(greaterthanUtcNow())

Calculates from "Now"

Image 011

currentUserId

(currentuserid())

Take the user id and filter on for example "created by"

Good for making a generic query relevant for many users

Image 013

currentWorker

(currentWorker())

 

A somewhat advanced option but nice for filtering on records where you have assigned for example a sales responsible.

Note that the value returned is a record ID

Image 015

currentParty

(currentparty())

 

Similar to the currentWorker but could potentially be used if the user was something other than a Worker.

Note the returned value is a record id.

Image 017

currentCompany

(currentcompany())

For filtering on "system" tables such as the worker table

Image 019

 

Remember also the ability to compare two fields on the same table using the AOT names within a set of parenthesis. The system names can be found on the personalization screen:

 

Image 021

 

  by: David Probst, Senior AX consultant