How do I use a Report SQL Filter to include time entries with non-blank notes?

Question

How do I use a Report SQL Filter to include time entries with non-blank notes?

Answer

Pacific Timesheet's reporting engine allows you to filter in time entries with non-blank notes values using a sql expression in its sql filter.

Here the steps to create this report:

1. Navigate to the Reports tab
2. Create a time entry notes report by scrolling down to the Timesheet Details template and clicking the Plus (+) button.
3. Name the report and add/remove the fields you need using the report field +/- buttons.
4. Scroll to the bottom of the report page.
5. In the SQL Filter edit box enter the following sql:  LEN(t_timeentry.notes)>0
6. This sql expression will filter into the report all notes (t_timeentry.notes) with a character length greater than zero. In other words, the sql filter will exclude time entries with blank note values.