Email Notification with Table of objects
Re: Email Notification with Table of objects
I always feel better when Henrik agrees
Tom - V8.8 build 3137 - MySql / PostGres
Re: Email Notification with Table of objects
It’s unfortunate that dicking around with this takes up so much time.
https://www.awareim.com/forum/viewtopic ... 70&p=51034
You might try converting to list line, just to see if it runs using your query.
Also check the tomcat output to see if it complains about a syntax issue.
Read that thread About the weirdness of the examples.
And you might not even be happy ultimately with the output of the list table.
Henrik just got improvements to that done a year ago because of a bug.
https://www.awareim.com/forum/viewtopic ... 70&p=51034
You might try converting to list line, just to see if it runs using your query.
Also check the tomcat output to see if it complains about a syntax issue.
Read that thread About the weirdness of the examples.
And you might not even be happy ultimately with the output of the list table.
Henrik just got improvements to that done a year ago because of a bug.
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.
Jaymer
Aware Programming & Consulting - Tampa FL
Jaymer
Aware Programming & Consulting - Tampa FL
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Email Notification with Table of objects
Check out the output of the Aware IM Server after you run the function - there must be some clues there.
Aware IM Support Team
Re: Email Notification with Table of objects
All of the logs indicate everything happened without a hitch. I see no errors or problems.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Email Notification with Table of objects
Gladly. Do you refer to the system.log in the AwareIM\bin folder?
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
-
- Posts: 7559
- Joined: Sun Apr 24, 2005 12:36 am
- Contact:
Re: Email Notification with Table of objects
No, I refer to the output of the Aware IM Server. In the Control Panel select View/Server Console
Aware IM Support Team
-
- Posts: 303
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Email Notification with Table of objects
Did this ever get resolved? I need to do something very similar and want to avoid any traps.
Thanks,
Jim
Thanks,
Jim
Re: Email Notification with Table of objects
It did form me. Say the word and I will describe the path.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
-
- Posts: 303
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Email Notification with Table of objects
That would be great. Fire away.
Re: Email Notification with Table of objects
1. Create an HTML document with your needs.
2. In your notification, select that document for the HTML section of the notification.
3. Here's what my HTML document looks like. Useless to you except how to present a table. It provides some info, then a table of items. You can translate to your needs.
4. let me know if you get stuck.
Hello <<Investigator.FirstName>>,
You currently have <<Count PHS WHERE (PHS.Investigator=Investigator and PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active')>> open investigations:
<<LIST_TABLE(`FIND PHS WHERE (PHS.Investigator=Investigator AND PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active') ORDER By Case_DateOpened DESC`,`CandidateFullName`,`CandidateGroup`,`Case_DateOpened`,`Case_Stage`,`Case_ModifiedTimeStamp`)>>
You currently have <<Count Review WHERE(Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED) >> pending review assignments:
<<LIST_TABLE(`FIND Review WHERE Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED Order by Review.DateStarted`,`CandidateName`,`CandidateGroup`,`DateStarted`,`StartedBy`,`ReviewPurpose`,`NotesToReviewer`)>>
You currently have <<Count Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) >> pending tasks:
<<LIST_TABLE(`FIND Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) Order by Task.DateDue DESC`,`SC_CandidateFullName`,`TaskName`,`Status`,`InitiatedBy`,`DateDue`,`TaskDetails`)>>
2. In your notification, select that document for the HTML section of the notification.
3. Here's what my HTML document looks like. Useless to you except how to present a table. It provides some info, then a table of items. You can translate to your needs.
4. let me know if you get stuck.
Hello <<Investigator.FirstName>>,
You currently have <<Count PHS WHERE (PHS.Investigator=Investigator and PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active')>> open investigations:
<<LIST_TABLE(`FIND PHS WHERE (PHS.Investigator=Investigator AND PHS.Case_Stage<> '7 - Closed' AND PHS.Candidate.Status='Active') ORDER By Case_DateOpened DESC`,`CandidateFullName`,`CandidateGroup`,`Case_DateOpened`,`Case_Stage`,`Case_ModifiedTimeStamp`)>>
You currently have <<Count Review WHERE(Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED) >> pending review assignments:
<<LIST_TABLE(`FIND Review WHERE Review.Reviewer=Investigator AND (Review.Complete<>'Yes' OR Review.Complete IS UNDEFINED) AND Review.Results IS UNDEFINED Order by Review.DateStarted`,`CandidateName`,`CandidateGroup`,`DateStarted`,`StartedBy`,`ReviewPurpose`,`NotesToReviewer`)>>
You currently have <<Count Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) >> pending tasks:
<<LIST_TABLE(`FIND Task WHERE(Task.Investigator=Investigator AND Task.Status<>'Completed' AND Task.Status<>'Abandoned' AND Task.Status<>'Rejected' AND Task.DateInitiated IS DEFINED) Order by Task.DateDue DESC`,`SC_CandidateFullName`,`TaskName`,`Status`,`InitiatedBy`,`DateDue`,`TaskDetails`)>>
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit
-
- Posts: 303
- Joined: Wed Apr 22, 2015 11:44 pm
Re: Email Notification with Table of objects
Well, I think I am stuck. I followed your steps and about the only thing I get is the subject is correct.
Here is what my HTML Document Looks like:
My subject line looks like this and it works:
The email message I receive when I run it looks like this:
Open PASS Reports for James Stephenson
Open PASS Reports Prepared By: <>
Date: <>
You currently have <> open PASS Reports:
<>
The process I run looks like this:
Somewhere I am missing something. What seems odd to me is that even the CURRENT_DATE doesn't show anything.
Here is what my HTML Document Looks like:
Code: Select all
<strong>Open PASS Reports Prepared By: </strong><<PASS_EmployeeReportSummary.Employee.Name>> <br>
Date: <<CURRENT_DATE>><br>
You currently have <<Count PASS WHERE (PASS.PreparedBy=PASS_EmployeeReportSummary.Employee and PASS.ReportProgress.ReportProgress=`Open`)>> open PASS Reports:
<<LIST_TABLE(`FIND PASS WHERE (PASS.PreparedBy=Employee and PASS.ReportProgress.ReportProgress=`Open`) ORDER By Date_Event DESC`,`tempEmployeeName`,`Date_Event_DatePartOnly`,`SummaryOfEvent`)>>
Code: Select all
Open PASS Reports for <<PASS_EmployeeReportSummary.Employee.Name>>
Open PASS Reports for James Stephenson
Open PASS Reports Prepared By: <>
Date: <>
You currently have <> open PASS Reports:
<>
The process I run looks like this:
Code: Select all
FIND PASS_EmployeeReportSummary WHERE PASS_EmployeeReportSummary.scEmployeeStatus='Active' AND PASS_EmployeeReportSummary.Preparer_TotalOpenReports>0 IN BATCHES OF 1
SEND OutgoingEmail_OpenReportsForPreparer TO PASS_EmployeeReportSummary.Employee
Re: Email Notification with Table of objects
Looking at my HTML, I'm using the back-ass apostrophe in some places but not others. Might try that. Don't know about the CURRENT_DATE.
V8.8
MySQL, AWS EC2, S3
PDFtk Toolkit
MySQL, AWS EC2, S3
PDFtk Toolkit