- » Support
- Time Tracking Tips
SQL (Structured Query Language) is a unified language for accessing databases.
Advanced Time Logger users can use SQL to work with their time record databases. To enter an SQL command in Time Logger version 4, choose Advanced/SQL Command, and type the command into the dialog.
For example, the SQL Command:
select StartDate, StartTime, EndTime, Project, Client, Description, Duration, Key from TimeRecords
Where Client= 'AR Software' and Billed=0 and Billable=-1
Order By Project
would show all of AR Software's records that had not been billed, and which were billable. The records would be sorted by Project. You can go much further than this however. This SQL Command, for example,
select StartDate, StartTime, EndTime, Duration, Key, Mileage as Words, Mileage*3600/Duration as WordsPerHour from TimeRecords
Could be used by an author who wants to know how many words per hour have been added to her manuscript. She would enter the word total into the mileage field. The SQL command performs a calculation involving the duration (in seconds) and the mileage.
PageName=/sql | Website Last Updated: Saturday April 20, 2013