How to Not Find Something in Dynamics AX

How to not find something in Dynamics AX

How to not find something in Dynamics AX

The filtering within Dynamics AX is great and it’s easy to use to find just the records that you are interested in.  But what if you want to filter particular pieces of information out of the query rather than search for particular information.

You can easily do this with the special filter operator “!” (also known as Not) – all you have to do is put this in front of the values that you don’t want to return and those records will be filtered out for you.

HOW TO DO IT

Open up the form that you want to filter out and open up the filter grid (CTRL+G)

20131120.1

In the filter box, just type in the value that you want to filter out, but add a “!” in the front of it.  In this example we used !”” (note the double quotes) to say that we don’t want any records that are blank.

20131120.2

Also, you can apply multiple filters by separating them with commas.  For example: !””,!TN,!CA

20131120.3

PS

Thanks so much Tommy Skaue (@skaue) and Joris de Gruyter (@jorisdg) for teaching me this tip.

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: