win43.client restrict combining many filters

Question

I'm trying to read outlook emails via python, have code like below:

        import win32com.client
        import os 
        from datetime import datetime, timedelta
        
        outlook = win32com.client.Dispatch('outlook.application')
        mapi = outlook.GetNamespace('MAPI')
        
        messages = mapi.Folders("test@gmail.com").Folders("Inbox").Folders("Test").Items
        

       today_change = timedelta(7)
       today = datetime.today()
       start_date = today - today_change
       start_date = start_date.strftime('%Y-%m-%d %H:%M %p')
       today = today.strftime('%Y-%m-%d %H:%M %p')
        
        messages = messages.Restrict("[ReceivedTime] >= '" + start_date
        + "' And [ReceivedTime] <= '" + today +  "' And  @SQL=(urn:schemas:httpmail:subject LIKE '%deleted%')")

I'm trying to add more filters than 1, but I can't manage to do that. Can someone explain how should I add/merge more filters? Separately they work fine.

Since I still coudn't manage to get this work in one phrase, I'm just using: `messages2 = messages.Restrict("[ReceivedTime] >= '" + start_date + "' And [ReceivedTime] <= '" + today + "'") messages2 = messages2.Restrict("@SQL=(urn:schemas:httpmail:subject LIKE '%deleted%')")` and it do the job. — KeroN, May 02 '22 at 15:35

Dmitry Streblechenko · Answer 1 · 2022-04-22T00:03:36.007

0

@SQL= prefix can only be used to prefix the whole query. Also, it is better to use PR_NORMALIZED_SUBJECT instead of PR_SUBJECT (the former property is what gets indexed).

Try the following (off the top of my head):

messages = messages.Restrict("@SQL=ReceivedTime >= '" + start_date
        + "' And ReceivedTime <= '" + today +  "' And ""http://schemas.microsoft.com/mapi/proptag/0x0E1D001F"" LIKE '%deleted%' ")

edited Apr 22 '22 at 00:03

answered Apr 21 '22 at 15:25

Dmitry Streblechenko

62,942
4
53
78

Hey, this filter doesn't show any message for me (at least no error tho). And I don't really know what's this link in code. I would be grateful if you could explain a bit more. – KeroN Apr 21 '22 at 17:16
It is not a link, it is a DASL property name of the `PR_NORMALIZED_SUBJECT` MAPI property. Try to get rid of the date restriction - do you get back any results? – Dmitry Streblechenko Apr 21 '22 at 17:45
Yep, I'm receiving mails with string delete in subject. Still can't find way to get multiple filters at the same time! – KeroN Apr 22 '22 at 12:02
Please the actual value of your restriction string with the dates. – Dmitry Streblechenko Apr 22 '22 at 13:44

Eugene Astafiev · Answer 2 · 2022-04-22T12:09:58.757

0

You need to use the SQL syntax in the following way:

messages = messages.Restrict("""@SQL="urn:schemas:httpmail:datereceived" >= '" + start_date
        + "' And "urn:schemas:httpmail:datereceived" <= '" + today +  "' And "urn:schemas:httpmail:subject" LIKE '%deleted%')""")

See Filtering Items Using Query Keywords for more information.

edited Apr 22 '22 at 12:09

answered Apr 21 '22 at 15:38

Eugene Astafiev

47,483
3
24
45

Hey, there is an error from this one: >", line 2, in Restrict pywintypes.com_error: (-2147352567, 'Exception occured.', (4096, 'Microsoft Outlook' – KeroN Apr 21 '22 at 17:18
It seems you need to use `Chr(34)` instead of double quotes in the search string. – Eugene Astafiev Apr 21 '22 at 18:31
I've updated the search string. – Eugene Astafiev Apr 21 '22 at 18:33
Hey, thanks for helping, but still it shows errors. With &: "TypeError: unsupported operand type(s) for &: 'str' and 'str'", and if I switch to "+" instead of "&", then old one.... – KeroN Apr 22 '22 at 12:04
Ohh.. you need to use + in python. – Eugene Astafiev Apr 22 '22 at 12:06
You may find how to embed double quotes in the [Single quotes vs. double quotes in Python](https://stackoverflow.com/questions/56011/single-quotes-vs-double-quotes-in-python) thread. – Eugene Astafiev Apr 22 '22 at 12:10

win43.client restrict combining many filters

2 Answers2