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.

image001
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

image003
monthRange (monthRange(-1,0)) last month and this month image005
yearRange (yearRange(-1,0)) last year and this year image007
lessThanDate

 

lessThanUtcDate

lessThanUtcNow

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

 

(lessThanUtcDate(-1)

The date represented on the AOS

(lessthanUtcNow())

Calculates from “Now”

image009
greaterThanDate

 

GreaterThanUtcDate

greaterThanUtcNow

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

 

(greaterThanUtcDate(-1)

The date represented on the AOS)

(greaterthanUtcNow())

Calculates from “Now”

image011
currentUserId (currentuserid())

 

Take the user id and filter on for example “created by”

Good for making a generic query relevant for the individual users, forexample a Cue along the lines of "Sales orders I have created"

image013
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

For example for a cue along the lines of "Sales orders I am responsible for"

image015
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.

image017
currentCompany (currentcompany())

 

For filtering on “system” tables such as the worker table

image019

 

創作者介紹
創作者 lionlionchopper 的頭像
lionlionchopper

呆子獅的夢想世界

lionlionchopper 發表在 痞客邦 留言(0) 人氣()