web stats
Database or Javascript Reader to email body - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2015, 12:18 PM
sdswaim71 sdswaim71 is offline
What's HL7?
 
Join Date: Jul 2015
Posts: 2
sdswaim71 is on a distinguished road
Default Database or Javascript Reader to email body

I normally use Mirth to connect to my database and then build an HL7 mesage to be sent off to another listener.

I know need to connect to the database and then build an HTML email body. the way MIRTH normally works, is to send an email for every row returned from the Database. I need to buil the HTML message as a single email.

For instance,

I want to select a list of VisitTypes and their start and stop times

My results look like this

VisitType StartTime StopTime
New PT 08:00 11:30
Est PT 12:00 2:00
ECHO 1:00 3:00


I want to create an html table and put all of the above values into the table and then send this as 1 email (not 3, one for each row)


I have searched the community forum and have not found any help regarding this. I have found some references to using the javascript reader

Any help would be appreciated.

Scott
Reply With Quote
  #2  
Old 12-16-2015, 01:09 PM
sdswaim71 sdswaim71 is offline
What's HL7?
 
Join Date: Jul 2015
Posts: 2
sdswaim71 is on a distinguished road
Default

After much searching through the forums, I was able to figure this out. I am know able to select information from my database (using a JavaScript reader) and then create a single message with all of the results and push that out to an email to multiple users.
Reply With Quote
Reply

Tags
database, email, javascript

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 12:39 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation