How to switch between saved filters in portal widget?

[charliesdev]

I would like to have a data table widget that the user can filter - that also has a base filter.

For instance allow them to see data changed last week or 2 weeks ago, but only data they have changed.

I started with cloning the Data Table From Instance (with filter on) and adding a filter string in the options.  Initially it works great, but when the user edits the filter - it replaces the filter built into the options.  I would like it to add the filters together.

The other idea is to have buttons on the page, each one representing a predefined query.  When a user clicks a button, the corresponding filter is applied to the table widget.  But I cannot figure how to let the (what seems like 4 nested) widgets know about the filter and have it applied to the table properly.

Last idea I had was to use the data Table From URL, but it would be on a page with at least 2 other widgets, would that even work?

I'm also open to other ideas, thanks for your time.

[charliesdev · Accepted solution]

I went with the last approach, Data Table from URL - which wasn't without its own problems: my solution