Searching the Timesheets MTS Database |
You can execute arbitrary SQL searches on the Timesheets MTS database using the Search Database options of the tools menu. This screen includes a query building system to allow simple queries to be built. If you have some knowledge of SQL you can also enter free form SQL queries on this screen. Care should be taken before using any DELETE or UPDATE queries.
| Simple Single Table Search | Select this option to perform a simple single table search with the query generated using the simple query builder. |
| Search Table | Choose the Timesheets MTS database table to search. |
| Return All Records | Use this option to return all the records in the selected table. |
| Search For | Select this option and enter a search parameter in the text box. For example, to return all projects containing the word 'web' select this option and enter web into the search box. |
| Exactly | Check this option to match the search criteria exactly. For example, if search for 'web' only records will be returned that have a field set exactly to 'web'. |
| Like | Check this option to loosely match the search criteria. For example, if search for 'web' records will be returned that have a field set to 'web' or 'website' or 'webbing'. |
| Any Field | Check this option to search all the fields in a chosen table for the search parameter. |
| Selected Field | Check this option and select a field from the dropdown box to search only the selected field for the search parameter. |
| SQL Search | Check this option to enter an SQL statement into the SQL Search text box. |
| SQL Search Text | You can enter a free form SQL statement here. When running a query generated by the simple query builder the SQL statement generated will be output here. |
| Execute Search | Click this button to execute a search. If any records are returned they will be output into a new results window. This results window can optionally be exported to MS Excel. |
| Exit | Click this button to exit. |