Allow searching on all flavors (OPF, OBF, OPFF)

[raphodn]

Problem

I searched for a product in OPF - https://fr.openproductsfacts.org/produit/3830071491110/the-world-game-sweetips - and it didn't return any results :(

So currently search-a-licious only returns OFF products ?

Steps to reproduce

searching for an OPF product

https://search.openfoodfacts.org/search?q=code%3A3830071491110
https://search.openfoodfacts.org/search?q=code%3A3123840025006
// 0 hits

searching for an OBF product

https://search.openfoodfacts.org/search?q=code%3A3600550159172
// 1 hit 🤔
https://search.openfoodfacts.org/search?q=code%3700147214076
// 0 hits

searching for an OFF product works!

https://search.openfoodfacts.org/search?q=code%3A7613035040762
// 1 hit

[raphodn]

Also, a newly created OFF product doesn't seem to appear in the search results ?

• created 3350034031400 on January 4th 2025 at 10PM
• searched for the product by code on January 5th at 3PM: 0 hits

https://search.openfoodfacts.org/search?q=code%3A3350034031400

[alexgarel]

The plan to support this is:

• have a common database with all products but a limited set of fields
• keep specialized databases per product types with more meaningful fields