Equivalent of Select Where In with Outlook DASL Filter

Question

I am searching a list of mails from their respective PR_MESSAGE_ID using the Outlook VSTO AdvancedSearch feature.

My query looks like

 http://schemas.microsoft.com/mapi/proptag/0x1035001E = 'targetId1' OR
 http://schemas.microsoft.com/mapi/proptag/0x1035001E = 'targetId2' OR
 http://schemas.microsoft.com/mapi/proptag/0x1035001E = 'targetId3' OR 
 http://schemas.microsoft.com/mapi/proptag/0x1035001E = 'targgetId4' ...etc.

I am questioning the performance of this approach and I would like to know if there is a more elegant query, similar to a SELECT something WHERE 'MESSAGE_ID' IN (targetId1, targetId2, etc.)

Eugene Astafiev · Answer 1 · 2015-08-28T15:15:22.220

0

No, AdvancedSearch is a right choise because the search is performed in the background not blocking the UI thread. Moreover, you can search for items in multiple forlders.

All DASL queries begin with a case-sensitive prefix "@SQL=", with the exception of DASL queries for Application.AdvancedSearch.

See Filtering Items for other alternatives.

edited Aug 28 '15 at 15:15

answered Aug 28 '15 at 11:53

Eugene Astafiev

47,483
3
24
45

I think you misunderstood, sorry if it was not clear. I edited the question. Actually, I am not looking for another search approach but another DASL query to pass to the AdvancedSearch method. – Benoit Patra Aug 28 '15 at 13:01
See [Filtering Items](https://msdn.microsoft.com/en-us/library/office/ff863965.aspx) for other alternatives. – Eugene Astafiev Aug 28 '15 at 15:15
I already looked to this ressource. I do not see any 'contains' or 'in' operator. – Benoit Patra Aug 28 '15 at 15:53
1

IN is not supported simply because there is no such restriction on the MAPI level - it only exposes RES_OR restriction, which is functionally exactly the same. – Dmitry Streblechenko Aug 30 '15 at 17:17
@DmitryStreblechenko so my query is the best that I can achieve to retrieve a list of emails? – Benoit Patra Aug 31 '15 at 09:14
1

Yes. An OR query is the best you can do. – Dmitry Streblechenko Aug 31 '15 at 16:09

Equivalent of Select Where In with Outlook DASL Filter

1 Answers1