Fixing Outlook 2010 GMail tasks duplications in the To-Do List

If you're using GMail account working with Outlook 2010 you'll notice that every time you flag a message or create a task it will appear number of times in your tasks list. The reason is that in IMAP GMail the messages are stored in few different locations like All Items, Inbox, and labeled location. Outlook cannot tell which is identical task thus make all the occurrences flagged.

To overcome this you need to create a filter to have the right view.

1. In the To-Do list pane, right click anywhere and choose Filter.
2. Choose Advance tab and add new rule.
3. Choose the "In Folder" field and create rule for every folder you want to be appear in the To-Do list:

You can simply add single rule with "All Items" as the value.

Now the *real* treat:

To have the same view in Outlook Tasks desktop gadget, you need to put the same filter on the gadget script. This could be related to my previous post (Tasks gadget for Outlook 2010):

1. In the same Filter of the To-Do list, click the SQL tab and check "Edit this criteria..." checkbox.
   Copy the entire SQL code.
   Uncheck the Edit box and close the filter box.
2. In explorer or CMD go to "C:\Users\\AppData\Local\Microsoft\Windows Sidebar\Gadgets\OutlookTasksGadget.gadget"
3. Edit with notepad ..\en-US\js\tasks.js
4. go to line 881where is "var filter = "@SQL=(\"http:...."
5. duplicate the line and remark the first one with //
6. Now paste the SQL code after the SQL statement and add the appropriate slashes for JS syntax. the SQL code f the filters shown in step 3 looks like this:
   
   var filter = "@SQL=((\"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003\" = 0 OR \"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003\" = 1 OR \"http://schemas.microsoft.com/mapi/id/{00062003-0000-0000-C000-000000000046}/81010003\" = 3) AND (\"http://schemas.microsoft.com/mapi/proptag/0x0e05001f\" LIKE '%Starred%' OR \"http://schemas.microsoft.com/mapi/proptag/0x0e05001f\" LIKE '%Tasks%' OR \"http://schemas.microsoft.com/mapi/proptag/0x0e05001f\" LIKE '%Inbox%'))"
   
   pay attention to the backslash BEFORE the http line and AFTER.

Save and close tasks.js, close and reopen the gadget. the filter is now part of the Outlook Tasks  gadget.