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.

Configure field fuzzy

We have the FuzzyDB plugin setup in the Batch Class to run twice.

FuzzyDB plugin 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:

Two FuzzyDBs - 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.