web stats
Database Reader - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 10-27-2016, 01:37 PM
DragonQueen DragonQueen is offline
OBX.1 Kenobi
 
Join Date: Aug 2016
Posts: 37
DragonQueen is on a distinguished road
Default Database Reader

I have a select query that returns multiple rows, and I want to map all the rows to a global map to use in a different channel. What is the best approach to do this?
I am using Mirth 3.4.1
Reply With Quote
  #2  
Old 10-27-2016, 11:41 PM
rauchj rauchj is offline
OBX.1 Kenobi
 
Join Date: Feb 2014
Location: Freiburg, Germany
Posts: 43
rauchj is on a distinguished road
Default

Why use Global Map? You could do this by a channel writer -> channel reader connection, even if the destination-channel hat no channel reader as source

for the multiple rows: the standard Database Connector handels each row as a single Message. To keep the results together you might need a custom database connector (javascript reader) as shown here: http://www.mirthcorp.com/community/f...?t=6869&page=2
Reply With Quote
  #3  
Old 11-04-2016, 05:54 AM
DragonQueen DragonQueen is offline
OBX.1 Kenobi
 
Join Date: Aug 2016
Posts: 37
DragonQueen is on a distinguished road
Default

Thank you!
Reply With Quote
Reply

Tags
database reader, global map

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 07:28 AM.


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