hasCompletedAt = NO
SQL = SELECT id, title, description, assigned_to, deadline FROM tasks WHERE status='Done'
ORDER BY id DESC
LIMIT 20 OFFSET 20
Niinii — History Selesai
Notis: Lajur completed_at belum wujud. Tarikh siap tidak dipaparkan.
Tambah lajur dengan:
ALTER TABLE tasks ADD COLUMN completed_at DATETIME NULL AFTER status;
Jumlah rekod: 25
Halaman: 2 / 2
Tajuk & Deskripsi
Assigned
Deadline
—
Serah transaction bonus pada finance
Azam
2025-10-01
-
Bayar bonus maid
Azam
2025-10-01
-
Bagi transaction gaji pada finance
Azam
2025-10-01
-
Bayar Gaji maid
Azam
2025-10-01
-