Workflow not finding matches in database

themmara · 2024-12-05T19:44:46.119Z

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)

Screenshot 2024-12-05 at 12.14.07 PM2860×578 86.4 KB

Screenshot 2024-12-05 at 12.15.06 PM1224×158 14.3 KB

thinkfort68 · 2024-12-05T20:05:31.252Z

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?

themmara · 2024-12-05T20:11:11.263Z

I updated all the database entries to the following below.

Screenshot 2024-12-05 at 3.08.03 PM1272×212 15.6 KB

See updated visual when its run

Screenshot 2024-12-05 at 3.10.08 PM2866×600 89.8 KB

Screenshot 2024-12-05 at 3.10.23 PM2872×594 104 KB

thinkfort68 · 2024-12-05T20:32:10.261Z

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.

themmara · 2024-12-07T09:35:48.100Z

I’m wondering if this is a Bubble issue