---
title: "Microsoft Dynamics AX Filters: Tips and Tricks"
description: Do you use Dynamics AX filters every day in your operations? If so, here are some quick tips and tricks that can speed up your queries.
---
[](https://cfbs-us.com/)
- [Services](https://cfbs-us.com/services/)
- [Overview](https://cfbs-us.com/services/)
- [ERP Upgrades](https://cfbs-us.com/services/erp-upgrades/)
- [System Consolidation](https://cfbs-us.com/services/system-consolidation/)
- [Methodology](https://cfbs-us.com/services/methodology/)
- [Support & Training](https://cfbs-us.com/services/support-training/)
- [Mobile/Web Development](https://cfbs-us.com/services/mobile-web-development/)
- [Software](https://cfbs-us.com/software/)
- [Overview](https://cfbs-us.com/software/)
- [ProMRO](https://cfbs-us.com/software/promro/)
- [STS Aviation Case Study](https://cfbs-us.com/software/promro/#case-study)
- [Acumatica](https://cfbs-us.com/software/acumatica/)
- [Saddleback Leather Case Study](https://cfbs-us.com/software/acumatica/#case-study)
- [Odoo](https://cfbs-us.com/software/odoo/)
- [Dynamics 365 BC](https://cfbs-us.com/software/dynamics-365-bc/)
- [MemoParts Case Study](https://cfbs-us.com/software/dynamics-365-bc/#case-study)
- [Dynamics 365 F&O](https://cfbs-us.com/software/dynamics-365-fo/)
- [ISV Add-On Products](https://cfbs-us.com/software/isv-add-on-products/)
- [Industries](https://cfbs-us.com/industries/)
- [Overview](https://cfbs-us.com/industries/)
- [Job Shops](https://cfbs-us.com/industries/job-shops/)
- [Manufacturing](https://cfbs-us.com/industries/manufacturing/)
- [Make-to-Order](https://cfbs-us.com/industries/make-to-order/)
- [Maintenance, Repair & Overhaul](https://cfbs-us.com/industries/mro/)
- [Aviation](https://cfbs-us.com/industries/mro/aviation/)
- [Heavy Equipment](https://cfbs-us.com/industries/mro/heavy-equipment/)
- [Projects & Field Service](https://cfbs-us.com/industries/projects-field-service/)
- [Construction](https://cfbs-us.com/industries/construction/)
- [About](https://cfbs-us.com/about-us/)
- [Resources](https://cfbs-us.com/resources/)
- [Resource Library](https://cfbs-us.com/resources/)
- [Blog](https://blog.cfbs-us.com/erp-decision-resources)
- [Events](https://cfbs-us.com/events/)
- [Contact Us](https://cfbs-us.com/contact-us/)
- Services
- [Overview](https://cfbs-us.com/services/)
- [ERP Upgrades](https://cfbs-us.com/services/erp-upgrades/)
- [System Consolidation](https://cfbs-us.com/services/system-consolidation/)
- [Methodology](https://cfbs-us.com/services/methodology/)
- [Support & Training](https://cfbs-us.com/services/support-training/)
- [Mobile/Web Development](https://cfbs-us.com/services/mobile-web-development/)
- Software
- [Overview](https://cfbs-us.com/software/)
- [ProMRO](https://cfbs-us.com/software/promro/)
- [Acumatica](https://cfbs-us.com/software/acumatica/)
- [Odoo](https://cfbs-us.com/software/odoo/)
- [Dynamics 365 BC](https://cfbs-us.com/software/dynamics-365-bc/)
- [Dynamics 365 F&O](https://cfbs-us.com/software/dynamics-365-fo/)
- [ISV Add-On Products](https://cfbs-us.com/software/isv-add-on-products/)
- Industries
- [Overview](https://cfbs-us.com/industries/)
- [Job Shops](https://cfbs-us.com/industries/job-shops/)
- [Manufacturing](https://cfbs-us.com/industries/manufacturing/)
- [Maintenance, Repair & Overhaul](https://cfbs-us.com/industries/mro/)
- [Projects & Field Service](https://cfbs-us.com/industries/projects-field-service/)
- [Construction](https://cfbs-us.com/industries/construction/)
- [About](https://cfbs-us.com/about-us/)
- Resources
- [Resource Library](https://cfbs-us.com/resources/)
- [Blog](https://blog.cfbs-us.com/erp-decision-resources)
- [Events](https://cfbs-us.com/events/)
- [Let's Talk](https://cfbs-us.com/contact-us/)
Follow Us
-
-
-
-
-
# Microsoft Dynamics AX Filters: Tips and Tricks
08.01.23
## More about Microsoft Dynamics AX Filters
Do you use Dynamics AX filters every day in [your operations?](https://clientsfirst-tx.com/industries/?__hstc=4800236.5ef416d1ff18b4e3d2799893a2b676ad.1641953497195.1641953497195.1641953497195.1&__hssc=4800236.199.1641953497195&__hsfp=2406870324) If so, here are some quick tips and tricks that can speed up your queries.
### **i) Search for record ranges using open ended filters**
To search for a range of records in Dynamics AX, you can simply use “**..**”. However, you can go further and create a filter for everything before or after a certain value. To do this, simply skip either the beginning or end filter selection respectively.
For example, to see everything from a specific value, simply create a filter in this format “**value..**”. For example, **100000..** will show the values **beginning from** 100000.
On the other hand, to see everything up to a certain value, simply create the filter in this format “**..value**”. For example, **..100000** will show the values **up to** 100000.
### **ii) Create more intricate queries using filter by grid and wild cards**
It’s easy to search and filter records based on a field. However, to get the right data you want, you may have to combine some searches and filter your queries based on value and field format ranges. You may also have to filter the searches based on multiple fields at once. To ease your work, you can use the **Filter by Grid** feature. How do you do this?
On the list page, press **CTRL+G** or click on the **Filter by Grid** icon on the title bar to bring up the Filter by Grid feature. The feature is available on a row that appears on top of the list page. On the page, you can add the filters you want to any of the visible fields.
### **Using Wildcards**
To filter certain data from any field, simply add a **!** at the point where you want the filter to begin. This will mean that any value after the **!** is not wanted.
[](https://blog.cfbs-us.com/hubfs/Imported_Blog_Media/Depositphotos_37704563_s.jpg)
For fields with numeric values, the expressions \< and \> can be used to select all the data that is less than or greater than a certain value respectively.
You can use the "**,**"character to combine multiple filters, but not include any value in the middle. You can combine any number of queries within a field as you would like.
You can use the"**..**" expression in the middle of the low and high filters to select a group of records within a specific range. You can also wild card the low and high values.
If you are searching for records that all start, end of have the same characters somewhere within the file, you can use the **\*** qualifier to stipulate that any value before or after the point is valid.
If you want to select records that are of a specific length, you can use the "**?**" expression to stipulate that a character (though not defined) is required in that spot.
You can also create super filters by filtering multiple columns at once on the **Filter by Grid** option.
### **iii) Search for subsets of data within columns using filter by field**
Sometimes, you may want to search for all records that match a certain criteria within a list page. You can use the **Filter by Selection** feature if you want to search the whole value of a field. However, for more flexibility, you can search for subsets of data within the field. The best way of doing this is by using the **Filter by Field** feature.
To filter the data in a column on a list page, place your cursor in the field that you want to filter and press **CTRL+F**. Alternatively, right-click on the field that you want to filter and select the **Filter by Field** option in the submenu that appears.
When the Filter dialog box opens, type in the search expression that you want the data filtered based on and press the **Enter** key or click the **OK** button. The data will then be filtered based on the selection that you specified in your search.
The above are three quick tips that will help you do more with the [filters in Dynamics AX](http://dynamicsaxtipoftheday.com/2014/03/13/use-the-filter-by-field-to-search-for-subsets-of-data-within-columns/).
[](https://hubspot-cta-redirect-na2-prod.s3.amazonaws.com/cta/redirect/20974759/5b55aef0-802a-495b-9643-b87cf4681bcf)
- [ Share Article](mailto:?subject=Microsoft%20Dynamics%20AX%20Filters%3A%20Tips%20and%20Tricks&body=Check%20out%20this%20article:%20https%3A%2F%2Fblog.cfbs-us.com%2Fmicrosoft-dynamics%2Fmicrosoft-dynamics-ax-filters-tips-tricks)
- [ Back to Articles](https://blog.cfbs-us.com/microsoft-dynamics)
## Related Articles
07.31.23
### [Microsoft’s Bridge to The Cloud Promotio...](https://blog.cfbs-us.com/microsoft-dynamics/microsofts-bridge-to-the-cloud-promotion-for-dynamics-ax)
[Read Article](https://blog.cfbs-us.com/microsoft-dynamics/microsofts-bridge-to-the-cloud-promotion-for-dynamics-ax)
## Ready to take the next step?
[Free Consultation](https://cfbs-us.com/contact-us/)
Our team brings unmatched efficiency and value for a smooth implementation and beyond. Find out how we can help your business gain a competitive advantage in the marketplace.
[Free Consultation](https://cfbs-us.com/contact-us/)
-
-
-
-
-
- Services
- [Overview](https://cfbs-us.com/services/)
- [ERP Upgrades](https://cfbs-us.com/services/erp-upgrades/)
- [System Consolidation](https://cfbs-us.com/services/system-consolidation/)
- [Methodology](https://cfbs-us.com/services/methodology/)
- [Support & Training](https://cfbs-us.com/services/support-training/)
- [Mobile/Web Development](https://cfbs-us.com/services/mobile-web-development/)
- Software
- [Overview](https://cfbs-us.com/software/)
- [ProMRO](https://cfbs-us.com/software/promro/)
- [Acumatica](https://cfbs-us.com/software/acumatica/)
- [Dynamics 365 BC](https://cfbs-us.com/software/dynamics-365-bc/)
- [Dynamics 365 F&O](https://cfbs-us.com/software/dynamics-365-fo/)
- [ISV Add-On Products](https://cfbs-us.com/software/isv-add-on-products/)
- Industries
- [Overview](https://cfbs-us.com/industries/)
- [Job Shops](https://cfbs-us.com/industries/job-shops/)
- [Manufacturing](https://cfbs-us.com/industries/manufacturing/)
- [Maintenance, Repair & Overhaul](https://cfbs-us.com/industries/mro/)
- [Projects & Field Service](https://cfbs-us.com/industries/projects-field-service/)
- [Construction](https://cfbs-us.com/industries/construction/)
- Resources
- [Resource Library](https://cfbs-us.com/resources/)
- [Blog](https://blog.cfbs-us.com/acumatica-cloud-erp/)
- [Events](https://cfbs-us.com/events/)
- Contact
- [800.331.8382](tel:8003318382)
- [info@cfbs-us.com](mailto:info@cfbs-us.com)
© 2025 CFBS All Rights Reserved
```json
{
"@context" : "https://schema.org",
"@type" : "BlogPosting",
"author" : {
"@type" : "Person",
"name" : "Chandler Hutchison",
"url" : "https://blog.cfbs-us.com/microsoft-dynamics/author/chandler-hutchison"
},
"dateModified" : "2023-08-01T17:28:19.037Z",
"datePublished" : "2014-09-08T05:00:00.000Z",
"headline" : "Microsoft Dynamics AX Filters: Tips and Tricks",
"mainEntityOfPage" : {
"@id" : "https://blog.cfbs-us.com/microsoft-dynamics/microsoft-dynamics-ax-filters-tips-tricks",
"@type" : "WebPage"
},
"publisher" : {
"@type" : "Organization",
"logo" : {
"@type" : "ImageObject",
"url" : "https://blog.cfbs-us.com/hubfs/cfbs-full-logo-tm.svg"
},
"name" : "Clients First Business Solutions"
}
}
```