Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   Tables in Mirth 3.6.1 (http://www.mirthcorp.com/community/forums/showthread.php?t=218611)

enky123 09-25-2018 09:24 AM

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.

stormcel 09-25-2018 01:36 PM

destination meta id's for each channels' destinations.

enky123 10-04-2018 09:30 AM

@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.

agermano 10-04-2018 12:08 PM

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.

AlexNeiva 10-06-2018 06:20 AM


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.

siddharth 10-07-2018 11:09 PM

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.

agermano 10-08-2018 07:14 AM

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.

All times are GMT -8. The time now is 07:34 PM.

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