MirakelX / mirakel-android

Easy task management for professionals
http://mirakel.azapps.de/
385 stars 117 forks source link

Metalist "This Week" not showing this weeks tasks #591

Closed itadventurer closed 9 years ago

itadventurer commented 9 years ago

Original Reporter: kvbx Environment: Versions 2.8.1 and 2.7.1 from f-droid on Adroid 5.0.2 (Cyanogenmod 12), Sony Xperia Z2 Version: 2.8 Migrated From: https://mirakel.atlassian.net/browse/MIR-621

The metalist "This Week" doesn't show any tasks I add with due date today + 7. Even if I add a task in that list with default values it will show up in metalist "Overdue".

However: I downgraded form 2.8.1 to version 2.7.1 and it worked for once but doesn't anymore, same problem.

itadventurer commented 9 years ago

azapps said: Hmm… weird I can't reproduce this :(

Could you please activate the development settings (Settings → About → Tap some times on the version number) and then the SQL should be displayed in the settings of the meta lists. Could you please send us it? (A screenshot of the list should be enough)

itadventurer commented 9 years ago

marlowe said: I can reproduce this issue.

Mirakel: 2.8.1 (installed from F-Droid) Cyanogenmod 11 (Nexus 5) Taskd: 1.0.0

I have 1 overdue task and 2 tasks which are due within the week. The overdue task does not appear on the Overdue list, while the two ones due with the week due.

The SQL Query for the Overdue is below

{noformat} SELECT * FROM tasks WHERE (due IS NOT NULL AND due > ?) AND (done = ?) AND NOT sync_state = ? AND is_shown_recurring = ? {noformat}

Default values are: Default list: Inbox Default date: Yesterday

Conditions are: Due: Not before today - 1 days Done: Undone Tasks

This Weeks has the same SQL query. The Default data is set to +7 days and Due is set to Not before today +7 days.