I am seeking some help on an issue I am having with building a simple “app” that filters queries based on a hierarchy (Department-SubDept-Class) I would like to add in “Merchant” which would come BEFORE department in the hierarchy, and also add in “Store” which would be used to filter but has no set order in the hierarchy.
When trying to work with merchant or store in Multi Select I can populate the query and the widget but when selecting my streamlit malfunctions and it doesn’t filter anything. I am not getting an error but a warning:
UserWarning: pandas only supports SQLAlchemy connectable (engine/connection) or database string URI or sqlite3 DBAPI2 connection. Other DBAPI2 objects are not tested. Please consider using SQLAlchemy.
df = pd.read_sql(query,conn)
see code: GitHub - jrodenberg1/demandplanning
I have since pulled Merchant and Store out of any multiselect as they aren’t working but the functions are the same. All queries in the code pull the desired result.