history filtering

1 files changed, 4 insertions, 1 deletions

diff --git a/internal/database/queries.sql b/internal/database/queries.sql
index 6d1108f..1ab9f44 100644
--- a/internal/database/queries.sql
+++ b/internal/database/queries.sql
@@ -294,9 +294,12 @@ select
 from time_entry te
 where date(te.start_time, 'localtime') = date('now', 'localtime');
 
--- name: GetRecentTimeEntries :many
+-- name: GetFilteredTimeEntries :many
 select * from time_entry 
 where start_time >= @start_time
+  and (@end_time is null or start_time <= @end_time)
+  and (@client_id is null or client_id = @client_id)
+  and (@project_id is null or project_id = @project_id)
 order by start_time desc;
 
 -- name: UpdateActiveTimerDescription :exec