I'm working in an app that need global filter functionality. It's something like an accounting app with data segmented by line of business and periods. User want to change the active period and/or line of business and filter all pages with this new criteria.
I'm thinking about use user related data persisted in database to store filter selected and views or stored procedures to serve filtered data to app. I'm in the right direction or can you suggest another way to accomplish this requirement?
Thanks in advance