I have installed Mirth connect 3.0.3 in our test server successfully. So far everything is working well. Now I want to write a stored procedure in sql server that will email me when there are any errors + queued messages totalling more than 25 within a 1 hour.
My issue is Mirth connect 3, creates it's own tables for each channel.
Ex: When I create the first channel and deploy it, I see the following new tables.
[D_M1]
[D_MA1]
[D_MC1]
[D_MCM1]
[D_MM1]
[D_MS1]
When there is a another channel it goes D_M2, D_MA2...etc.
I want to know how to find the matching tables when a new channel is added with sql without hardcoding and the links between these new tables.
Any help is greatly appreciated.
My issue is Mirth connect 3, creates it's own tables for each channel.
Ex: When I create the first channel and deploy it, I see the following new tables.
[D_M1]
[D_MA1]
[D_MC1]
[D_MCM1]
[D_MM1]
[D_MS1]
When there is a another channel it goes D_M2, D_MA2...etc.
I want to know how to find the matching tables when a new channel is added with sql without hardcoding and the links between these new tables.
Any help is greatly appreciated.
SQL server table links in Mirth connect 3.0.3
0 commentaires:
Enregistrer un commentaire