Searching (Simple & Advanced)
dbFront has two main options for searching: Simple and Advanced. You can view the video Searching and Filtering to see a walkthough of searching in action.
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 browsers 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 you are looking at happens 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 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.
Numeric or Date fields will automatically allow you to specify a range. You can specify both the begining and end of the range or only the begining 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 simple click on the close button.