GeniusConnect support forum
GeniusConnect support forum
Home | Profile | Register | Active Topics | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 GeniusConnect
 Tips & Tricks
 Outlook Filter
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Admin

Czech Republic
1710 Posts

Posted - 11 Apr 2006 :  22:39:17  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
This feature is for advanced users!


To create and test a filter in Outlook:

1.select the folder in Outlook, right click the column header->View settings->button "Filter"
2.Add fields with your criteria
3.Close Outlook Filter dialog
4.Test filter results in Outlook, repeat the steps to modify your filter

Copy the filter to GeniusConnect:

1.select the folder in Outlook, right click the column header->View settings->button "Filter"
2.Click the SQL Tab
3.Check "Edit these criteria directly..."
4.Copy the query
5.Open GeniusConnect config->Database Tab
6.Right Click the folder->Advanced->"Add/Edit Outlook Filter"

Enter: @SQL=here your query
Example:
@SQL="urn:schemas:calendar:dtstart" >= 'last month'



If you are not using DASL filter you can enter the filter directly without "@SQL=" keyword.

Examples:
[CompanyName] = 'XXX'
[Categories] = 'Personal' Or [Categories] = 'Business'
[Categories] = 'Personal' And [CompanyName] = 'GeniusConnect'
[Sensitivity] <> 'Confidential'

Today Outlook filter for Calendar items:
[Start] < tomorrow and [Start] > yesterday

Calendar filter "this and last month":
[End] >= lastmonth


Older GeniusConnect versions:
You can enter the filter directly in registry:
HKEY_CURRENT_USER\Software\Genius@Work\GeniusConnect\Folders\<Folder ID>\OutlookFilter


examples:
https://www.msoutlook.info/question/276
https://blogs.msdn.microsoft.com/andrewdelin/2005/05/10/doing-more-with-outlook-filter-and-sql-dasl-syntax/


DASL Examples:
To use DASL query, use:@SQL=<query>
Example 1:
End date <= today + 10 days (in seconds)
@SQL="urn:schemas:calendar:dtend" <= today(864000)

Example 2:
Start date >= last month
@SQL="urn:schemas:calendar:dtstart" >= 'last month'


MyNextHome

21 Posts

Posted - 26 Mar 2009 :  16:15:11  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I have a question concerning the Filters for Outlook 2003, what type of language and / or variables are available for the filter?
Because I am trying to synchronize only the daily emails so I setup this rule "[ReceivedTime] >= ToDay" which works fine but it doesn't synchronize the emails recieved between 00:00:00 till about 7:00:00 something like that.
Go to Top of Page

MyNextHome

21 Posts

Posted - 26 Mar 2009 :  16:16:17  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I just want to tell you that I find the problem.. it's a little bit currious but it works. If you change in "tools -> options -> option of the calendar " and set the time of the begining of the day at 00:00 the filter import all the mails of the day. :-)
Go to Top of Page

Admin

Czech Republic
1710 Posts

Posted - 12 May 2009 :  15:29:27  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Outlook Filter and 2 way sync:
Make sure your SQL Filter is filtering same data as your Outlook Filter!



You can ignore this remark when syncing only from Outlook to DB.


Go to Top of Page

Admin

Czech Republic
1710 Posts

Posted - 23 Aug 2010 :  13:35:03  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Microsoft Outlook set of date values:

yesterday
today
tomorrow
last7days
next7days
lastweek
thisweek
nextweek
lastmonth
thismonth
nextmonth

Example:
[Start] >= lastmonth and [End] <= nextmonth
Go to Top of Page

Admin

Czech Republic
1710 Posts

Posted - 03 Dec 2012 :  23:10:46  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Filters Outlook 2007:
http://msdn.microsoft.com/en-us/library/office/cc513841(v=office.12).aspx
Go to Top of Page

Admin

Czech Republic
1710 Posts

Posted - 01 Jan 2019 :  13:36:58  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Example mail filter:
only email received yesterday and today
@SQL="urn:schemas:httpmail:datereceived" >= 'Yesterday'

only email received today
@SQL="urn:schemas:httpmail:datereceived" >= 'Today'
Go to Top of Page

Admin

Czech Republic
1710 Posts

Posted - 25 May 2020 :  11:19:40  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Example email subject filter:
@SQL="urn:schemas:httpmail:subject" LIKE '%my subject%'
Go to Top of Page
   Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
GeniusConnect support forum © Copyright (C) 2003 - 2020, GeniusConnect, All Rights Reserved. Go To Top Of Page
Snitz Forums 2000