Using smart filters on AX2012

(0) Share

Report

Posted on by Community Member

Hello,

Our company recently get AX2012. In this way, we are learning how to use it.

I am starting to get confident with some basic filters (*, !, ..) in a query. However, I would like to use some advanced filters (if they exist) using keywords such as "today", "today - 10 days...". I did not find any tips about that on google.

Does it exist ? Do you know where am I supposed to find this ?

I am interested in any kind of tutorial about that.

Thank you,

Kindest regards,

Jacks_FR

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Look at Technet: Advanced filtering and query options [AX 2012].

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

For Ranges use ".."

For example if you want to search from 1/1/2015 to 1/20/2015, write 1/1/2015..1/20/2015 in the filter.

What other queries you want to filter?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you, I do not manage to do (Week(0)) as I can do with (Day(0)).

Is it normal ? Are filters limited to those options ?

Was this reply helpful? Yes No
jmcpeek on at

Like (1)

Report

To use today it is just ">T","<T", "=T"

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

There is no week() method in SysQueryRangeUtil class. Consider using dayRange() instead or ask a developer to add methods you need.

Was this reply helpful? Yes No