Navigation:  Advanced Topics (click to see list) >

    Filtering Time Records via SQL

Top  Previous  Next

Advanced users who know SQL (Structured Query Language) can filter the time records with complex or sophisticated Where clauses.

For example, the where clause:

Where (Client= 'AR Software' or Client= 'Microsoft') and Person= 'Mary Smith'

could be used to force the "or" clause to be evaluated first, and display all records for which AR Software or Microsoft are the client and Mary Smith is the person doing the work.

 

To set a filter via SQL

Choose Advanced/SQL Command.

 

More:

For a real life example, see: Filtering the Time Records in the The Last Column section.

For more on SQL, and links to SQL resources, please visit the SQL page on our web site, http://www.ResponsiveSoftware.com/sql.htm.