{"id":105553,"date":"2025-08-14T14:09:46","date_gmt":"2025-08-14T18:09:46","guid":{"rendered":"https:\/\/sisn.com\/microsoft-dynamics-365-advanced-filtering\/"},"modified":"2025-08-14T14:46:46","modified_gmt":"2025-08-14T18:46:46","slug":"microsoft-dynamics-365-advanced-filtering","status":"publish","type":"post","link":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/","title":{"rendered":"Microsoft Dynamics 365 Advanced Filtering"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"105553\" class=\"elementor elementor-105553 elementor-105501\" data-elementor-post-type=\"post\">\n\t\t\t\t<div class=\"elementor-element elementor-element-135160f e-flex e-con-boxed e-con e-parent\" data-id=\"135160f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-1760de1 elementor-widget elementor-widget-text-editor\" data-id=\"1760de1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Advanced filtering is one of the most powerful \u2014 yet often underutilised \u2014 tools in Microsoft D365. Advanced Filtering can turn hours of manual searching into seconds, giving you powerful, precise control over your data \u2014 if you know how to use it. <\/p><p>It allows you to build advanced queries across multiple tables and related data. With it, you can apply precise, multi-condition searches and gain far greater control over sorting and filtering than standard filters provide. <\/p><p>This feature is available in almost every form that contains a table and is easy to access directly from the Action Pane.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1bb3861 e-flex e-con-boxed e-con e-parent\" data-id=\"1bb3861\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-f8ab5e5 e-con-full e-flex e-con e-child\" data-id=\"f8ab5e5\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-e9809a1 e-con-full e-flex e-con e-child\" data-id=\"e9809a1\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-20040de elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"20040de\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"microsoft dynamics 365 advanced filtering\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTA1NTA2LCJ1cmwiOiJodHRwczpcL1wvc2lzbi5jb21cL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjVcLzA4XC9taWNyb3NvZnQtZHluYW1pY3MtMzY1LWFkdmFuY2VkLWZpbHRlcmluZy0xLmpwZyJ9\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" width=\"1522\" height=\"496\" src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1.jpg\" class=\"attachment-full size-full wp-image-105506\" alt=\"microsoft dynamics 365 advanced filtering\" srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1.jpg 1522w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1-300x98.jpg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1-1024x334.jpg 1024w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-1-768x250.jpg 768w\" sizes=\"(max-width: 1522px) 100vw, 1522px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-13add60 e-con-full e-flex e-con e-child\" data-id=\"13add60\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-8b0c7ad e-flex e-con-boxed e-con e-parent\" data-id=\"8b0c7ad\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3ae88b6 elementor-widget elementor-widget-text-editor\" data-id=\"3ae88b6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>What You Can Do with Advanced Filtering<\/strong><br>You can use advanced filtering to:<br>\u2022 Filter across related tables (e.g., filter sales orders by customer group)<br>\u2022 Use ranges, wildcards, or custom expressions<br>\u2022 Sort by one or more fields<br>\u2022 Build reusable views for complex scenarios<br>\u2022 And more<\/p><p><strong>How the Advanced Filter Form Works<\/strong><br>The advanced filter form uses the following columns to search, sort, and cross-reference:<br>\u2022 Table \u2013 The main data table of the current page<br>\u2022 Field \u2013 Select from current and related tables<br>\u2022 Criteria \u2013 Input filter conditions (e.g., date ranges, text, wildcards)<br>\u2022 Sorting \u2013 Add sort fields (ascending or descending)<br>\u2022 Joins \u2013 Add related tables via Add Table to access more fields<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3c8d4ba e-flex e-con-boxed e-con e-parent\" data-id=\"3c8d4ba\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-58b4d88 e-con-full e-flex e-con e-child\" data-id=\"58b4d88\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-65579a0 e-con-full e-flex e-con e-child\" data-id=\"65579a0\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-7180ec7 elementor-widget elementor-widget-image\" data-id=\"7180ec7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"microsoft dynamics 365 advanced filtering projects\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTA1NTE0LCJ1cmwiOiJodHRwczpcL1wvc2lzbi5jb21cL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjVcLzA4XC9taWNyb3NvZnQtZHluYW1pY3MtMzY1LWFkdmFuY2VkLWZpbHRlcmluZy1wcm9qZWN0cy5qcGcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img width=\"2058\" height=\"665\" src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects.jpg\" class=\"attachment-full size-full wp-image-105514\" alt=\"microsoft dynamics 365 advanced filtering projects\" srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects.jpg 2058w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects-300x97.jpg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects-1024x331.jpg 1024w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects-768x248.jpg 768w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects-1536x496.jpg 1536w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-projects-2048x662.jpg 2048w\" sizes=\"(max-width: 2058px) 100vw, 2058px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3d0f500 e-con-full e-flex e-con e-child\" data-id=\"3d0f500\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-d7a0078 e-flex e-con-boxed e-con e-parent\" data-id=\"d7a0078\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-8dc0aca elementor-widget elementor-widget-text-editor\" data-id=\"8dc0aca\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>The <strong>Criteria<\/strong> column supports many syntaxes, including but not limited to:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-79cbd7f e-flex e-con-boxed e-con e-parent\" data-id=\"79cbd7f\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-738afee elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"738afee\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-criteria.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"microsoft dynamics 365 advanced filtering criteria\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTA1NTE5LCJ1cmwiOiJodHRwczpcL1wvc2lzbi5jb21cL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjVcLzA4XC9taWNyb3NvZnQtZHluYW1pY3MtMzY1LWFkdmFuY2VkLWZpbHRlcmluZy1jcml0ZXJpYS5qcGcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img width=\"741\" height=\"506\" src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-criteria.jpg\" class=\"attachment-medium_large size-medium_large wp-image-105519\" alt=\"microsoft dynamics 365 advanced filtering criteria\" srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-criteria.jpg 741w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-criteria-300x205.jpg 300w\" sizes=\"(max-width: 741px) 100vw, 741px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-0d4afbb e-flex e-con-boxed e-con e-parent\" data-id=\"0d4afbb\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-70e2d6d elementor-widget elementor-widget-text-editor\" data-id=\"70e2d6d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3><strong>Use Case Scenario<\/strong><\/h3><p>Here are a few simple yet powerful examples of how to use advanced filtering. Once you get familiar with the basics and learn some tips and tricks, you can master more complex scenarios. <\/p><p><strong>Example 1:<\/strong> Add the Project Group table, cross-reference it with On-account Invoicing, and search by Customer Invoice.<\/p><p><strong>Example 2:<\/strong> Use the search criteria below to identify budget overruns before the month-end close:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-f1d0499 e-flex e-con-boxed e-con e-parent\" data-id=\"f1d0499\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-caf5db9 e-con-full e-flex e-con e-child\" data-id=\"caf5db9\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-77e9069 e-con-full e-flex e-con e-child\" data-id=\"77e9069\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ab6dcb4 elementor-widget__width-initial elementor-widget elementor-widget-image\" data-id=\"ab6dcb4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-use-cases.jpg\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"microsoft dynamics 365 advanced filtering use cases\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MTA1NTI3LCJ1cmwiOiJodHRwczpcL1wvc2lzbi5jb21cL3dwLWNvbnRlbnRcL3VwbG9hZHNcLzIwMjVcLzA4XC9taWNyb3NvZnQtZHluYW1pY3MtMzY1LWFkdmFuY2VkLWZpbHRlcmluZy11c2UtY2FzZXMuanBnIn0%3D\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" width=\"906\" height=\"370\" src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-use-cases.jpg\" class=\"attachment-full size-full wp-image-105527\" alt=\"microsoft dynamics 365 advanced filtering use cases\" srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-use-cases.jpg 906w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-use-cases-300x123.jpg 300w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/microsoft-dynamics-365-advanced-filtering-use-cases-768x314.jpg 768w\" sizes=\"(max-width: 906px) 100vw, 906px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-daf06cc e-con-full e-flex e-con e-child\" data-id=\"daf06cc\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-76c060e e-flex e-con-boxed e-con e-parent\" data-id=\"76c060e\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-a1a1196 elementor-widget elementor-widget-text-editor\" data-id=\"a1a1196\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<h3>Summary:<\/h3><p>Advanced Filtering in Microsoft Dynamics 365 lets you handle complex business queries in seconds. You can access deeper filtering options across related data entities, combine sorting and filtering in a single step, and create reusable, personalised workspaces tailored to your needs. <\/p><p>By taking full advantage of Advanced Filtering, you can unlock the true potential of your D365 data. Whether you\u2019re troubleshooting issues, tracking KPIs, or uncovering insights across multiple tables, this tool empowers you to work smarter, not harder. Investing a little time to master its capabilities will pay off in faster decision-making, more accurate reporting, and a clearer view of your business\u2014right at your fingertips.  <\/p><p><em><strong>Unlock the full power of Advanced Filtering\u2014<a href=\"https:\/\/sisn.com\/en-gb\/contact-sis\/\">contact SIS today<\/a> and start working smarter in Microsoft Dynamics 365.<\/strong><\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-c535230 e-flex e-con-boxed e-con e-parent\" data-id=\"c535230\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-d1c3e37 e-con-full e-flex e-con e-child\" data-id=\"d1c3e37\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d181dd1 elementor-widget elementor-widget-image\" data-id=\"d181dd1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img loading=\"lazy\" width=\"200\" height=\"200\" src=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/thumbnail_Mani-Alizadeh.jpg\" class=\"attachment-medium size-medium wp-image-105535\" alt=\"Mani Alizadeh headshot\" srcset=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/thumbnail_Mani-Alizadeh.jpg 200w, https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/thumbnail_Mani-Alizadeh-150x150.jpg 150w\" sizes=\"(max-width: 200px) 100vw, 200px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-be1d655 e-con-full e-flex e-con e-child\" data-id=\"be1d655\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4481c05 e-con-full e-flex e-con e-child\" data-id=\"4481c05\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-aa12b0a elementor-widget elementor-widget-text-editor\" data-id=\"aa12b0a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>By Mani Alizadeh<\/strong><\/p><p><strong>SIS Consultant ConsOps<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3f20698 e-con-full e-flex e-con e-child\" data-id=\"3f20698\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Advanced filtering is one of the most powerful \u2014 yet often underutilised \u2014 tools in Microsoft D365. Advanced Filtering can turn hours of manual searching into seconds, giving you powerful, precise control over your data \u2014 if you know how to use it. It allows you to build advanced queries across multiple tables and related&hellip;<\/p>\n","protected":false},"author":9,"featured_media":105540,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[380,384],"tags":[],"class_list":["post-105553","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog-en-gb","category-d365-en-gb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v26.5 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Microsoft Dynamics 365 Advanced Filtering | Construction ERP<\/title>\n<meta name=\"description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Dynamics 365 Advanced Filtering\" \/>\n<meta property=\"og:description\" content=\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/\" \/>\n<meta property=\"og:site_name\" content=\"Construction ERP\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-14T18:09:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-14T18:46:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1707\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"eric\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"eric\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/\"},\"author\":{\"name\":\"eric\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/person\\\/6668843491d7b20969cafcb68760da61\"},\"headline\":\"Microsoft Dynamics 365 Advanced Filtering\",\"datePublished\":\"2025-08-14T18:09:46+00:00\",\"dateModified\":\"2025-08-14T18:46:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/\"},\"wordCount\":416,\"publisher\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/AdobeStock_613103102-scaled.jpeg\",\"articleSection\":[\"Blog\",\"D365\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/\",\"name\":\"Microsoft Dynamics 365 Advanced Filtering | Construction ERP\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/AdobeStock_613103102-scaled.jpeg\",\"datePublished\":\"2025-08-14T18:09:46+00:00\",\"dateModified\":\"2025-08-14T18:46:46+00:00\",\"description\":\"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/AdobeStock_613103102-scaled.jpeg\",\"contentUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/08\\\/AdobeStock_613103102-scaled.jpeg\",\"width\":2560,\"height\":1707,\"caption\":\"Data science and big data technology. Data scientist computing, analysing and visualizing complex data stream on computer. Data mining, artificial intelligence, machine learning, business analytics.\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/microsoft-dynamics-365-advanced-filtering\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sisn.com\\\/en-gb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Dynamics 365 Advanced Filtering\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#website\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"name\":\"Construction ERP with Microsoft & SIS\",\"description\":\"End-to-end project accounting built on Microsoft Dynamics 365\",\"publisher\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\"},\"alternateName\":\"SIS\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/sisn.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#organization\",\"name\":\"SIS\",\"url\":\"https:\\\/\\\/sisn.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"contentUrl\":\"https:\\\/\\\/sisn.com\\\/wp-content\\\/uploads\\\/2025\\\/01\\\/500x500-sis-white-background-and-border-1.jpg\",\"width\":500,\"height\":500,\"caption\":\"SIS\"},\"image\":{\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/company\\\/793109\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/sisn.com\\\/#\\\/schema\\\/person\\\/6668843491d7b20969cafcb68760da61\",\"name\":\"eric\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g\",\"caption\":\"eric\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Microsoft Dynamics 365 Advanced Filtering | Construction ERP","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/","og_locale":"en_GB","og_type":"article","og_title":"Microsoft Dynamics 365 Advanced Filtering","og_description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","og_url":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/","og_site_name":"Construction ERP","article_published_time":"2025-08-14T18:09:46+00:00","article_modified_time":"2025-08-14T18:46:46+00:00","og_image":[{"width":2560,"height":1707,"url":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg","type":"image\/jpeg"}],"author":"eric","twitter_card":"summary_large_image","twitter_misc":{"Written by":"eric","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#article","isPartOf":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/"},"author":{"name":"eric","@id":"https:\/\/sisn.com\/#\/schema\/person\/6668843491d7b20969cafcb68760da61"},"headline":"Microsoft Dynamics 365 Advanced Filtering","datePublished":"2025-08-14T18:09:46+00:00","dateModified":"2025-08-14T18:46:46+00:00","mainEntityOfPage":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/"},"wordCount":416,"publisher":{"@id":"https:\/\/sisn.com\/#organization"},"image":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#primaryimage"},"thumbnailUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg","articleSection":["Blog","D365"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/","url":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/","name":"Microsoft Dynamics 365 Advanced Filtering | Construction ERP","isPartOf":{"@id":"https:\/\/sisn.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#primaryimage"},"image":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#primaryimage"},"thumbnailUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg","datePublished":"2025-08-14T18:09:46+00:00","dateModified":"2025-08-14T18:46:46+00:00","description":"SIS is the leading provider of Microsoft Dynamics 365 Enterprise Resource Planning (ERP), Project Management, and accounting solutions for contractors and professional service companies.","breadcrumb":{"@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#primaryimage","url":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg","contentUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/08\/AdobeStock_613103102-scaled.jpeg","width":2560,"height":1707,"caption":"Data science and big data technology. Data scientist computing, analysing and visualizing complex data stream on computer. Data mining, artificial intelligence, machine learning, business analytics."},{"@type":"BreadcrumbList","@id":"https:\/\/sisn.com\/en-gb\/microsoft-dynamics-365-advanced-filtering\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sisn.com\/en-gb\/"},{"@type":"ListItem","position":2,"name":"Microsoft Dynamics 365 Advanced Filtering"}]},{"@type":"WebSite","@id":"https:\/\/sisn.com\/#website","url":"https:\/\/sisn.com\/","name":"Construction ERP with Microsoft & SIS","description":"End-to-end project accounting built on Microsoft Dynamics 365","publisher":{"@id":"https:\/\/sisn.com\/#organization"},"alternateName":"SIS","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sisn.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/sisn.com\/#organization","name":"SIS","url":"https:\/\/sisn.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/","url":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","contentUrl":"https:\/\/sisn.com\/wp-content\/uploads\/2025\/01\/500x500-sis-white-background-and-border-1.jpg","width":500,"height":500,"caption":"SIS"},"image":{"@id":"https:\/\/sisn.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.linkedin.com\/company\/793109"]},{"@type":"Person","@id":"https:\/\/sisn.com\/#\/schema\/person\/6668843491d7b20969cafcb68760da61","name":"eric","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/secure.gravatar.com\/avatar\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8a8f8c0eb32f1c38efd0a87336ad390d81782fd01d7b593ff9e0fb33d7154360?s=96&d=mm&r=g","caption":"eric"}}]}},"_links":{"self":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/105553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/comments?post=105553"}],"version-history":[{"count":3,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/105553\/revisions"}],"predecessor-version":[{"id":105556,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/posts\/105553\/revisions\/105556"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/media\/105540"}],"wp:attachment":[{"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/media?parent=105553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/categories?post=105553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sisn.com\/en-gb\/wp-json\/wp\/v2\/tags?post=105553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}