{"id":190,"date":"2013-08-07T10:21:11","date_gmt":"2013-08-07T04:51:11","guid":{"rendered":"https:\/\/www.dhruvsoft.com\/blog\/?p=190"},"modified":"2025-06-09T12:25:25","modified_gmt":"2025-06-09T06:55:25","slug":"salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean","status":"publish","type":"post","link":"https:\/\/www.dhruvsoft.com\/blog\/salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean\/","title":{"rendered":"Salesforce.com Tip of the Day &#8211; Advanced Search &#8211; Using Wildcards and Boolean"},"content":{"rendered":"<p>Our Salesforce.com Tip of the Day is on Advanced Search &#8211; Using Wildcards and Boolean when using Global Search. We have already covered basics of Search in Salesforce.com in a previous Salesforce.com tip posted earlier:<\/p>\n<p><a href=\"https:\/\/www.dhruvsoft.com\/blog\/salesforce-tip-of-the-day-using-global-search\/\" target=\"_blank\" rel=\"noopener\">How to use Global Search in Salesforce.com<\/a><\/p>\n<p>In this article we will explore the advanced search.<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_83 ez-toc-wrap-left-text counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.dhruvsoft.com\/blog\/salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean\/#1_Using_Wildcard_Character_-A_asterisk\" >(1) Using Wildcard Character -\u00c2\u00a0asterisk (*)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.dhruvsoft.com\/blog\/salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean\/#2_Asterisks_can_only_be_used_at_the_end_or_in_the_middle_not_at_the_beginning\" >(2) Asterisks can only be used at the end or in the middle (not at the beginning)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.dhruvsoft.com\/blog\/salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean\/#3_Apart_from_Asterisk_you_need_to_enter_two_or_moreA_characters\" >(3) Apart from Asterisk you need to enter two or more\u00c2\u00a0characters<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-5'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.dhruvsoft.com\/blog\/salesforce-com-tip-of-the-day-advanced-search-using-wildcards-and-boolean\/#4_Using_Boolean_Operators\" >(4) Using Boolean Operators<\/a><\/li><\/ul><\/nav><\/div>\n<h5><span class=\"ez-toc-section\" id=\"1_Using_Wildcard_Character_-A_asterisk\"><\/span>(1) Using Wildcard Character -\u00c2\u00a0asterisk (*)<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>To conduct a partial word search, you can type an asterisk (*) wildcard at the end (or in the middle) of your search term, or choose the auto-complete option with an asterisk from the search box drop-down list.<\/p>\n<p><a href=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-191\" src=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars.png\" alt=\"Using wildcard chars\" width=\"249\" height=\"602\" srcset=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars.png 249w, https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-124x300.png 124w\" sizes=\"auto, (max-width: 249px) 100vw, 249px\" \/><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"2_Asterisks_can_only_be_used_at_the_end_or_in_the_middle_not_at_the_beginning\"><\/span>(2) Asterisks can only be used at the end or in the middle (not at the beginning)<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-193\" src=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-3.png\" alt=\"Wildcard at the start will not work\" width=\"448\" height=\"254\" srcset=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-3.png 448w, https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-3-300x170.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>Asterisks match zero or more characters at the middle or end (not the beginning) of\u00c2\u00a0your search term. For example, a search for jon* finds items that start with jon,\u00c2\u00a0such as, jone, jones, or Jonas. A search for &#8220;Jo* Lim&#8221; finds items with Jonas\u00c2\u00a0Lim or John Lim.<\/p>\n<p><a href=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-192\" src=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Using-wildcard-chars-2.png\" alt=\"Using wildcard chars in the middle\" width=\"277\" height=\"187\" \/><\/a><\/p>\n<h5><span class=\"ez-toc-section\" id=\"3_Apart_from_Asterisk_you_need_to_enter_two_or_moreA_characters\"><\/span>(3) Apart from Asterisk you need to enter two or more\u00c2\u00a0characters<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>Your search term must have two or more characters. The special characters, such as * aren&#8217;t included in the character count.<\/p>\n<h5><span class=\"ez-toc-section\" id=\"4_Using_Boolean_Operators\"><\/span>(4) Using Boolean Operators<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>You can refine your search using operators such as AND, OR, and AND NOT.\u00c2\u00a0You can use any combination of AND, OR and AND NOT in your search term:<\/p>\n<p><a href=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Boolean.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-194\" src=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Boolean.png\" alt=\"Boolean\" width=\"555\" height=\"199\" srcset=\"https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Boolean.png 555w, https:\/\/www.dhruvsoft.com\/blog\/wp-content\/uploads\/2013\/08\/Boolean-300x107.png 300w\" sizes=\"auto, (max-width: 555px) 100vw, 555px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li><strong>OR &#8211;<\/strong> To get results where ANY ONE of your terms will appear in the record. For example, John OR Jone will give results on all the records where either John or Jones is appearing.<\/li>\n<li><strong>AND &#8211;<\/strong>\u00c2\u00a0\u00c2\u00a0To get results where ALL of your terms will appear in the record. For example, John AND Jone will give results on all the records where both John and Jones are appearing together.<\/li>\n<li><strong>AND NOT -\u00c2\u00a0<\/strong>To get results where one of your terms is excluded in the record. For example, John AND NOT Jone will give results on all the records where John is appearing and both John and Jones are NOT appearing together.<\/li>\n<\/ul>\n<p>There is more about search that we will be learning later. For now, play with Boolean and Wildcards when doing your next search in Salesforce.com<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Our Salesforce.com Tip of the Day is on Advanced Search &#8211; Using Wildcards and Boolean when using Global Search. We have already covered basics of Search in Salesforce.com in a previous Salesforce.com tip posted earlier: How to use Global Search in Salesforce.com In this article we will explore the advanced search.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[71,70],"class_list":["post-190","post","type-post","status-publish","format-standard","hentry","category-salesforce-tip-of-the-day","tag-salesforce-search-wildcards","tag-salesforce-com-global-search","entry"],"_links":{"self":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/190","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/comments?post=190"}],"version-history":[{"count":0,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dhruvsoft.com\/blog\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}