web stats
local_channel_id - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Old 03-27-2019, 06:45 AM
samarakj samarakj is offline
What's HL7?
Join Date: Mar 2019
Posts: 1
samarakj is on a distinguished road
Default local_channel_id

Does anyone know where the local_channel_id are located in the mirth db? I inadvertently truncated our channel and d_channels table. I was able to restore the channel table from the channel_snapshot but I'm having trouble with linking the channel table back to the d_channels table because the table is empty.
Reply With Quote
Old 04-17-2019, 07:01 AM
schillert schillert is offline
OBX.1 Kenobi
Join Date: Jul 2012
Posts: 30
schillert is on a distinguished road

A bunch of tables gets created upon saving a new channel all sharing a common suffix. This suffix is the local channel id.
Example: table d_ma36 is the attachment table for the channel with local channel id 36.
This knowledge may not very helpful since you have to deduce from the contents of the data tables to which channel they originally belonged.
Reply With Quote

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 02:03 AM.

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