1 files changed, 15 insertions, 0 deletions
diff --git a/internal/store/sqlite.go b/internal/store/sqlite.go
index 166cd63..f4651bb 100644
--- a/internal/store/sqlite.go
+++ b/internal/store/sqlite.go
@@ -723,6 +723,21 @@ func (s *Store) GetTasksByDateRange(start, end time.Time) ([]models.Task, error)
 	return scanTasks(rows)
 }
 
+// GetUndatedTasks retrieves incomplete tasks with no due date.
+func (s *Store) GetUndatedTasks() ([]models.Task, error) {
+	rows, err := s.db.Query(`
+		SELECT id, content, description, project_id, project_name, due_date, priority, completed, labels, url, created_at
+		FROM tasks
+		WHERE due_date IS NULL AND completed = FALSE
+		ORDER BY priority DESC, created_at ASC
+	`)
+	if err != nil {
+		return nil, err
+	}
+	defer func() { _ = rows.Close() }()
+	return scanTasks(rows)
+}
+
 // GetMealsByDateRange retrieves meals within a specific date range
 func (s *Store) GetMealsByDateRange(start, end time.Time) ([]models.Meal, error) {
 	return s.GetMeals(start, end)