web stats
Tables in Mirth 3.6.1 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-25-2018, 08:24 AM
enky123 enky123 is offline
What's HL7?
 
Join Date: Jul 2018
Posts: 3
enky123 is on a distinguished road
Question Tables in Mirth 3.6.1

I am using Mirth 3.6.1. What is the importance/significance of metadata_id in "d_ms" table (Mirth DB) ? I can see the metadata_id having multiple values ([null],0,1,2) for a channel. what do these values signify off ? Also can there be more values as such ? Any help would be appreciated.
Reply With Quote
  #2  
Old 09-25-2018, 12:36 PM
stormcel stormcel is offline
OBX.3 Kenobi
 
Join Date: Mar 2010
Location: Phoenix
Posts: 150
stormcel is on a distinguished road
Default

destination meta id's for each channels' destinations.
Reply With Quote
  #3  
Old 10-04-2018, 08:30 AM
enky123 enky123 is offline
What's HL7?
 
Join Date: Jul 2018
Posts: 3
enky123 is on a distinguished road
Default

@stormcel, can you please elaborate more on this ? There are multiple values ([null],0,1,2), and these seem to be distinctive with respect to source and destination connectors.
Reply With Quote
  #4  
Old 10-04-2018, 11:08 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 841
agermano is on a distinguished road
Default

If you view the destinations in the channel editor, the Id column is the destination meta id to which he's referring. 0 is always the source connector. I don't know which situations would produce a null value.
Reply With Quote
  #5  
Old 10-06-2018, 05:20 AM
AlexNeiva AlexNeiva is offline
Mirth Guru
 
Join Date: Oct 2013
Location: Portugal
Posts: 277
AlexNeiva is on a distinguished road
Default

Hello,

If 0 is Source then probably 1 is Type and 2 is Version. The Null values can be probably set when in that specific channel there is no created metadata column by user.
But this is me assuming! It is a matter of test and check.
__________________
Best Regards,
Alex Neiva
Reply With Quote
  #6  
Old 10-07-2018, 10:09 PM
siddharth siddharth is offline
Mirth Guru
 
Join Date: Feb 2013
Posts: 832
siddharth is on a distinguished road
Default

0 is always the source connector.
Destination1 (D1) is 1, D2 is 2 and so on.
If a destination is deleted the metadataId is also deleted. The next one will be +1 to last metadata id, and not replacement.
__________________
HL7v2.7 Certified Control Specialist!
Reply With Quote
  #7  
Old 10-08-2018, 06:14 AM
agermano agermano is offline
Mirth Guru
 
Join Date: Apr 2017
Location: Indiana, USA
Posts: 841
agermano is on a distinguished road
Default

That's normally true, but you can reorder your destinations or create and delete some and there will be gaps in the numbers. You have to look at the destination tab of the channel at the Id column to know for sure which destination corresponds to each metadata_id.
Reply With Quote
Reply

Tags
database, mirth 3.6.1, mirth database, postgres mirth setup

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 06:10 AM.


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