Quick Search Across Multiple Tables

Question

Sometimes users don't have a clue what they are looking for (e.g. a reference which could be in multiple tables).

It would be good if there was a page which allowed selection of tables and performed a "quick search" on each of those tables, and returned each individual table of data.

Clicking on the record, would then redirect the page as per this feature request: https://dbfront.com/qa/1477/separate-record-view-instead-of-showing-table

As a lot of our image upload/sharing platforms are blocked in the UK, here's a nice Image representation:

---

| Search Box |
__

---

| Table 1 results |
____
____
| Table 2 results |
____
____
| Table 3 results |
____

Answer 1

This is a cool idea but I am not sure that it needs to be added to the dbFront core.

A good solution is to create that functionality yourself using the ProcedureAPI:

1. Prompt the user for the search parameters you need,
2. Search all of the appropriate tables using the stored procedure,
3. Return one or more result sets to the user.

NOTE: Please vote on or consider funding this Feature Request if you want this as part of the core application.