Examples of formatted e-mail messages using query function

You can compose formatted e-mail messages that use the query function. You compose these messages using attribute-value pairs or XML tags.

Examples

The following table contains examples of formatted e-mail messages that use the query function. These examples were composed with attribute-value pair and XML. You can use these examples as reference or as a template to create formatted e-mail messages in the E-mail Listeners application.
Table 1. Examples of formatted e-mail messages that use the query function
Description Example
Attribute-value pair query function  
Query a single record with criteria (LSNRWHERECONDITION keyword) 
#MAXIMO_EMAIL_BEGIN
LSNRACTION=QUERY
;
LSNRAPPLIESTO=SR
;
LSNRRESULTCOLUMNS=TICKETID,DESCRIPTION,
REPORTEDBY,COMMODITYGROUP
;
LSNRWHERECONDITION=TICKETID='1001' 
AND SITIED ='BEDFORD'
;
#MAXIMO_EMAIL_END
Query a single record without criteria (LSNRWHERECONDITION keyword) 
#MAXIMO_EMAIL_BEGIN
LSNRACTION=QUERY
;
LSNRAPPLIESTO=SR
;
TICKETID=1002
;
LSNRRESULTCOLUMNS=TICKETID,DESCRIPTION,
REPORTEDBY,COMMODITYGROUP
;
#MAXIMO_EMAIL_END
Query multiple records and return selected columns 
#MAXIMO_EMAIL_BEGIN
LSNRACTION=QUERY
;
LSNRAPPLIESTO=SR
;
LSNRRESULTCOLUMNS=TICKETID,DESCRIPTION,
REPORTEDBY,INTERNALPRIORITY
,REPORTDATE
;
LSNRWHERECONDITION=STATUS ='CLOSED'
;
#MAXIMO_EMAIL_END
Query multiple records and return all columns 
#MAXIMO_EMAIL_BEGIN
LSNRACTION=QUERY
;
LSNRAPPLIESTO=INCIDENT
;
LSNRRESULTCOLUMNS=*
;
LSNRWHERECONDITION=REPORTEDBY='LIBERI'
;
#MAXIMO_EMAIL_END
XML query function  
Query a single record with criteria (LSNRWHERECONDITION tag) 
<MAXIMOEMAILCONTENT>
<LSNRACTION>QUERY</LSNRACTION>
<LSNRAPPLIESTO>PROBLEM</LSNRAPPLIESTO>
<LSNRRESULTCOLUMNS>ticketid,description,
reportedby,affectedperson,commmoditygroup
</LSNRRESULTCOLUMNS>
<LSNRWHERECONDITION>ticketid in ('1001')
<LSNRWHERECONDITION>
</MAXIMOEMAILCONTENT>
Query without criteria 
<MAXIMOEMAILCONTENT>
<LSNRACTION>QUERY</LSNRACTION>
<LSNRAPPLIESTO>PROBLEM</LSNRAPPLIESTO>
<TICKETID>1003</TICKETID>
<LSNRRESULTCOLUMNS>ticketid,description,
reportedby,affectedperson,commmoditygroup
</LSNRRESULTCOLUMNS>
</MAXIMOEMAILCONTENT>
Query multiple records and return selected columns 
<MAXIMOEMAILCONTENT>
<LSNRACTION>QUERY</LSNRACTION>
<LSNRAPPLIESTO>PROBLEM</LSNRAPPLIESTO>
<LSNRRESULTCOLUMNS>ticketid,description,
reportedby,affectedperson,commmoditygroup
</LSNRRESULTCOLUMNS>
<LSNRWHERECONDITION>AFFECTEDPERSON 
= 'RAMSDALE' AND STATUS = 'QUEUED' 
</LSNRWHERECONDITION>
</MAXIMOEMAILCONTENT>
Query multiple records and return all columns 
<MAXIMOEMAILCONTENT>
<LSNRACTION>QUERY</LSNRACTION>
<LSNRAPPLIESTO>INCIDENT</LSNRAPPLIESTO>
<LSNRRESULTCOLUMNS>*</LSNRRESULTCOLUMNS>
<LSNRWHERECONDITION>AFFECTEDPERSON 
= 'SMITH' AND STATUS = 'QUEUED' 
</LSNRWHERECONDITION>
</MAXIMOEMAILCONTENT>