Administrator
  •  Admin
  • Advanced Member Topic Starter
2006-04-11T22:39:00Z
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 

examples:
https://www.msoutlook.info/question/276 
https://blogs.msdn.micro...ter-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'


GeniusConnect saves outlook filter in registry:
HKEY_CURRENT_USER\Software\Genius@Work\GeniusConnect\Folders\<Folder ID>\OutlookFilter
Sponsor
GeniusConnect documentation search (User Manual Downloads...)
2009-03-26T16:15:00Z
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.
2009-03-26T16:16:00Z
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. 🙂
Administrator
  •  Admin
  • Advanced Member Topic Starter
2009-05-12T15:29:00Z
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.
Administrator
  •  Admin
  • Advanced Member Topic Starter
2010-08-23T13:35:00Z
Microsoft Outlook set of date values:

yesterday
today
tomorrow
last7days
next7days
lastweek
thisweek
nextweek
lastmonth
thismonth
nextmonth

Example:
[Start] >= lastmonth and [End] <= nextmonth
Administrator
  •  Admin
  • Advanced Member Topic Starter
2012-12-03T23:10:00Z
Administrator
  •  Admin
  • Advanced Member Topic Starter
2019-01-01T13:36:00Z
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'
Administrator
  •  Admin
  • Advanced Member Topic Starter
2020-05-25T11:19:00Z
Example email subject filter:
@SQL="urn:schemas:httpmail:subject" LIKE '%my subject%'
fred
2021-12-01T18:22:03Z
@SQL=(%yesterday("urn:schemas:httpmail:datereceived")% OR %today("urn:schemas:httpmail:datereceived")%)