{"id":31831,"date":"2018-05-31T14:26:31","date_gmt":"2018-05-31T22:26:31","guid":{"rendered":"https:\/\/ephesoft.com\/docs\/2019-1-2\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/"},"modified":"2020-05-19T12:24:11","modified_gmt":"2020-05-19T19:24:11","slug":"how-to-perform-multiple-fuzzydb-lookups","status":"publish","type":"docs","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/","title":{"rendered":"How to Perform Multiple FuzzyDB Lookups"},"content":{"rendered":"<p><strong>Applies to:\u00a0<\/strong>Ephesoft 4.5<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Issue<\/strong><strong>:\u00a0<\/strong>How to Perform Multiple FuzzyDB Lookups on the same Batch Class<\/p>\n<p>&nbsp;<\/p>\n<p>The scenario may arise where you need to perform a Field FuzzyDB search on a previously returned FieldFuzzy lookup value and use that first value to pull the related index field values from that first Fuzzy return.<\/p>\n<p>&nbsp;<\/p>\n<p>Consider the below example:<\/p>\n<p>&nbsp;<\/p>\n<p>In the below setup, we have configured the field fuzzy like this:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-15446\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1.png\" alt=\"\" width=\"1612\" height=\"467\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1.png 1612w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1-300x87.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1-768x222.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1-1024x297.png 1024w\" sizes=\"(max-width: 1612px) 100vw, 1612px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>We have the \u201cFuzzyDB\u201d plugin setup in my Batch Class to run twice:<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-15447\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2.png\" alt=\"\" width=\"1608\" height=\"651\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2.png 1608w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2-300x121.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2-768x311.png 768w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff2-1024x415.png 1024w\" sizes=\"(max-width: 1608px) 100vw, 1608px\" \/><\/a><\/p>\n<p>The reason for this is that during the first run of the \u201cFuzzyDB\u201d plugin, it will populate the \u201cPersonID\u201d using the first field fuzzy setup we configured. Then when it runs the FuzzyDB plugin the second time around, it will already have the PersonID populated, and use that value to do the Field Fuzzy search for the second Field Fuzzy setup.<\/p>\n<p>&nbsp;<\/p>\n<p>This is what the result looks like:<\/p>\n<p><a href=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff3.png\"><img decoding=\"async\" class=\"alignnone size-full wp-image-15448\" src=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff3.png\" alt=\"\" width=\"943\" height=\"639\" srcset=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff3.png 943w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff3-300x203.png 300w, https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff3-768x520.png 768w\" sizes=\"(max-width: 943px) 100vw, 943px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p>With only one instance of the FuzzyDB plugin configured, we were only getting the Person ID to populate, because it tried executing all the fuzzies at once, so the second field fuzzy rule wouldn\u2019t work, because there was no person ID filled out. Once we added in the second instance of the FuzzyDB plugin configured, it worked because PersonID now had a value for us to use and perform a fuzzy search.<\/p>\n<p>&nbsp;<\/p>\n<p>Please note this has been only tested on Ephesoft 4.5.0.0. Earlier versions of Ephesoft may not return the same results.<\/p>\n","protected":false},"featured_media":0,"parent":31830,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","doc_tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v19.0 (Yoast SEO v22.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Perform Multiple FuzzyDB Lookups | Ephesoft Docs<\/title>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Perform Multiple FuzzyDB Lookups\" \/>\n<meta property=\"og:description\" content=\"Applies to:\u00a0Ephesoft 4.5 &nbsp; Issue:\u00a0How to Perform Multiple FuzzyDB Lookups on the same Batch Class &nbsp; The scenario may arise [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/\" \/>\n<meta property=\"og:site_name\" content=\"Ephesoft Docs\" \/>\n<meta property=\"article:modified_time\" content=\"2020-05-19T19:24:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/\",\"url\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/\",\"name\":\"How to Perform Multiple FuzzyDB Lookups | Ephesoft Docs\",\"isPartOf\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\"},\"datePublished\":\"2018-05-31T22:26:31+00:00\",\"dateModified\":\"2020-05-19T19:24:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/ephesoft.com\/docs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Transact\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Features and Functions\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Administrator Role and Features\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Modules and Plugins\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Extraction Module\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/\"},{\"@type\":\"ListItem\",\"position\":7,\"name\":\"Fuzzy DB Extraction\",\"item\":\"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/\"},{\"@type\":\"ListItem\",\"position\":8,\"name\":\"How to Perform Multiple FuzzyDB Lookups\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ephesoft.com\/docs\/#website\",\"url\":\"https:\/\/ephesoft.com\/docs\/\",\"name\":\"Ephesoft Docs\",\"description\":\"Intelligent Document Processing Made Easy\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ephesoft.com\/docs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Perform Multiple FuzzyDB Lookups | Ephesoft Docs","robots":{"index":"noindex","follow":"follow"},"og_locale":"en_US","og_type":"article","og_title":"How to Perform Multiple FuzzyDB Lookups","og_description":"Applies to:\u00a0Ephesoft 4.5 &nbsp; Issue:\u00a0How to Perform Multiple FuzzyDB Lookups on the same Batch Class &nbsp; The scenario may arise [&hellip;]","og_url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/","og_site_name":"Ephesoft Docs","article_modified_time":"2020-05-19T19:24:11+00:00","og_image":[{"url":"https:\/\/ephesoft.com\/docs\/wp-content\/uploads\/2018\/05\/ff1.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/","url":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/","name":"How to Perform Multiple FuzzyDB Lookups | Ephesoft Docs","isPartOf":{"@id":"https:\/\/ephesoft.com\/docs\/#website"},"datePublished":"2018-05-31T22:26:31+00:00","dateModified":"2020-05-19T19:24:11+00:00","breadcrumb":{"@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-perform-multiple-fuzzydb-lookups\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ephesoft.com\/docs\/"},{"@type":"ListItem","position":2,"name":"Transact","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/"},{"@type":"ListItem","position":3,"name":"Features and Functions","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/"},{"@type":"ListItem","position":4,"name":"Administrator Role and Features","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/"},{"@type":"ListItem","position":5,"name":"Modules and Plugins","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/"},{"@type":"ListItem","position":6,"name":"Extraction Module","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/"},{"@type":"ListItem","position":7,"name":"Fuzzy DB Extraction","item":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/"},{"@type":"ListItem","position":8,"name":"How to Perform Multiple FuzzyDB Lookups"}]},{"@type":"WebSite","@id":"https:\/\/ephesoft.com\/docs\/#website","url":"https:\/\/ephesoft.com\/docs\/","name":"Ephesoft Docs","description":"Intelligent Document Processing Made Easy","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ephesoft.com\/docs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"comment_count":0,"_links":{"self":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31831"}],"collection":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/comments?post=31831"}],"version-history":[{"count":0,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31831\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31830"}],"next":[{"title":"How to configure Field Fuzzy with separate index fields pointing to different Database","link":"https:\/\/ephesoft.com\/docs\/products\/transact\/features-and-functions\/administrator\/moduleplugin-configuration\/extraction-module\/fuzzy-db-extraction\/how-to-configure-field-fuzzy-with-separate-index-fields-pointing-to-different-database\/","href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/docs\/31832"}],"wp:attachment":[{"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/media?parent=31831"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ephesoft.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=31831"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}