Set default filter

Question

Allow users to set a default filter for a table.

Answer 1

As of version 1.0.9.0688, dbFront allows users to save or load their default Advanced Filter settings for each table. dbFront will save the settings to either a local Cookie or to their User Profile.

Comments

We would find both options useful.  A default filter based on date range needs the flexibility to specify in terms of date different from the current date.

---

A date relative filter could easily be implemented by adding a view column that includes the aged value, e.g. InvoiceAge = (SysDate - InvoiceDate) formatted as Days.   You could then filter out all due invoices greater then 30 days.