{"id":487,"date":"2019-09-04T14:36:44","date_gmt":"2019-09-04T06:36:44","guid":{"rendered":"http:\/\/www.yohz.com\/blogs\/?p=487"},"modified":"2019-09-05T10:18:43","modified_gmt":"2019-09-05T02:18:43","slug":"searching-for-word-and-excel-documents-by-author-and-other-extended-attributes","status":"publish","type":"post","link":"https:\/\/www.yohz.com\/blogs\/2019\/09\/04\/searching-for-word-and-excel-documents-by-author-and-other-extended-attributes\/","title":{"rendered":"Searching for Word and Excel documents by extended attributes"},"content":{"rendered":"<p>In <a href=\"https:\/\/yohzapps.yohz.com\/\">Easy Explorer<\/a>, you can use the advanced search function to search for Word, Excel, or other Microsoft Office documents using its extended attributes values like author, subject, comments, etc.<\/p>\n<p>In Windows Explorer, you can display those attributes by adding the columns e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-488\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office01.png\" alt=\"\" width=\"897\" height=\"377\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office01.png 897w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office01-300x126.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office01-768x323.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office01-624x262.png 624w\" sizes=\"(max-width: 897px) 100vw, 897px\" \/><\/p>\n<p>You can display the same attributes in Easy Explorer i.e.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-489\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office02.png\" alt=\"\" width=\"884\" height=\"411\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office02.png 884w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office02-300x139.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office02-768x357.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office02-624x290.png 624w\" sizes=\"(max-width: 884px) 100vw, 884px\" \/><\/p>\n<p>To search on the extended attributes, click on the <strong>Advanced Search<\/strong> button in Easy Explorer:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-453\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/08\/ee_advsearch01.png\" alt=\"\" width=\"441\" height=\"85\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/08\/ee_advsearch01.png 441w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/08\/ee_advsearch01-300x58.png 300w\" sizes=\"(max-width: 441px) 100vw, 441px\" \/><\/p>\n<p>In the search window, enter the attributes you want to search on.\u00a0 Let&#8217;s start off with something simple &#8211; we want to search for documents whose author is &#8216;Hank Jareau&#8217;.\u00a0 We enter our search condition like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-490\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office03.png\" alt=\"\" width=\"656\" height=\"151\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office03.png 656w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office03-300x69.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office03-624x144.png 624w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>and Easy Explorer will list all documents whose author is &#8216;Hank Jareau&#8217;.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-497\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office04a.png\" alt=\"\" width=\"735\" height=\"153\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office04a.png 735w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office04a-300x62.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office04a-624x130.png 624w\" sizes=\"(max-width: 735px) 100vw, 735px\" \/><\/p>\n<p>However, Easy Explorer will not display documents where &#8216;Hank Jareau&#8217; is a co-author.\u00a0 To include those documents in our search, we use the <strong>TextContains<\/strong> function to look for documents where the <strong>Authors<\/strong> attribute contains &#8216;Hank Jareau&#8217; i.e.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-492\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office05.png\" alt=\"\" width=\"656\" height=\"155\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office05.png 656w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office05-300x71.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office05-624x147.png 624w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>and our search results will be as follows:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-496\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07a.png\" alt=\"\" width=\"850\" height=\"180\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07a.png 850w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07a-300x64.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07a-768x163.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07a-624x132.png 624w\" sizes=\"(max-width: 850px) 100vw, 850px\" \/><\/p>\n<p>Now say we want to search for all documents where the Comments attribute is &#8216;Call for interview&#8217; or &#8216;Consider&#8217;.\u00a0 We do this by using the <strong>OR<\/strong> function to add multiple search conditions e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-494\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07.png\" alt=\"\" width=\"656\" height=\"152\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07.png 656w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07-300x70.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office07-624x145.png 624w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>and our results:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-495\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office08.png\" alt=\"\" width=\"814\" height=\"189\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office08.png 814w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office08-300x70.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office08-768x178.png 768w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office08-624x145.png 624w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/p>\n<p>You can add as many such conditions as you require, using a combination of the <strong>AND <\/strong>and\u00a0<strong>OR <\/strong>functions e.g.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-498\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office09.png\" alt=\"\" width=\"656\" height=\"158\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office09.png 656w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office09-300x72.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_office09-624x150.png 624w\" sizes=\"(max-width: 656px) 100vw, 656px\" \/><\/p>\n<p>You can see that the advanced search function gives you unparalleled flexibility in searching for documents based off the extended attributes.\u00a0 Note that Easy Explorer allows you to search across different folders, not just in a single folder.<\/p>\n<p>Just select the folders you want to search in:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-480\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif10a.png\" alt=\"\" width=\"736\" height=\"427\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif10a.png 736w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif10a-300x174.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif10a-624x362.png 624w\" sizes=\"(max-width: 736px) 100vw, 736px\" \/><\/p>\n<p>start the <strong>Advanced Search<\/strong>, and the search condition will be applied to each of the selected folders.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-484\" src=\"http:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif11a.png\" alt=\"\" width=\"659\" height=\"360\" srcset=\"https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif11a.png 659w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif11a-300x164.png 300w, https:\/\/www.yohz.com\/blogs\/wp-content\/uploads\/2019\/09\/ee_exif11a-624x341.png 624w\" sizes=\"(max-width: 659px) 100vw, 659px\" \/><\/p>\n<p>Click <a href=\"https:\/\/www.yohz.com\/blogs\/?p=452\">here<\/a> to read more about the <strong>Advanced Search<\/strong> in Easy Explorer, or <a href=\"http:\/\/www.yohz.com\/downloads\/easyexplorer\/EasyExplorerSetup.zip\">download<\/a> a <strong>FREE 14-day trial<\/strong> now and start searching for your documents using extended attributes the easy way.<\/p>\n<div class=\"fcbkbttn_buttons_block\" id=\"fcbkbttn_left\"><div class=\"fcbkbttn_like \"><fb:like href=\"https:\/\/www.yohz.com\/blogs\/2019\/09\/04\/searching-for-word-and-excel-documents-by-author-and-other-extended-attributes\/\" action=\"like\" colorscheme=\"light\" layout=\"button\"  size=\"small\"><\/fb:like><\/div><div class=\"fb-share-button  \" data-href=\"https:\/\/www.yohz.com\/blogs\/2019\/09\/04\/searching-for-word-and-excel-documents-by-author-and-other-extended-attributes\/\" data-type=\"button\" data-size=\"small\"><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>In Easy Explorer, you can use the advanced search function to search for Word, Excel, or other Microsoft Office documents using its extended attributes values like author, subject, comments, etc. In Windows Explorer, you can display those attributes by adding the columns e.g. You can display the same attributes in Easy Explorer i.e. To search [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[37],"tags":[63,64,38,62,61],"_links":{"self":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/487"}],"collection":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/comments?post=487"}],"version-history":[{"count":6,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/487\/revisions"}],"predecessor-version":[{"id":509,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/posts\/487\/revisions\/509"}],"wp:attachment":[{"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/media?parent=487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/categories?post=487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.yohz.com\/blogs\/wp-json\/wp\/v2\/tags?post=487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}