Workflow not finding matches in database

Hello,

I currently have a workflow where I read a list of ingredients, search an ingredients database for a matching ingredient, read its properties and report back a score. In this case the the first ingredient its looking at is “water (aqua/eau).” and it needs to have the constraint that the ingredient type must contain “Water.” Now if you look at the database entry it has it but its not picking up on it.

Also note I’ve already dealt with the case issue (everything is now all lowercase)


1 Like

Editor Link

I have converted the ingredient_name to lowecase and then look for the value, and it returns a result.
How do you handle the case issue?

1 Like

I updated all the database entries to the following below.

See updated visual when its run


The setup seems correct, if you check out the link above, it has almost the same setup but the search is successful, you can try find what you did differently.

Unless you can provide more details, I could only think the remaining possible cause is privacy rules.

1 Like

I’m wondering if this is a Bubble issue

1 Like