{"id":33533,"date":"2022-12-28T15:55:40","date_gmt":"2022-12-28T10:25:40","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33533"},"modified":"2023-01-02T12:18:00","modified_gmt":"2023-01-02T06:48:00","slug":"how-to-apply-filters-on-multi-choices-columns-in-dynamics-365-ce","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/12\/how-to-apply-filters-on-multi-choices-columns-in-dynamics-365-ce\/","title":{"rendered":"How to apply filters on Multi Choices Columns in Dynamics 365 CE"},"content":{"rendered":"

Filtering the table records for the Multi Choice fields\/columns<\/strong> is easier if only one option is selected and can be done using the \u201cEqual & Does not equal<\/strong>\u201d filters present. But while filtering the data when more than one option is selected, the \u201cEqual & Does not equal<\/strong>\u201d filter doesn\u2019t work as required so, in that case, we have filters called \u201cContains values and Does not contain values<\/strong>\u201d that give you an expected output.<\/p>\n

So let\u2019s explore how it works!<\/p>\n

Let’s say I have a Multi choices column called Hobbies<\/strong> and below are a few Account<\/strong> records on which I have set the data in the Hobbies<\/strong> field:<\/p>\n

\"Dynamics<\/p>\n

Here if I want to see the Account<\/strong> records where only the \u201cReading Books<\/strong>\u201d option is selected then I can use the \u201cEqual<\/strong>\u201d filter.<\/p>\n

As you can see below, after applying an Equal<\/strong> filter it only shows the Account<\/strong> record where only the \u201cReading Books<\/strong>\u201d option is selected in the \u201cHobbies<\/strong>\u201d column.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

But if I also want to see the Account<\/strong> records where multiple options are selected and the \u201cReading Books<\/strong>\u201d option is one of the selected options among them then I can use the \u201cContains values<\/strong>\u201d filter.<\/p>\n

As visible below, after applying the \u201cContains values<\/strong>\u201d filter it shows account records where only the \u201cReading Books<\/strong>\u201d option is selected and also shows records where the \u201cReading Books<\/strong>\u201d option is selected along with other hobbies options.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Similarly, if I want to see all the account records except records where only one option is selected as \u201cReading Books<\/strong>\u201d then I can use the \u201cDoes not Equal<\/strong>\u201d filter.<\/p>\n

As seen below, after applying the \u201cDoes not equal\u201d<\/strong> filter it shows all the account records (including records where multiple options are selected including the \u201cReading Books<\/strong>\u201d option) except the account where \u201cReading Books<\/strong>\u201d is the only option selected in the \u201cHobbies<\/strong>\u201d column.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

But if I also don\u2019t want to see the Account<\/strong> records where multiple options are selected and the \u201cReading Books<\/strong>\u201d option is one of the selected options among them then I can use the \u201cDoes not contains values\u201d<\/strong> filter.<\/p>\n

As seen in the below screenshot, after applying the \u201cDoes not contain values\u201d <\/strong>filter it shows all the account records except the account where \u201cReading Books<\/strong>\u201d is the only option selected in the \u201cHobbies<\/strong>\u201d column or accounts where the \u201cReading Books<\/strong>\u201d option is selected along with other hobbies options.<\/p>\n

\"Dynamics<\/p>\n

\"Dynamics<\/p>\n

Conclusion<\/strong><\/h2>\n

\u2018Contains values\u2019<\/strong> and \u2018Does not contain values\u2019<\/strong> filters make the user experience easier and more engaging while working on filtering the data in Multi Choices Columns.<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Filtering the table records for the Multi Choice fields\/columns is easier if only one option is selected and can be done using the \u201cEqual & Does not equal\u201d filters present. But while filtering the data when more than one option is selected, the \u201cEqual & Does not equal\u201d filter doesn\u2019t work as required so, in\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[12,16,18,2361],"tags":[2185],"class_list":["post-33533","post","type-post","status-publish","format-standard","hentry","category-customer-service","category-dynamics-365","category-dynamics-365-v9-2","category-technical","tag-dynamics-365-ce"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33533","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33533"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33533\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33533"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33533"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33533"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}