How to filter both date and multiple subjects at once

Help Activities
, , , ,
1

Hi,

I am facing issue in filtering in get outlook mail messages, I was unable to filter both subject and receivedtime at once.

Note : I have multiple subjects to filter kindly help me.

2

you can input custom filters in the “filter property” of “get outlook mail messages” here
for example:
filter subject containing “test Subject” OR “test Subject2” and received date > 05/10/2020

"@SQL=urn:schemas:httpmail:datereceived > '05/10/2021 00:00:00' AND (urn:schemas:httpmail:subject like '%test Subject%' OR urn:schemas:httpmail:subject like '%test Subject2%')"

example filter subject containig string variable “mailSubject” and received date = Today

"@SQL=urn:schemas:httpmail:datereceived = '" + Now.ToUniversalTime.ToString("dd/MM/yyyy hh:mm:ss") + "' AND urn:schemas:httpmail:subject like '%" + mailSubject + "%'"

image
image1012×338 14.4 KB

3

subject and received time filter
easy solution use this in filter expression like here subject is i wm IT guy receivedtime is date and there is also time

4

I tried this solution but one doubt actually if my subject ’ i am it guy’ and I want to retrieve mail which contains ‘guy’.Why because in future subject might be ‘I am an Network guy’

1 Like
5

I tried this solution but one doubt actually if my subject ’ i am it guy’ and I want to retrieve mail which contains ‘guy’.Why because in future subject might be ‘I am an Network guy’

1 Like
6

Hi Jack,

I tried this but it is not throwing error also it is not extracting the subjects ,only dates i can able to get.

7

can you paste the filter here?

8

“@SQL=urn:schemas:httpmail:datereceived > ‘05/10/2021 00:00:00’ AND (urn:schemas:httpmail:subject like ‘% BANGALORE %’ OR urn:schemas:httpmail:subject like ‘% Hyderabad %’)”

9

is your date correct? its saying 05/10/2021

10

HI @jack.chan,
I don’t have any problem with date,i need to do both at once. I tried ur solution too but it is not filtering.
I have used filter
“@SQL=urn:schemas:httpmail:datereceived > ‘05/10/2021 00:00:00’ AND (urn:schemas:httpmail:subject like ‘%test Subject%’ OR urn:schemas:httpmail:subject like ‘%test Subject2%’)”

1 Like
11

I am new here please help me to explain this sql query how could i use in get mail message