char *statement;
GList *tasks = NULL;
- /* FIXME: get the priority */
statement = g_strdup_printf ("SELECT "
- "task_id, name, priority, due_date FROM tasks "
+ "task_id, name, priority, list_id, taskseries_id, "
+ "due_date "
+ "FROM tasks "
"WHERE "
"delete_date IS NULL AND "
"complete_date IS NULL"
rtm_task_set_name (task, (char*)sqlite3_column_text (query, 1));
rtm_task_set_priority (task,
(char*)sqlite3_column_text (query, 2));
+ rtm_task_set_list_id (task,
+ (char*)sqlite3_column_text (query, 3));
+ rtm_task_set_taskseries_id (task,
+ (char*)sqlite3_column_text (query, 4));
- if (db_date_column_to_timeval (query, 3, &timeval))
+ if (db_date_column_to_timeval (query, 5, &timeval))
rtm_task_set_due_date (task, &timeval);
tasks = g_list_prepend (tasks, task);