Re: Creating an Email Template to Search Using a Qualification

[Marquez Rankin]

**

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___