Perform multiple FuzzyDB lookups
Sometimes 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.
Example:
In this setup, we configure the field fuzzy as follows.
We have the FuzzyDB plugin setup in the Batch Class to run twice.
The reason for this is that during the first run of the FuzzyDB plugin, it populates the PersonID using the first field fuzzy setup that we configured. Then when it runs the FuzzyDB plugin the second time around, it already has the PersonID populated, and uses that value to do the Field Fuzzy search for the second Field Fuzzy setup.
View the result:
With only one instance of the FuzzyDB plugin configured, we were only getting the Person ID to populate, because it tries to execute all the fuzzies at once, so the second field fuzzy rule does not work, because there is no PersonID filled out. Once we add the second instance of the FuzzyDB plugin configured, it works because PersonID now has a value for us to use and perform a fuzzy search.