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 when I would get around to it.

One option you could consider is using a stored procedure to create that functionality yourself. Using the ProcedureAPI, you could prompt the user for the search parameters you need and then search all of the appropriate tables and then return one or more result sets to the user.

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