Announcement

Collapse
No announcement yet.

access to message id in a channel's source

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • access to message id in a channel's source

    Hi:

    We use MirthConnect to get lab results into OpenClinica. We also use Mirth to report out of OpenClinica. You can read about what we do here http://clinicalresearch.wordpress.co...vices-feature/

    We're thinking about ways to more fully integrate the two applications to make things more seamless. Right now, for instance, you have to log into Mirth's admin interface to check on the delivery status of a report derived from results stored in OpenClinica. This is only natural, but it would be nicer to do so within the context of OpenClinica's web interface so people don't have to log into two different interfaces to check up on things.

    So, I suppose, the best way to proceed is to make OpenClinica's database aware of Mirth's. This brings me to my question: can I access the variable ${message.id} within the Source code of a channel? I realize I can do so within a channel's Destination specification, but I'm unclear if I can do so in its Source. My plan is to create a table named 'reportage' that will house both message_id (from Mirth) and event_crf_id (from OpenClinica) and that will be populated using the 'Run On-Update Statement' utility provided in Source (specifically, Database Reader). This table will link events in OpenClinica with messages in Mirth and will thereby provide a means of looking up reporting status within the context of OpenClinica (or, for that matter, events within the context of Mirth).

    Thanks (as always)!

  • #2
    Originally posted by csmith View Post
    Hi:

    We use MirthConnect to get lab results into OpenClinica. We also use Mirth to report out of OpenClinica. You can read about what we do here http://clinicalresearch.wordpress.co...vices-feature/

    We're thinking about ways to more fully integrate the two applications to make things more seamless. Right now, for instance, you have to log into Mirth's admin interface to check on the delivery status of a report derived from results stored in OpenClinica. This is only natural, but it would be nicer to do so within the context of OpenClinica's web interface so people don't have to log into two different interfaces to check up on things.

    So, I suppose, the best way to proceed is to make OpenClinica's database aware of Mirth's. This brings me to my question: can I access the variable ${message.id} within the Source code of a channel? I realize I can do so within a channel's Destination specification, but I'm unclear if I can do so in its Source. My plan is to create a table named 'reportage' that will house both message_id (from Mirth) and event_crf_id (from OpenClinica) and that will be populated using the 'Run On-Update Statement' utility provided in Source (specifically, Database Reader). This table will link events in OpenClinica with messages in Mirth and will thereby provide a means of looking up reporting status within the context of OpenClinica (or, for that matter, events within the context of Mirth).

    Thanks (as always)!
    I think messageObject.getId() will work from a JavaScript context. However, I don't think there is a Message ID yet anywhere on the source connector. It does make sense that there should be one when running the on-update statement, but I don't believe it is in the scope at that point. An easy solution would be to run whatever other update you need to run in the source connector as a JavaScript step, using messageObject.getId().
    Jacob Brauer
    Director, Software Development
    NextGen Healthcare

    sigpic

    Comment

    Working...
    X