| PL/SQL Email Client | |||||
SUMMARY: FIELD | TYPE | METHOD | DETAIL: FIELD | TYPE | METHOD |
-- Retrieve only mails which were sent since yesterday MAIL_FILTER.ADD_SENTDATE_FILTER(sysdate - 1, '>=', true); -- Retrieve only mails which are sent directly to John Doe ("to", not "cc" or "bcc") MAIL_FILTER.ADD_TO_FILTER('john.doe@company.com'); -- Retrieve all mails except those directly sent to John Doe ("to", not "cc" or "bcc") MAIL_FILTER.ADD_TO_FILTER('john.doe@company.com', false);
Field Summary | |
number | FILTER_COMB_AND
Constant for mail filter combination: {filter1} AND {filter2} AND ... AND {filterN} |
number | FILTER_COMB_NOT_AND
Constant for mail filter combination: NOT({filter1} AND {filter2} AND ... AND {filterN}) |
number | FILTER_COMB_NOT_OR
Constant for mail filter combination: NOT({filter1} OR {filter2} OR ... AND {filterN}) |
number | FILTER_COMB_OR
Constant for mail filter combination: {filter1} OR {filter2} OR ... OR {filterN} |
Method Summary | |
| add_bcc_filter(p_filter varchar2, p_match boolean)
Adds a filter for the Email recipient attribute CC. |
| add_body_filter(p_filter varchar2, p_match boolean)
Adds a filter to search within the email body. |
| add_cc_filter(p_filter varchar2, p_match boolean)
Adds a filter for the Email recipient attribute TO. |
| add_deleted_filter(p_match boolean)
Adds a filter for the "DELETED" flag of an email. |
| add_from_filter(p_filter varchar2, p_match boolean)
Adds a filter for the Email sender attribute (FROM). |
| add_header_filter(p_header varchar2, p_filter varchar2, p_match boolean)
Adds a filter for any given Email haeder. |
| add_receiveddate_filter(p_filter date, p_comp varchar2, p_match boolean)
Adds a filter for the datetime at which the Email was received by the mail server. |
| add_seen_filter(p_match boolean)
Adds a filter for the "SEEN" flag of an email. |
| add_sentdate_filter(p_filter date, p_comp varchar2, p_match boolean)
Adds a filter for the datetime at which the Email was sent. |
| add_size_filter(p_filter number, p_comp varchar2, p_match boolean)
Adds a filter for the message size. |
| add_subject_filter(p_filter varchar2, p_negative boolean)
Adds a filter for the Email subject. |
| add_to_filter(p_filter varchar2, p_match boolean)
Adds a filter for the Email recipient attribute BCC. |
| clear_filters()
Clears all previously set mail filters. |
| set_filter_combination(p_combination number)
Determines how multiple search filters are to be combined. |
Field Detail |
public number FILTER_COMB_AND
public number FILTER_COMB_OR
public number FILTER_COMB_NOT_AND
public number FILTER_COMB_NOT_OR
Method Detail |
public clear_filters()
public add_from_filter(p_filter varchar2,
p_match boolean)
p_filter
-
The text for search for in the FROM attribute of an email.p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_cc_filter(p_filter varchar2,
p_match boolean)
p_filter
-
The text for search for in the TO attribute of an email.p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_bcc_filter(p_filter varchar2,
p_match boolean)
p_filter
-
The text for search for in the CC attribute of an email.p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_to_filter(p_filter varchar2,
p_match boolean)
p_filter
-
The text for search for in the BCC attribute of an email.p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_sentdate_filter(p_filter date,
p_comp varchar2,
p_match boolean)
p_filter
-
The date to compare with the send date of the email.p_comp
-
Comparison operator: Choose between =, !=, < > <= or >=p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_receiveddate_filter(p_filter date,
p_comp varchar2,
p_match boolean)
p_filter
-
The date to compare with the receiving date of the email.p_comp
-
Comparison operator: Choose between =, !=, < > <= or >=p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_subject_filter(p_filter varchar2,
p_negative boolean)
p_filter
-
The text for search for in the email subject.public add_deleted_filter(p_match boolean)
p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_header_filter(p_header varchar2,
p_filter varchar2,
p_match boolean)
p_header
-
The name of the header field to filter on.p_filter
-
The text for search for in the given header.p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_seen_filter(p_match boolean)
p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_body_filter(p_filter varchar2,
p_match boolean)
p_match
-
true (default): return email matching the filter - false: return all other emailspublic add_size_filter(p_filter number,
p_comp varchar2,
p_match boolean)
p_filter
-
The size to be compared with in bytes.p_comp
-
Comparison operator: Choose between =, !=, < > <= or >=p_match
-
true (default): return email matching the filter - false: return all other emailspublic set_filter_combination(p_combination number)
p_combination
-
Choose one of the 4 predefined constants.
FILTER_COMB_AND: {filter1} AND {filter2} AND ... {filterN} FILTER_COMB_OR: {filter1} OR {filter2} OR ... {filterN} FILTER_COMB_NOT_AND: NOT ( {filter1} AND {filter2} AND ... {filterN} ) FILTER_COMB_NOT_OR: NOT ( {filter1} OR {filter2} OR ... {filterN} )
| PL/SQL Email Client | |||||
SUMMARY: FIELD | TYPE | METHOD | DETAIL: FIELD | TYPE | METHOD |