AX Technical Tip#4: Filter Data by Individual or Multiple Fields

April 5, 2011

Microsoft Dynamics AX gives users the power to filter data by individual or multiple fields.  To filter by a single field, right click in the field and select “Filter by field.”  To filter by a group of fields, Press CTRL + G and enter multiple criteria.

With Microsoft Dynamics AX, users have the ability to filter by numbers, words and/or dates. For example:

1..10 finds all the values from 1 through 10

1/1/2009..12/31/2009 finds all dates between 1/1/09 and 12/31/09

!Smith finds all except “Smith”

..1000 finds any number less than or equal to 1000

1000.. finds any number greater than or equal to 1000

<1000 finds any number less than 1000

>1000 finds any number greater than 1000

A,D finds “A” and “D”.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: