Create an admin dashboard for the Pro platform

[manon-corneille]

Mock up : https://www.canva.com/design/DAF3oHvgJTI/68fLAM74uJaD0X48ZPuN-w/edit

Part of

• 5521

[john-gom]

It should be relatively easy to adapt off-query to support this. If you could write the types of query you would need in pseudo-SQL then I could investigate what changes might be needed.

[stephanegigandet]

It should be relatively easy to adapt off-query to support this. If you could write the types of query you would need in pseudo-SQL then I could investigate what changes might be needed.

Hi @john-gom , definitely, a lot of the data can come from queries to off-query. We'll need to add the pro platform data to it. I started a doc with some details about data sources and which fields can be used to get the data we need here: https://docs.google.com/document/d/137Jvu2W8KR0Qgbfkey96G3mOjScto_eO1LT32G12h0Q/edit#heading=h.c7ryljnotkpb

[alexgarel]

That's also completely in line with having events in off-query !

[john-gom]

Hi @stephanegigandet . For the data that is currently just in .sto files we could just keep it in there and generate a redis event when it changes, which off-query could then store, so no need to add to MongoDB

[stephanegigandet]

Hi @stephanegigandet . For the data that is currently just in .sto files we could just keep it in there and generate a redis event when it changes, which off-query could then store, so no need to add to MongoDB

@john-gom which data exactly? The data that is in .sto and not MongoDB is related to organizations, not products. To ease dashboard creation, we want to copy it to a new organization collection in MongoDB: https://github.com/openfoodfacts/openfoodfacts-server/issues/10245