Present a database 'view' as if it were a table?

Question

Filtered rows would be nice but really not essential. A pure stand-alone table like view which allows sorting and filtering of results as you do now would do the job perfectly.

One thing I just remembered is that Access asks which field is to be used as a key when it is linked. Perhaps dbFront could do something similar. Just a thought :)

Comments

This would be a good feature to include in the software.   Currently for views, were using Grafana to show as a table, but being built into dbfront directly would be more useful.

---

I would also like to see this as sort of a standing report.  since reports cannot join in more than one child table at a time.  this combined with export button would solve a few problems for us.

---

You could use a Stored Procedure based report instead of a View based report if you want.  https://dbfront.com/runprocedure#results, far more flexible and powerful since you can provide inputs and it can run conditional logic.

Answer 1

Thank you for your request. There are situations where this makes the best sense.

At the same time those asking for view support might be missing a much better alternative.

Stand-alone views are largely divorced from the underlying data structure. This means that dbFront can't automatically generate lookups, use indexes or bring in other related tables.

For example, if you want your users to look at a specific table:

• possibly filtered,
• with the related data expanded,
• some summary information...

... then you would be further ahead by creating and joining a small view to the current table to supply the summary information.

NOTE: Please vote on this Feature Request if it interests you.