Re: Creating an Email Template to Search Using a Qualification

[Julie Rockwood]

** SMR,

Query templates and results templates are totally different concepts in the Email Engine and it is very confusing that they call them both the templates.  The query template is supplied in the Text field of the Notify Action.  It contains the qualification for the report. The result template resides in the AR System Email Templates form.  It contains the format for the report. See the "Sample HTML result template" in the Remedy Email Engine Guide.  I found the hard way that it does not work (for me anyway) if I begin a line in the result template with #. 
By the way, I'm on 6.3.

Julie

At 09:41 AM 10/23/2006, you wrote:

**
Thank you Julie,
 
I guess my confusion lies at the template level.  What is the content of your template if the text notification contains the query?  Perhaps I'm misreading.
 
-SMR

 
On 10/23/06, Julie Rockwood <[EMAIL PROTECTED]> wrote:

**

SMR,

Here is a slightly updated version (from the August thread "

automatically generate email with report included"

of how I do it.  By using the key rather than a password, anyone who stole the key would only be able to use it to perform email queries. Has anyone else found a more secure way of doing it?

This escalation will eventually create 3 records

in the AR System Email Messages form.  The

outgoing message that the escalation generated

will generate an incoming query which will generate the outgoing
report.


Just have your escalation run the following notify action


Text:

          Server:
$SERVER$

          User:

myMailQueryUser

          Key: myKey

          Schema:
mySchema

          Action: Query

          Result:

myResultTemplate

         
Qualification:

'Create-date' > ($\TIMESTAMP$ - (60*60*24))

User Name: 

[EMAIL PROTECTED]

Mechanism: Email

Subject: Tickets Created Today

Include Fields: None

Reply To:
[EMAIL PROTECTED]


HTH,

Julie



At 09:00 AM 10/23/2006, you wrote: 


** 


This seems like it could work well for simple reporting requirements.
It is detailed in the Email Engine Guide but I have not had success with
this.


 


Has anyone gotten this to work? 


 


 


-SMR


__20060125_______________________This posting was submitted with HTML
in it___ 
__20060125_______________________This posting was submitted with HTML
in it___ 

__20060125_______________________This posting was submitted with HTML in it___

__20060125_______________________This posting was submitted with HTML in it___