your database front-end

Searching (Simple & Advanced)

dbFront has two main options for searching: Simple and Advanced.  You can view the video Searching and Filtering to see a walkthrough of searching in action.

Simple Searches

Finding data in dbFront is very straight forward because every table has a search box at the top left corner.  Just type the values or keywords you are looking for and dbFront will find it.  The values or keywords should be separated by spaces and can be entered in any order.

If the table that you are looking at is small enough then dbFront will load it into the browser's memory and do the filtering as you type each character.  This makes the process of finding specific records very fast and intuitive.

If the table is to be too large to load into memory, dbFront will not respond until you hit the enter key in the search text box.  Once you hit enter, then dbFront will send the search request to the server and return the filtered results.  This is done to avoid overloading the server.

This is fairly intuitive.  Start typing and if the search responds immediately then all is good.   If not hit enter to send your search to the server.

Advanced Searching (optional)

In addition to the Simple Search, dbFront also allows you to run advanced searches.  Below every table, you will see a collapsible panel that will show a list of fields that you can search on.   Click this panel to open it and show the search fields.   This list of fields can be managed or disabled by the administrator.  For more details see: Search Fields

Numeric or Date fields will automatically allow you to specify a range.  You can specify both the beginning and end of the range or only the beginning or end of the range.

dbFront will automatically update the search results as you add fields to the criteria.  dbFront will also add a widget to the Advanced Search title bar showing what you are searching on.   To remove the field you can simply click on the close button.

Full-Text Search

dbFront Supports Full-Text search in both the Simple and Advanced modes.  Any fields that have been configured for Full-Text search will automatically be queried using the Full-Text indexes.   For more details see: Full-Text Search.

Content you want the user to see goes here.