Notifications
Clear all
Topic starter
I am trying to pull an unsigned value for an observation term from one update into another. Is this possible? I thought using LASTOBSVALUE but I am not able to pull it.
Posted : May 17, 2017 10:21 am
If a document is opened and has Obs terms, but is not signed, then no other document has access to those terms. It has caused some headaches for us as well, but we changed our workflows to minimize this happening. now it is a once in a blue moon problem. :/
Posted : May 17, 2017 10:45 am
Only signed values from previous visits can be retrieved via MEL, not unsigned.
Posted : May 17, 2017 10:48 am
Topic starter
I was afraid that would be the answer 🙂 / 🙁
Posted : May 17, 2017 10:50 am
....not via MEL, but a SQL query can be executed against the database to retrieve the value. This is not trivial but doable. Contact me directly if you would like to see this approach.
Posted : May 17, 2017 10:53 am
LIST_OBS(obsTerm, "Pencil", "","") return all obs including unsigned but you will have to loop through the result to get the unsigned value.
Posted : May 17, 2017 12:45 pm
Topic starter
Pencil will give you unsigned observation values, but only from within the same update.
Posted : May 18, 2017 3:40 am
In that case you might have to go to the database. There might be something in meldef files to access database
Posted : May 18, 2017 2:25 pm
You can use the _MelCurObs object from the mldef files to retrieve obs dated after the update was started/in another update.
Posted : May 19, 2017 12:21 pm
I think this is the right answer. There are a few different meldef objects you can use to the pull the data. We have done it successfully for years. You have to loop through the rows though and if you don't exit your loops when you should it can slow down your encounter a lot, like 20-30 seconds for larger charts.
You could also use sql for a more direct lookup, that's what we do now. If you are interested in learning how that could work check out my product in the marketplace.
Posted : May 22, 2017 5:06 am
is there then a away to sign the obs value without signing the visit?
Posted : September 7, 2017 7:57 am
End the update and when putting it on hold, check the box for signing the clinical list changes.
Posted : September 7, 2017 8:04 am
I thought that too, but that's not working.
Posted : September 7, 2017 8:07 am
Topic starter
Unfortunately no. Even by signing the clinical list changes in an update, it does not populate into the flowsheet until the document has been signed.
Posted : September 7, 2017 8:56 am
